This project demonstrates a full-stack analysis of supply chain data using Excel, Power BI, Tableau, and SQL. It includes rich visual dashboards and detailed KPIs to provide actionable insights into sales performance, inventory health, and regional trends.
-
📘 Excel Dashboard - My Supply chain Managemen project.xlsx
- Pivot tables and KPIs using Power Pivot & Power Query
- Interactive slicers and visual reporting
-
📊 Power BI Report - Supply Chain Management.pbix
- Dynamic dashboard with custom KPIs: MTD, QTD, YTD
- Product-wise and store-wise insights
-
📈 Tableau Workbook - Supply Chain Management.twbx
- Visualizations of region-wise and top-store sales
- Geographical insights and trend lines
-
🗄️ SQL Script - Supply Chain Management_SQL
- Advanced queries to calculate all key performance indicators
-
📁 Datasets -
-
Total Sales (MTD, QTD, YTD)
Tracks sales from start of month, quarter, and year up to current date. -
Product-wise Sales
Measures performance of individual products and categories. -
Sales Growth
Shows year-over-year or period-over-period growth percentages. -
Daily Sales Trend
Detects daily fluctuations and peak sale days. -
State-wise and Region-wise Sales
Highlights geographic performance across regions and states. -
Top 5 Store-wise Sales
Displays top performing stores based on revenue. -
Inventory Metrics
- Total Inventory
- Inventory Value
- Overstock, Under-stock, Out-of-stock status
-
Purchase Method-wise Sales
Breaks down sales by method: online, in-store, cash, credit, etc.
| Tool | Purpose |
|---|---|
| Power BI | Visual dashboards and KPI analysis |
| Tableau | Geographic and trend-based visuals |
| Excel | Pivot reporting and Power Query |
| MySQL | Backend data querying and metrics |
Excel Dashboard
PowerBI Dashboard
Tableau Dashboard
