This repository contains an interactive Power BI dashboard designed to provide insights into various supply chain metrics. The dashboard integrates real-time data from MSSQL Server and covers key performance indicators (KPIs) such as sales, shipping performance, order status, customer insights, and product KPIs.
The Power BI dashboard consists of several sections that allow for dynamic interaction and drill-down into the supply chain data. Below are the primary features:
- Total Sales: 36.78M
- Average Sales per Customer: 183.11
- Average Profit per Order: 21.97
- Top Countries by Sales: USA, France, Mexico, etc.
- Sales per Payment Method: Debit, Transfer, Payment, and Cash.
- Average Days for Scheduled Shipment: 2.93
- Average Days for Real Shipment: 3.50
- Count of Orders by Delivery Status: Late delivery, On-time, Shipping Canceled.
- Number of Customers: 180.519K
- Total Sales by Customer Segment: Corporate, Consumer, Home Office.
- Relation between Number of Customers and Sales Over Time.
- Count of Orders by Order Status: Complete, Pending Payment, Processing, etc.
- Top Orders by Region: Central America, Western Europe, Southeast Asia.
- Total Sales by Market: LATAM, Europe, Pacific Asia, USCA, and Africa.
-https://www.kaggle.com/datasets/shashwatwork/dataco-smart-supply-chain-for-big-data-analysis
- Data Source: Integrated from MSSQL Server for real-time analytics.
- Interactivity: Users can interact with the charts to explore data trends dynamically.
- Performance Tracking: Visualizes the relationship between sales, profit, discount rates, and delivery status.
- Clone this repository to your local machine.
- Open the
.pbixPower BI file. - Ensure you have access to the MSSQL Server instance with the necessary credentials.
- Refresh the data to view the most recent insights.
If you'd like to contribute or suggest any improvements, feel free to create an issue or submit a pull request.