Delivery Performance: Q3 diagnostic for a regional logistics network
Turning 20,451 raw delivery records into a six-page executive report with monthly trends, courier ranking, city concentration and a prioritised action list.
- What was analysed
- 20,451 deliveries across 1,334 cities, 30 active clients and 14 couriers, covering 2025-07-31 to 2025-09-29.
- Tools
- Python (pandas) for analysis. ChatGPT for structuring insights. Custom Python scripts for the PDF layout. Excel for QA checks.
- Outcome
- 95.8% on-time rate confirmed at +0.8 pts above the 95% benchmark. Weakest courier surfaced at 86.1%. Mon to Thu peak sized at 80% of volume, feeding six concrete ops recommendations.