This project analyses supply chain performance across four critical KPIs using SQL for data extraction and transformation, and Excel for visualisation and dashboard reporting.
The analysis simulates the kind of data-driven decision support A Supply Chain Analyst or Demand Planner would provide operational and commercial teams in a retail or logistics environment.
Retail and logistics businesses often struggle to identify where delays occur, which shipping methods perform best, and which Products drive the most profit. This project addresses those questions using structured data analysis across 2,500 orders.
- SQL (MySQL) — data extraction, transformation and KPI queries
- Excel — data visualisation, charts, and interactive dashboard
- MySQL Workbench — database creation and query execution
- 2,500 synthetic order records modelled on a Global Superstore dataset
- Fields include: order dates, shipping mode, shipping cost, order priority, customer segment, region, product category, sales, profit, discount, and shipping delay
Identified regional variation in average shipping delays to highlight underperforming areas and inform logistics prioritisation.
Compared average delivery times and order volumes across shipping modes to identify the most efficient fulfilment methods.
Ranked products by total profit and profit margin to support inventory focus and targeted commercial decisions.
Assessed whether high-priority orders were being fulfilled faster than standard orders — a key SLA compliance metric.
-
Regional Delivery Gap: The South region outperformed the East by 0.43 days on average (5.37 vs 5.80 days), highlighting regional inconsistencies in fulfilment speed
-
Order Priority Misalignment: High priority orders averaged 5.64 days to ship — actually slower than Critical priority orders at 5.32 days — indicating the priority fulfilment process is not operating as intended and requires review
-
Shipping Mode Efficiency: Same Day shipping achieved the fastest average delivery at 5.39 days compared to Standard Class at 5.67 days, suggesting opportunities to optimise Shipping mode allocation for time-sensitive orders
-
Product Profitability: Analysis across 1,000 products identified the top performers by profit margin to support focused inventory and commercial decisions
- Investigate and address the root causes of delay in underperforming regions
- Prioritise high-efficiency shipping modes for cost and speed optimisation
- Focus inventory and marketing efforts on high-margin products
- Review the order priority fulfilment process to ensure SLA commitments are met
An interactive Excel dashboard consolidates all four KPI views, with dynamic charts that update automatically when the underlying Data is refreshed.
- Integrate inventory and stockout data for a fuller supply chain view
- Add supplier performance metrics, including on-time delivery rates
- Expand to end-to-end delivery tracking from order to final delivery
- Migrate dashboard to Power BI for enhanced interactivity
Complete — open to feedback and collaboration