This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Product Operations Analyst at Ola. The reliability team has asked you to investigate why trips are being canceled. Build a report that groups all canceled trips by their cancel_reason, showing how many cancellations each reason accounts for, what percentage of total cancellations it represents, and how the cancellations split between rider-initiated and driver-initiated. This root cause analysis will drive improvements to the matching and dispatch system.
You are a Product Operations Analyst at Ola. The reliability team has asked you to investigate why trips are being canceled. Build a report that groups all canceled trips by their cancel_reason, showing how many cancellations each reason accounts for, what percentage of total cancellations it represents, and how the cancellations split between rider-initiated and driver-initiated. This root cause analysis will drive improvements to the matching and dispatch system.