End-to-end logistics & delivery performance analysis for a fictional Bangladeshi distribution company — built entirely in Microsoft Excel (Power Pivot, DAX, PivotTables, Dashboard).
Shohoz Express Ltd. is experiencing a sustained decline in delivery performance, with an overall On-Time Delivery (OTD) rate of just 54.52%—far below the industry benchmark of 85%+. This project analyzes 12 months of shipment data to identify the root causes of delay across carriers, regions, routes, and operational timing. The analysis reveals that the problem is structural rather than seasonal, driven by specific underperforming carriers and route-level inefficiencies. Three targeted, actionable recommendations are provided to guide management's immediate intervention.