A data analytics project focused on identifying the causes of late deliveries and declining customer satisfaction for Porter Delivery, a fast-growing food logistics startup.
Porter Delivery is expanding rapidly but struggling with rising delivery delays and dropping customer satisfaction. Trainee data analysts are tasked with investigating the issue using real delivery and customer data to uncover bottlenecks and support strategic decision-making.
- Analyse delivery performance and delay patterns
- Evaluate courier efficiency and customer ratings
- Identify high-risk regions and peak-time bottlenecks
- Build a dashboard for leadership insights
- Provide actionable recommendations to improve delivery speed
- Delays increase significantly during peak hours
- Certain regions show consistently high delay rates
- Low courier ratings correlate with late deliveries
- Weekends have longer delivery times
- Optimise routes for congested regions
- Assign low-performing couriers to short routes
- Increase staffing during peak hours
- Incentivise on-time performance
Tools used: Excel
