Intermediate · 25 min · 5 steps
Why are so many rides cancelled, and who cancels them?
Arjun Nair, Operations Research Analyst at SwiftRide Mobility
It is Monday, 8:30 AM. Arjun Nair is an operations analyst at SwiftRide Mobility, a ride and auto-rickshaw app that handles over 120,000 trips a day in Bengaluru, Hyderabad and Delhi. He has come to the weekly driver review. The mood is tense. The chief operating officer (COO) shows a big number on the dashboard: a cancellation rate of 45.5 percent for the first week of May.
The question
Why do so many rides get cancelled, how much do banned fraud accounts change the numbers, and who is responsible for the real cancellations?
- Self join pattern
- Joining the same table twice
- Rates
- CASE WHEN
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.