Ola Ride Booking Analysis
An interactive data analytics project evaluating 20,407 ride-booking records across operational efficiency, customer and driver cancellation drivers, vehicle-type economics, and payment preferences using MySQL views and a 5-page Power BI dashboard.
Problem & Objective
The Problem
Ride-hailing operations generate large volumes of multi-dimensional transactional records across bookings, cancellations, vehicle categories, and ratings. Without structured data modeling and diagnostic analysis, operators struggle to isolate cancellation root causes, evaluate vehicle segment profitability, and identify patterns in driver unfulfillment.
Project Objective
Extract actionable operational insights from raw booking logs by writing 10 modular MySQL views and designing an interactive, 5-page Power BI executive dashboard with dynamic filtering across time, vehicle categories, and booking states.
Role & Contribution
Sole Analyst — Responsible for end-to-end data exploration, schema setup, SQL view development, KPI formulation, Power BI dashboard architecture, and report documentation.
Analytical Approach
- 01
Data Modeling & Ingestion: Loaded 20,407 records with 20 transaction dimensions from CSV into a relational MySQL database schema.
- 02
SQL Querying & Reusable Views: Authored 10 modular SQL views in MySQL Workbench to isolate successful rides, compute segment-level distance averages, isolate specific cancellation reasons, calculate rating ranges, filter UPI transactions, and rank top customers by total booking volume.
- 03
5-Page Dashboard Architecture: Developed a structured Power BI report with dedicated pages for Overall Operations, Vehicle Type Breakdown, Revenue & Payment Dynamics, Cancellation Diagnostics, and Customer/Driver Ratings.
- 04
Interactive Cross-Filtering: Configured dynamic date-range slicers and category filters enabling cross-dimensional analysis of booking status across pickup hours and vehicle classes.
Verified Technologies
Verified Findings
Driver Cancellations Outpace Customer Cancellations
Analysis of unfulfilled bookings revealed 3,654 driver cancellations (17.9%) versus 2,081 customer cancellations (10.2%) and 2,020 'Driver Not Found' timeouts (9.9%). The leading driver cancellation driver was 'Personal & Car related issue' (1,263 rides), while customers predominantly cancelled because 'Driver is not moving towards pickup location' (610 rides) or 'Driver asked to cancel' (552 rides).
Cash and UPI Represent Over 95% of Paid Volume
Payment breakdown among successful trips confirmed heavy reliance on Cash (6,934 transactions) and UPI (5,113 transactions). Credit Card payments (480) and Debit Cards (125) represented under 5% combined, indicating that digital payment optimization should target UPI workflows rather than card-based gateways.
Even Vehicle Segment Distribution with Divergent Metrics
Bookings were evenly distributed across 7 vehicle classes (eBike: 2,997, Bike: 2,949, Prime Sedan: 2,945, Prime SUV: 2,945, Auto: 2,916, Mini: 2,867, Prime Plus: 2,788). However, average ride distances and driver-rating minimums diverged markedly between two-wheeler micro-mobility and premium sedan categories.
Dashboard & UI

Executive summary view tracking ride volume over time, overall booking status distribution, and active date filters.

Segment-level comparison analyzing sum of booking value, average ride distance, and total ride volume across vehicle categories.

Revenue distribution across Cash, UPI, and Card channels alongside top 5 customers ranked by cumulative booking value.

Root-cause diagnostic isolating driver cancellation reasons, customer cancellation reasons, and succeeded booking ratios.

Customer satisfaction and driver performance rating comparisons across all 7 vehicle categories.
What I Learned
- Formulating and structuring business questions into clean, reproducible SQL views rather than ad-hoc queries.
- Building executive-ready dashboards in Power BI with multi-level filtering and clear information hierarchy.
- Identifying bottlenecks in supply vs. demand fulfillment through cancellation reason analysis.
- Synthesizing findings into quantitative, business-focused insights suitable for operational stakeholders.