akomaprospernkemjika/Meridian_FMCG_Sales_Analysis
Domain:
socioeconomicRecord type:
dataset
Creator:
ako
Host:
End-to-end FMCG sales analysis for Meridian Consumer Goods Nigeria — Excel cleaning, Power BI dashboard, business insights
# Meridian Consumer Goods Nigeria Ltd — Sales Performance Analysis (FY2022–2024)
---
## The Story Behind This Project
This project started with a single question a Sales Director might ask on a Monday morning:
> *"How is the business doing — and why?"*
I took a raw, messy AI-generated dataset of over 310,000 FMCG sales transactions
spanning three years, cleaned it from scratch, enriched it with reference data,
answered 10 real business questions, and built an interactive Power BI dashboard
to tell the story visually.
Every step was done manually and deliberately. No shortcuts, no automated cleaning
tools. Just Excel, Power Query, and a commitment to understanding the data before
drawing conclusions from it.
---
## Company Background
**Meridian Consumer Goods Nigeria Ltd** is a fictional FMCG company created
specifically as an AI-generated dataset to test raw capability in both data
analytics and business analytics. The dataset was designed to mirror real-world
Nigerian FMCG business conditions, including inflationary pricing, regional
sales dynamics, trade channel mix, and deliberately introduced data quality
issues that a real analyst would encounter on the job.
The goal was not just to clean numbers, but to think like a business analyst.
To ask not just "what does the data say?" but "what does this mean for the
business, and what should leadership do about it?"
The company distributes products across six categories:
- Edible Oil
- Flour & Meals
- Condiments
- Dairy
- Home Care
- Personal Care
Operating across **6 regions** (Lagos, Abuja FCT, North, South, East, West),
through **6 trade channels** (Modern Trade, Open Market, Distributor, E-Commerce,
Pharmacy, Hotel/Restaurant), with **12 field sales representatives** serving
**360 customers** nationwide.
---
## Dataset
| Property | Detail |
|---|---|
| Transactions | 310,000 raw rows |
| Period | FY2022 – FY2024 |
| Products | 20 SKUs across 6 categories |
| Customers | 360 |
| Sales Reps | 12 |
| …