Statistics Graduate · Data Analyst · Ibadan, Nigeria

Margaret
Adebayo

I transform raw operational data into dashboards and insights that help businesses make faster, better decisions.

Statistics graduate with hands-on experience in Excel, SQL, Power BI and Python — currently building end-to-end analytics projects and transitioning into Data Science.

4.12
GPA — Statistics
4
Portfolio Projects
700+
Rows Processed Daily
3K
Employees Analysed
MA
Who I Am

About Me

I am a Statistics graduate from FUOYE who genuinely enjoys working with data — not just the clean, tidy kind, but the messy, real-world kind that takes time to understand before it starts making sense.

I did my Industrial Training at Fan Milk Nigeria, worked as hard as I could, and built a strong enough track record that I was invited back for my NYSC posting. During my NYSC, I worked directly with the Logistics Manager — supporting transport operations, KPI reporting and supply chain performance analysis across the national distribution network.

Right now I process over 700 rows of data every day, monitor Case Fill Rate across 9 Distribution Centres, and produce weekly reports that senior management reads and uses. I am also learning Python and working towards a Master's in Data Science — because I want to move beyond describing what happened to predicting what will happen next.

DegreeB.Sc. Statistics — FUOYE
GPA4.12 / 5.0 — 2nd Class Upper
LocationIbadan, Nigeria
Current RoleAsst. Performance Manager
Currently LearningPython for Data Science
GoalMSc Data Science — 2027
RAIN Scholarship2026 Awardee — AIML Programme
LanguagesEnglish · Yoruba · French
What I Use

Skills

Tools I work with every day — not just listed, actually used in real projects.

📊
Microsoft Excel
Pivot Tables · SUMIFS · VLOOKUP · Conditional Formatting · Slicers · Dashboard Design
📈
Power BI
Data Modelling · DAX · Interactive Dashboards · Multi-page Reports
🗄️
SQL
Querying · Filtering · Aggregation · Joins · Data Analysis
🐍
Python
Pandas · NumPy · Matplotlib · Functions · Loops (Learning)
🧹
Data Cleaning
Standardisation · Duplicate Removal · Validation · Error Handling
📋
KPI Reporting
Executive Reports · Stakeholder Presentations · Weekly Reporting
My Work

Projects

Four end-to-end projects — real data, real findings, real recommendations. Click any image to zoom.

Project 01
KFC Sales Performance Analysis
Microsoft Excel Pivot Tables Dashboard Design Executive Reporting
KFC Sales Dashboard KFC Executive Insight Report
What This Project Is About

Built an end-to-end KFC Nigeria sales analytics solution — cleaning 500 transaction records in Excel, building 6 pivot table analyses, and developing an interactive dashboard with an executive insight report. The goal was to give management a clear picture of what was driving revenue and what was holding it back.

The Business Problem

The business had sales data but no structured view of performance. Which product was making the most money? Which branch was underperforming? Were customers returning? I built a dashboard that answers all of this in one place — with slicers to filter by branch and month.

The Data

500 sales transactions from January to December 2023 across 8 KFC Nigeria branches — including product names, categories, branch locations, payment methods, customer ratings, quantities and prices. Total revenue: ₦3.02M.

Key Findings
Total revenue hit ₦3.02M for the full year
Chicken Bucket was the highest revenue product at ₦660,000 — well ahead of all others
42% of customers only visited once — a significant retention gap the business needs to address
POS was the most preferred payment method at 29%
Ibadan (₦451,900) and Abuja (₦442,200) were the top performing branches
August was the peak sales month at ₦331,700
Recommendations
01
Launch a loyalty programme — converting 10% of one-time buyers would add significant revenue
02
Bundle Chicken Bucket with Crunchy Chicken to boost both volume and average order value
03
Run targeted promotions in August when customers are already in buying mode
04
Study what Ibadan and Abuja branches are doing and apply it across all locations
Skills Demonstrated
Data CleaningPivot TablesPivot ChartsSlicersKPI CardsDashboard DesignExecutive ReportingBusiness AnalysisData Storytelling
Project 02
HR Employee Performance & Training Analysis
Microsoft Excel SQL Power BI DAX
HR Employee Performance Dashboard
What This Project Is About

Built an end-to-end HR analytics solution by cleaning 3,000 employee records in Excel, analysing them with SQL, and developing a 2-page interactive Power BI dashboard — one page for the main dashboard, one dedicated page for key insights and recommendations. Total training budget analysed: $1.68M.

The Business Problem

The organisation was spending $1.68M on training without knowing if it was working. Which departments had the best engagement? Were employees actually finishing their training? Was there a relationship between age, performance and satisfaction? I dug into all of it.

The Data

3,000 employee records across 6 departments — Production, IT/IS, Sales, Software Engineering, Admin Offices, Executive Office. Fields: performance ratings, engagement scores, satisfaction scores, training costs, training outcomes, work-life balance scores, age, gender and employment type.

