🚗 Driver Insights Dashboard Power BI | Data Analytics | Ride-Hailing Industry

Project Overview

A client in the ride-hailing space had 76M in revenue and 148K+ bookings — but zero visibility into WHY rides were failing. No one could explain the cancellations, the incomplete trips, or the growing gap between driver and customer satisfaction.

I built a 5-page interactive Power BI dashboard that answered all of it.

The Problem

The client's data had serious blind spots:

→ Thousands of cancelled rides with no breakdown of fault → Auto & Go Mini vehicles had the highest incomplete ride rate (2.3K and 1.8K) → Driver ratings (4.23 avg) consistently below customer ratings (4.41) across all 7 vehicle types — with no system to catch it → Seasonal revenue dips (Q1 → Q2) were going unnoticed and unplanned → Go Sedan held 24.92% of total booking value — but had no dedicated tracking

What I Delivered

📊 5-page Power BI Dashboard with full interactivity

Overview — Revenue, Booking Ratio, CR by Customer & Driver at a glance

Booking Ratio — VTAT trends across all vehicle types

Revenue by Time — Month-wise & quarter-wise booking price analysis

Cancelling — Cancelled rides breakdown by vehicle type & reason

Cancelling Rides — Incomplete ride root causes + booking value vs distance scatter plot

Plus: Dynamic slicers for Booking Status and Vehicle Type — so the client's team could self-serve their own filters without needing a data analyst every time.

Results & Impact

✅ Operations team can now flag high-cancellation drivers proactively ✅ Vehicle maintenance triggers identified through incomplete ride spikes ✅ CX team has exact cancellation reasons — wrong address, AC issues, driver-asked-to-cancel — with counts, not guesses ✅ Revenue seasonality now visible and plannable quarter by quarter ✅ Fleet resource allocation backed by data (Go Sedan priority confirmed)

Tools Used • Power BI Desktop • DAX (custom measures & KPIs) • Power Query (data cleaning & transformation)

Looking for similar work? If you have messy data and need a dashboard that actually tells a story — let's talk. I specialize in turning raw operational data into clear, decision-ready visuals.