E2E-Sales-Customer-Analytics-Dashboard-End-to-End-pipeline-with-Python-MySQL-Power-BI-/ReadMe.txt at main · Tanu272004/E2E-Sales-Customer-Analytics-Dashboard-End-to-End-pipeline-with-Python-MySQL-Power-BI- · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
# 📊 End-to-End Sales & Customer Analytics Dashboard

## 🚀 Project Overview
This project demonstrates a **complete data analytics pipeline** from data generation to business insights.
It integrates **Python**, **Azurite (Azure Blob Storage Emulator)**, **MySQL**, and **Power BI** to deliver a fully interactive dashboard with drill-through capabilities.

---

## 🛠 Tech Stack
- **Python** – Automated data generation & ETL
- **Azurite** – Local Azure Blob Storage simulation
- **MySQL** – Relational database for structured storage
- **Power BI** – Interactive dashboard & analytics

---

## 📂 Project Workflow

1. **Data Generation (Python)**
   - Synthetic datasets for Customers, Orders, Shipments, and Products.
   - Controlled randomness to ensure realistic trends.

2. **Cloud Storage Simulation (Azurite)**
   - Datasets uploaded to local Azure Blob storage for cloud ETL simulation.

3. **Database Storage (MySQL)**
   - Normalized schema with primary & foreign key constraints.
   - SQL scripts for table creation and data insertion.

4. **Visualization (Power BI)**
   - KPI Cards: Total Revenue, Orders, Shipments.
   - Trend Charts: Monthly Revenue, Sales by Region.
   - Slicers: Interactive filtering by Date, Region, and Customer.
   - Drill-through Page: Detailed view of individual customer’s purchase history.

---

## 📈 Key Insights
- **Top 10 Customers** contribute **₹X,XX,XXX (~45%)** of total revenue.
- **Region A** faces the highest shipment delays (~Y days avg.).
- **Category Electronics** dominates high-value purchases.
- Monthly revenue peaks observed in **November–December**.

---

## 📸 Dashboard Preview
*(Add your dashboard screenshots here)*

---

## 🧑‍💻 Setup Instructions

### 1️⃣ Clone Repository
```bash
git clone https://github.com/your-username/sales-customer-analytics.git
cd sales-customer-analytics

Lets Connect:
LinkedIn: https://www.linkedin.com/in/tanmay-sharma-800599373/
Github: https://github.com/Tanu272004/E2E-Sales-Customer-Analytics-Dashboard-End-to-End-pipeline-with-Python-MySQL-Power-BI-.git