Intermediate · 25 min · 4 steps
Finding delivery riders who cancel too many orders
Vikram Malhotra, Fleet Telemetry Analyst at TasteBite Logistics
It is Friday, 8:30 PM. Vikram Malhotra is a data analyst at TasteBite Logistics, a food delivery company with over 45,000 delivery riders in 18 big Indian cities. He is watching the live control room during the dinner rush. On weekends between 7:30 PM and 10:00 PM, orders jump by 300%.
The question
Which delivery riders cancel far more than normal, and what is the true cancellation rate for the whole group?
- Conditional aggregation
- CASE WHEN
- Weighted ratios
- GROUP BY
The rest of this case study is locked
The data, every step with its code and result, and the final answer open with a pass. A few case studies stay free so you can see how they work.