BeginnerFree 5 days · 50 tasks

Last-Mile Delivery SLA Breaches

On-time delivery of an e-commerce courier fell from 87% to 74% in one quarter and clients are claiming penalties. Find which hubs, courier partners, regions and payment modes are behind it and what to fix first.

Dakshin Express Logistics Pvt Ltd · SQL · Python (pandas, seaborn) · solved in your browser

Ready to start?

Create a free account to open the workspace, check your answers and earn a certificate.

The problem

Management does not know how far on-time delivery has fallen, which hubs, partners and regions are responsible, or how much it is costing. The Chief Operating Officer needs a data-backed analysis of shipments picked up from 1 April to 30 September 2026 (Q1 and Q2 of FY 2026-27) to decide where to add capacity, whether to keep the new partner and how to reduce returns.

How it works

Start the project — the 5-day timer begins and the workspace opens with every table loaded.
Solve 50 tasks in SQL or Python (30 basic, 15 intermediate, 5 hard). Each is checked instantly.
Write the final report in the workspace and add charts from your notebook.
Score = 70% tasks + 30% report review. 60 or more earns a certificate.

What you will deliver

Answers to the 50 analysis tasks (30 basic, 15 intermediate, 5 hard), solved with SQL or Python in the JobPrax workspace.
A final report written in the workspace for the Chief Operating Officer: executive summary, data quality, findings and recommendations.
Two to four charts from your Python notebook, added to the report (for example on-time rate by month, by hub and by partner).