Supply Chain Logistics Performance Analysis
An end-to-end exploratory data analysis of a real-world supply chain logistics dataset sourced from Brunel University of London. The analysis explores shipment performance, carrier behavior, freight costs, and warehouse utilization across 9,215 orders and 7 relational tables.
Microsoft Excel
SQLite
Tableau
Key Findings
98%
of shipments delivered early or on time across all carriers
95%
of all late shipments attributed to a single carrier (V444_0) despite handling 68% of total volume
$11.4M
estimated freight cost for V444_1, the highest cost carrier with the lowest late shipment rate
$14.8M
estimated warehouse cost for PLANT03, representing the largest single warehouse cost driver
