akomaprospernkemjika/Meridian-Consumer-Goods-Nigeria-Ltd-Sales-Performance-Analysis-2022-2024-
Domain:
socioeconomicRecord type:
dataset
Creator:
ako
Host:
# 🏭 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 | …
Similar
Directors Tunneling and Performance of Quoted Consumer Goods Firms in NigeriaFinancial Structure and Performance of Quoted Consumer Goods Firms in NigeriaAssets mix and financial performance of listed consumer goods firms in nigeriaSustainability Reporting and Financial Performance of Quoted Consumer Goods Companies in NigeriaCORPORATE SIZE AND FINANCIAL PERFORMANCE: EVIDENCE FROM QUOTED CONSUMER GOODS FIRMS IN NIGERIAIntellectual Capital and Financial Performance of Selected Consumer Goods Manufacturing Firms in Nigeria