Uber Operations & Booking Leakage Analytics

Overview

An end-to-end Power BI analytics solution built on 150K+ booking records to evaluate operational performance, revenue trends, and lost booking root causes. The dashboard features executive-level KPIs ($51.8M revenue, 93K completed rides) alongside deep-dive diagnostic visuals isolating why 38.2% of total bookings were lost—highlighting that 47.5% of leakage stems from driver cancellations.

The challenge

Uber operational leaders lacked visibility into ride cancellation patterns, revenue leakage channels, and spatial demand bottlenecks, hindering targeted retention strategies for both customers and drivers.

What I did

• Modeled and cleaned a 150K+ row operational dataset covering completed, cancelled, and incomplete bookings.
• Designed an executive KPI home dashboard tracking total revenue ($51.8M), average order value ($560), and ride volume across quarters.
• Engineered dynamic DAX measures to quantify lost booking rates, driver cancellation rates (47.5%), and customer cancellation rates (18.5%).
• Visualized spatial ride distribution across top pickup/drop-off locations and driver/customer ratings.
• Formatted custom dark-mode visual themes for high-contrast presentation and seamless visual navigation.