# 🏭 Meridian Consumer Goods Nigeria Ltd — Sales Performance Analysis (2022–2024)
> A comprehensive three-year sales analysis of 205,000+ transactions across
> 8 Nigerian regions — uncovering profit trends, regional gaps, and sales rep
> performance for strategic business decisions.
---
## 📂 Full Dataset & Analysis
📊 Click Here to View & Download the Full Excel File
*Includes: Company Info | Raw Data | Cleaned Data | Pivot Tables | Key Insights*
> ⚠️ **Disclaimer:** Meridian Consumer Goods Nigeria Ltd is an entirely fictional
> company. This dataset was synthetically generated for data analysis portfolio
> purposes only. Any resemblance to real companies is coincidental.
---
## 👨💼 About the Analyst
My name is **Prosper Akoma** — an entrepreneur turned data analyst currently
studying at Codar Tech Institute, Lagos.
Before data analytics, I built a ladies bag business from scratch to **300+ customers**
and achieved a **50% profit increase in just four months** through cost negotiation
and strategic pricing. That business experience taught me how to read numbers
that actually matter — not just report them.
This project is my attempt to apply that same business thinking to a large-scale
FMCG dataset — asking not just *"what happened?"* but *"what should the business do about it?"*
---
## 📌 Project Overview
This analysis simulates a real-world FMCG sales operations dataset for
**Meridian Consumer Goods Nigeria Ltd** — a fictional consumer goods distributor
operating across 8 Nigerian states from 2022 to 2024.
The dataset was intentionally generated with real-world data quality issues
including inconsistent formatting, duplicate records, missing values, text in
number fields, negative quantities, and multiple date formats — reflecting the
kind of messy data analysts encounter daily in Nigerian businesses.
---
## 🧹 Data Cleaning Performed
The raw dataset contained serious quality issues that required extensive cleaning:
| Problem Found | How I Fixed It | …