This project features a comprehensive Power BI Dashboard designed to monitor and optimize inventory management and supply chain performance. The dashboard provides stakeholders with real-time visibility into warehouse efficiency, transportation costs, and inventory health to drive data-informed decision-making.
The dashboard tracks several critical supply chain metrics:
- Warehouse Utilization (34.08%): Monitors the percentage of warehouse capacity currently in use to optimize storage space.
- Days Sales of Inventory (15.6): Measures how many days it takes for inventory to be sold, helping to identify stock liquidity.
- Inventory Turnover (23.47): Evaluates how often inventory is replaced over a specific period.
- Warehouse Utilization Gauge: A visual representation of current capacity versus a 75.00% target threshold.
- Transportation Cost by Region & Category: A clustered column chart identifying which regions (North, West, East, South) and product categories (Accessories, Clothing, Electronics, Furniture) incur the highest shipping costs.
- Units Sold Trend: A line chart visualizing sales performance from 2020 to 2024, highlighting a significant recovery post-2021.
- Lead Time Analysis: A donut chart showing the average lead time (in days) across different product categories to pinpoint potential bottlenecks in the procurement cycle.
- Backorder Tracking: A bar chart displaying order status (Fulfilled, Pending, Canceled) to monitor fulfillment reliability.
- Dynamic Filtering: Slicers for Region and Category allow users to drill down into specific segments of the supply chain.
- Tool: Power BI Desktop
- Data Transformation: Power Query (M) used for data cleaning and handling date-locale conversions.
- Data Modeling: Implementation of star schema principles for optimized query performance.
- DAX: Utilized for creating calculated columns and measures such as Inventory Turnover and Warehouse Utilization.
The model utilizes a comprehensive dataset including:
| Column Name | Description |
|---|---|
Warehouse Utilization |
Calculated percentage of used storage capacity. |
Lead Time (Days) |
Time taken from order placement to delivery. |
Backorder |
Count of units currently on backorder. |
Transportation Cost |
Total cost associated with shipping goods. |
Order Accuracy |
Percentage of orders fulfilled without errors. |
- Download the
.pbixfile from this repository. - Open the file using Power BI Desktop.
- Ensure you have the latest version of Power BI to support all visual components.