An interactive Power BI dashboard analyzing global supply chain logistics and profitability for DataCo Operations. This project is built on an optimized star schema with advanced DAX measures to track delivery risks and revenue growth.
The primary file for this project is Dashboard.pbix.
To view the interactive reports and DAX logic, download and open the file using Microsoft Power BI Desktop.
- Total Orders: 180.52K
- Total Revenue (USD): $36.78M
- Total Profit (USD): $3.97M
- Profit Margin %: 10.78%
- Late Delivery Rate: 54.83% (Global Average)
| Region | Status | Key Metric |
|---|---|---|
| Europe | 🟢 Best Region Profit | 29.48% Total Profit Share |
| Pacific Asia | 🔴 Worst Region Delay | Highest average shipping days |
| LATAM | 🔵 Volume Driver | $11.23M Total Sales (Unit) |
- Project File:
Dashboard.pbix(Central Source) - Data Modeling: Optimized Star Schema consisting of 3 Fact Tables (Sales, Shipping, and Orders) and 1 Dimension Table (Customers/Products/Regional mapping).
- Time Intelligence: Integrated a custom Calendar Lookup Table for advanced Year-over-Year (YoY) and Monthly trend analysis.
- DAX Measure Library: Over 15+ custom measures including:
- Profitability:
Total Profit (USD),Profit Margin %(10.78%). - Logistics Risk:
Late Delivery %(54.83% Global Avg),Avg Shipping Days. - Market Performance: Regional Profit Share and Revenue Growth.
- Profitability:
- Visual Design: A professional and consistent Enterprise Blue color palette applied across all reporting pages to ensure analytical clarity.
- Background: Modern gradient backdrop with cyan and teal accents for high visual depth.
- Core Palette: Multi-tonal blue shades (ranging from Light Sky Blue to Deep Navy) used for categorical differentiation in charts.
- UI/UX: Clean slate-gray and off-white card containers with high-contrast typography for maximum KPI readability.
- Optimization: Python-driven CSV preprocessing for faster data refreshes.
├── Dashboard.pbix # Main Power BI Project File
├── data/ # All raw datasets
│ ├── DataCoSupplyChainDataset.csv # Original raw dataset
│ ├── Customers_Data.csv # Customer Dimension
│ ├── Products_Data.csv # Product Dimension
│ ├── Shipping_Logistics_Data.csv # Shipping & Logistics Dimension
│ ├── Sales_Orders_Data.csv # Sales & Revenue Fact Table
│ └── DescriptionDataCoSupplyChain.csv # Dataset description
├── images/ # Dashboard screenshot assets
│ ├── Cover.png
│ ├── Market.png
│ └── Logistics.png
├── dashboard_booklet.md # Detailed project documentation (Obsidian ready)
└── README.md # Project overview
Data Source: Kaggle DataCo Smart Supply Chain Dataset | 180,520 Transactions