Transportation & Mobility/Personal Analytics Project

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.

Total Bookings Analyzed20,407Complete July booking logs with 20 operational columns
Booking Success Rate62.0%12,652 rides successfully completed out of 20,407 total requests
Driver Cancellation Rate17.9%3,654 rides cancelled by drivers; largest unfulfilled category
Cash & UPI Share>95%Cash (6,934) and UPI (5,113) dominate payment methods over cards
01 / CONTEXT

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.

02 / OWNERSHIP

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.

03 / METHODOLOGY

Analytical Approach

  1. 01

    Data Modeling & Ingestion: Loaded 20,407 records with 20 transaction dimensions from CSV into a relational MySQL database schema.

  2. 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.

  3. 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.

  4. 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.

04 / STACK

Verified Technologies

Data Analysis & Querying
MySQLSQL ViewsAggregate FunctionsData Filtering
Business Intelligence & Visualization
Microsoft Power BIKPI Card DesignCross-FilteringDashboard Layouts
Data Storage & Tools
CSV (20,407 records)MySQL WorkbenchGitGitHub
05 / INSIGHTS

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.

06 / VISUALS

Dashboard & UI

Ola Power BI Dashboard — Overall Operations View

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

Ola Power BI Dashboard — Vehicle Type Breakdown

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

Ola Power BI Dashboard — Revenue and Payment Methods

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

Ola Power BI Dashboard — Cancellation Diagnostics

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

Ola Power BI Dashboard — Rating Metrics

Customer satisfaction and driver performance rating comparisons across all 7 vehicle categories.

07 / REFLECTION

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.