IamTemitope/Naija-Beverage-Sales-Insights
Domain:
socioeconomicRecord type:
dataset
Creator:
Iam
Host:
A SQL-based FMCG case study analyzing sales, distribution, and promotions for a simulated Nigerian beverage company. Features realistic datasets, ERD design, and queries uncovering insights like Lagos vs Abuja market performance, top-selling products, and promotion impact.
# BeverageCo Nigeria: Sales & Distribution Analytics
## 📌 Project Overview
BeverageCo Nigeria is a simulated FMCG case study designed to analyze sales, distribution, and promotional performance for a leading beverage company operating in Nigeria. The project models realistic datasets and uses SQL to uncover actionable insights such as **Lagos vs Abuja market performance**, top-selling products, and the impact of promotions.
---
## 🛠️ Project Objectives
- Design a relational database schema for FMCG sales operations.
- Populate tables with realistic Nigeria-based sales & distribution data.
- Use SQL to generate actionable business insights.
- Perform advanced queries for market, product, and distributor analysis.
---
## 🗂️ Database Schema (ERD)
*Entity Relationship Diagram showing Products, Distributors, Customers, Orders, and Inventory.*
---
## 📊 Dataset Description
The database contains the following tables:
| Table Name | Description |
|------------------|-------------|
| `products` | List of beverages with category, size, and price. |
| `customers` | Retailers, supermarkets, and vendors across Nigeria. |
| `distributors` | Regional distributors responsible for delivery. |
| `orders` | Sales transactions with product, quantity, and date. |
| `order_details` | Breakdown of each order’s items. |
| `promotions` | Discounts and campaigns applied to products. |
| `inventory` | Stock levels per distributor. |
---
## 💡 Example Business Questions
- Which city generates the most revenue: **Lagos or Abuja**?
- What are the **top 5 best-selling products** in Nigeria?
- Which **product category** has the highest sales volume during promotions?
- Which distributors have the **highest market share**?
- What is the **inventory turnover rate** per region?
---
## 🧮 Sample SQL Queries
```sql
-- Lagos vs Abuja Revenue
SELECT city, SUM(total_amount) AS total_revenue
FROM orders
JOIN customers USING(customer_id)
GROUP BY city
HAVING ci …
Similar
Adeola-insights/-Electronics-Product-Sales-DashboardTanzania Annual Sales - Dar SalesTHE ROLE OF HOLISTIC MARKETING IN ENHANCING SALES PERFORMANCE: INSIGHTS FROM THE NIGERIAN BREWERY INDUSTRYedocII/castel-beverage-classifierNaija-Guru/naija-guru-webImpact Evaluation of Data Analytics Tools in E-commerce Business Insights Enhancement in Accra, Ghana: Sales Growth Indices Assessment