Key Findings
Production gets 67% of staff and $1.13M of the training budget — but has the lowest engagement score at 2.91/5. The investment is not producing results.
Only 25.67% of employees completed their training. Over 50% are incomplete or have not started.
Employees rated "Exceeds" are on average 2 years younger than those rated "Needs Improvement"
Full-Time employees score 3,089 on work-life balance vs 2,921 for Part-Time — a 168-point gap
Recommendations
01
Audit training effectiveness in Production — $1.13M with the lowest engagement is not acceptable
02
Implement mandatory training completion tracking — 74% incomplete rate needs urgent attention
03
Launch a mentorship programme pairing high and low performers across departments
04
Review Part-Time policies to close the work-life balance gap and reduce turnover risk
Skills Demonstrated
Excel Data CleaningSQL QueriesPower BIDAX MeasuresMulti-page ReportsHR AnalyticsStatistical InsightData Storytelling
Project 03
Superstore Sales Dashboard
Microsoft Excel Power BI Data Modelling
Superstore Sales Dashboard
What This Project Is About

A multi-year sales analysis of a global superstore chain covering 2011 to 2014 — across multiple regions, product categories and markets. I cleaned the data in Excel then built an interactive Power BI dashboard with filters for year, region and category. Total sales: $13M.

Key Findings
$13M in total sales, $1.47M profit and 25,040 orders across 4 years
Technology is the most profitable category — $5M in sales and highest margins
Canon imageClass 2200 is the single most profitable product
Sales peaked consistently in Q3 and Q4 every year — a clear seasonal pattern
South region leads all regions in both sales and profitability
Recommendations
01
Increase investment in Technology — the margins justify it
02
Study what the South region is doing differently and replicate it elsewhere
03
Plan inventory and promotions around the consistent Q3/Q4 peak
Skills Demonstrated
Excel CleaningPower BIData ModellingInteractive FiltersTrend AnalysisRegional Analysis
Project 04
Video Game Sales Analysis
Power BI Data Visualisation Market Analysis
Video Game Sales Dashboard
What This Project Is About

Four decades of global video game sales — from 1980 to 2022 — analysed across regions, consoles, publishers, developers and genres. I built a Power BI dashboard that makes it easy to see which platforms dominated, which markets spent the most, and how the industry shifted over time.

Key Findings
North America accounts for over 50% of global revenue — the dominant market by a wide margin
PS2 leads all consoles with over 52.5% of total sales volume
Revenue peaked between 2008 and 2010 before a sustained decline through 2020
GTA dominates North America; FIFA leads Africa and Japan — different markets want different games
Recommendations
01
Publishers should prioritise North American market strategies — it drives half of all global revenue
02
Console exclusives matter — PS2's dominance shows platform loyalty drives massive long-term sales
03
Regional marketing is essential — a one-size-fits-all approach misses major market opportunities
Skills Demonstrated
Power BITime Series AnalysisRegional AnalysisMarket AnalysisData VisualisationTrend Analysis
Where I Have Worked

Experience

Two years at the same company — invited back because I earned it.

2025 — Present
Fan Milk Nigeria · NYSC
Assistant Performance Manager
  • Process 700+ rows of operational data daily — monitoring Case Fill Rate across 9 Distribution Centres nationwide
  • Build weekly Excel and Power BI reports used directly by senior management to make supply chain decisions
  • Catch supply gaps early using threshold-based Excel alerts before they become shortages
  • Analyse damages and shortages weekly and present findings in management meetings
  • Worked directly with the Logistics Manager — supporting transport operations, KPI reporting and supply chain performance analysis
2024
Fan Milk Nigeria · Industrial Training
Data & Logistics Analyst Intern
  • Tracked truck turnaround times and transport KPIs daily — turned raw gate records into clean, structured reports
  • Maintained live KPI dashboards for the transport operations team
  • Built a strong enough track record to be invited back for NYSC posting
Recognition

Achievements

A few things I am proud of.

🏆
RAIN 2026 Scholarship Awardee
Awarded a partial scholarship by Robotics and Artificial Intelligence Nigeria for the AIML Programme, selected through a competitive national screening exam.
📊
Logistics Manager Collaboration
During my NYSC at Fan Milk Nigeria, worked directly with the Logistics Manager on supply chain analytics and KPI reporting, a role secured through demonstrated data skills.
📐
B.Sc. Statistics — GPA 4.12
Graduated Second Class Upper in Statistics from the Federal University Oye-Ekiti (FUOYE) with a GPA of 4.12 out of 5.0.
Get In Touch

Open to
opportunities.

Open to data analyst roles, freelance projects, collaborations and conversations about data science. If you think there is something we can work on together — reach out.

Send an Email