This project is part of the Microsoft Power BI Specialist Track graduation requirements. It aims to evaluate and visualize the overall performance of a Supply Chain utilizing Microsoft Power BI. The report provides insights into inefficiencies and identifies opportunities for improvement across operations, manufacturing, and logistics.
The main goal is to enable stakeholders to track key metrics, including:
- Supply Chain Efficiency: Monitoring order, manufacturing, and shipping processes.
- Supplier Performance: Identifying reliable suppliers and analyzing defect rates.
- Transportation Optimization: Comparing costs and shipping times across different modes (Air, Road, Sea, Rail).
- Customer Demand: Analyzing sales based on demographics and locations.
- Microsoft Power BI: For data visualization and dashboarding.
- Power Query: For data cleaning and transformation (ETL).
- DAX: For creating measures and calculated columns.
- Figma: For designing the report layout and UI mockups.
The data is organized in a Star Schema containing:
- Fact Table:
Fact_SupplyChain(Costs, Availability, Defect Rates, etc.). - Dimension Tables:
Dim_Products,Dim_Customers,Dim_Location,Dim_Transportation,Dim_ShippingCarriers.
The report consists of 6 comprehensive pages:
- Supply Chain Operations
- Performance Overview
- Product Performance
- Supplier & Manufacturing
- Transportation Overview
- Customer Demographics
- Clone the repository.
- Open the
supply_chain_V1.pbixfile using Power BI Desktop. - Explore the interactive visuals and filter data by product, location, or supplier.