olasubomi-08/nigeria-retail-sales-dashboard
Domaine:
socioeconomicCréateur:
ola
Hôte:
Interactive Excel dashboard analyzing 2,000+ retail transactions across Nigeria — tracking revenue, profit, and sales performance by region, product, and sales rep.
# 📊 Nigeria Retail Sales Performance Dashboard — Excel
An interactive Excel dashboard analyzing **2,098 retail sales transactions** across four Nigerian regions from **January–May 2025**. Built entirely in Microsoft Excel using **PivotTables, PivotCharts, formulas, and Slicers** to uncover revenue, profit, customer, product, regional, and sales-rep performance.
## 📌 Project Overview
This project transforms a raw transactional sales dataset into an interactive business dashboard designed to answer key retail-performance questions.
The analysis explores:
* Which regions and cities generate the highest revenue and profit?
* Which product categories contribute most to overall performance?
* How do **Online vs. In-Store** sales compare?
* Who are the top-performing sales representatives?
* How does **Retail vs. Corporate** customer performance differ?
* What does the monthly sales trend reveal?
## 🗂️ Repository Structure
```text
sales-analysis-nigeria-2025/
├── README.md
├── excel/
│ └── Sales_Analysis_Dashboard.xlsx
├── data/
│ └── sales_data.csv
└── images/
└── dashboard_preview.png
```
> The Excel workbook contains the complete project, including the raw data, PivotTables, analysis, and interactive dashboard. The CSV is provided separately to make the dataset easier to preview or reuse in other tools such as Python, Power BI, or Tableau.
## 🧾 Data Dictionary
The dataset contains **2,098 transaction records** and 15 columns:
| Column | Description |
| --------------- | ------------------------------------------ |
| `Date` | Transaction date |
| `Region` | North, South, East, or West |
| `City` | Lagos, Kano, Abuja, or Port Harcourt |
| `Customer Type` | Retail or Corporate |
| `Channel` | Online or In-Store |
| `Product` | Product/item sold |
| `Category` | …