Skip to content
View ismailolatunji's full-sized avatar

Block or report ismailolatunji

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
ismailolatunji/README.md

Executive Summary

Data & BI Analyst with 7+ years of commercial experience delivering SQL, Python and Power BI solutions that improve operational efficiency, marketing performance and business visibility.

I design structured KPI architectures, automate reporting pipelines and build analytical systems that support measurable decision making.


Proven Impact

  • Reduced reporting cycle time by 50 percent through Python and SQL ETL automation
  • Improved operational efficiency by 40 percent via redesigned KPI dashboards across 30+ Power BI reports
  • Increased campaign response rates by 40 percent using churn prediction and RFM segmentation
  • Improved reporting reliability to 99 percent through structured data validation controls
  • Built scalable performance tracking systems supporting growth from 5 to 80+ staff

Over seven years at Quick Choice, I progressed from Customer Service to Marketing Analytics and Operations Analytics. This cross-functional experience built strong commercial judgement alongside technical depth.

I completed an MSc in Data Analytics in 2024, strengthening capability in machine learning, large-scale data processing and statistical modelling.


Analytical Capability Demonstrated Through Case Studies

Predictive Risk & Modelling Systems

Road Traffic Collision Risk Intelligence

End-to-end modelling project using 22,000+ UK public collision records to identify environmental and behavioural severity drivers.

  • Engineered structured dataset from raw public records
  • Applied Logistic Regression, Random Forest and Gradient Boosting models
  • Achieved 97 percent classification accuracy
  • Translated outputs into interactive Power BI dashboards

View Project


Public Sector Performance Benchmarking

EHCP Phonics Attainment Gap Analysis

Multi-year benchmark analysis comparing EHCP attainment against national averages.

  • Identified sustained 11 percent attainment gap
  • Highlighted data quality inconsistencies
  • Structured outputs for strategic intervention planning

View Project


Regional Economic & Energy Benchmarking

CPCA Renewable Installations & Generation (2014–2024)

Longitudinal benchmarking of renewable installations growth and regional contribution to UK generation.

  • Analysed 10-year growth trajectory
  • Benchmarked regional share against national totals
  • Designed reusable monitoring framework

View Project


Scalable Data Processing Architecture

Crime Pattern & Geospatial Trend Analysis

Distributed processing of 10+ years of UK police crime data using PySpark.

  • Built scalable transformation workflows
  • Identified geographic concentration hotspots
  • Structured outputs for planning and resource allocation insight

View Project


Executive KPI & Commercial Reporting

Sales Performance Dashboard

Interactive executive dashboard for revenue and operational performance monitoring.

  • Designed structured KPI framework
  • Built Power Query data transformation layer
  • Delivered leadership-ready reporting

View Project


Marketing Performance & Segmentation Analytics

Predictive modelling and segmentation project focused on retention and campaign optimisation.

  • Built churn prediction models
  • Designed RFM segmentation framework
  • Improved response rates by 40 percent

Technical Stack

SQL • Python • Power BI • Excel • PySpark • BigQuery • GA4
Predictive modelling • KPI design • Data validation • A/B testing • Geospatial analysis

Currently developing Azure Data Engineering capability through structured hands-on projects.

Pinned Loading

  1. EHCP-Phonics-Attainment-Gap-Analysis-Medway EHCP-Phonics-Attainment-Gap-Analysis-Medway Public

    Multi-year benchmark analysis comparing EHCP phonics attainment in Medway against national averages, highlighting persistent performance gaps and system-level risk factors.

  2. Road-Traffic-Collision-Analysis-in-Cambridgeshire-UK Road-Traffic-Collision-Analysis-in-Cambridgeshire-UK Public

    Predictive modelling and interactive Power BI dashboard analysing 22,000+ UK collision records to identify severity risk drivers and support data-led safety planning.

    Jupyter Notebook

  3. CPCA-Renewable-Energy-Installations-Generation-Analysis CPCA-Renewable-Energy-Installations-Generation-Analysis Public

    Ten-year regional renewable energy benchmarking analysing installation growth and CPCA contribution to UK generation, with reusable performance monitoring framework.

  4. Crime-Analysis-Using-PySpark-and-Python Crime-Analysis-Using-PySpark-and-Python Public

    Distributed analysis of 10+ years of UK police crime data using PySpark to identify geographic concentration patterns and long-term trend dynamics.

    Jupyter Notebook

  5. Interactive-Excel-Dashboard-In-Depth-Sales-Performance-Analysis Interactive-Excel-Dashboard-In-Depth-Sales-Performance-Analysis Public

    Executive KPI dashboard delivering structured revenue, product and operational performance visibility using Excel and Power Query.