This project features an Excel-based interactive dashboard built using Uber’s 2024 dataset containing over 1 million rows of ride data. The dashboard consolidates large-scale data into actionable insights on bookings, revenue, vehicle types, cancellations, and ratings, presented with a design aligned to Uber’s brand style.
The dashboard was developed to analyze Uber ride data across different dimensions such as revenue, vehicle type, cancellations, and ratings. It delivers clear, data-driven insights and allows interactivity through slicers (Quarter/Month) to evaluate business performance effectively.
- Excel (Pivot Tables, Charts, Dashboard Layout)
- Power Query (Data cleaning & preprocessing)
- Power Pivot (Data modeling)
- Slicers & Interactivity (Quarter / Month filters)
- Total bookings, total revenue, ride volume trend, booking status breakdown.
- Ride distance distribution, revenue by payment method, top 5 customers.
- Booking values, successful bookings, avg. distance, total distance (by vehicle category).
- Cancellation trends and reasons (by customer/driver/no driver found).
- Customer and driver ratings overview.
- Total Bookings & Revenue – 148.77K total bookings generated $51.43M in revenue.
- Booking Status Breakdown – 92.25K successful bookings, 47.59K cancelled bookings, and 8.93K incomplete bookings; overall cancellation rate at 37.99%.
- Vehicle Type Performance – Auto was the most booked vehicle, generating $12.75M revenue and covering 620.72K Km, followed by Go Mini with $10.6M revenue and 497.09K Km travelled.
- Payment Methods – UPI was the top method collecting $25.1M, while Debit Card was the least used at $4.15M.
- Seasonality – Peak booking month was July 2024 with 12.8K bookings.
- Ratings – Customers rated Go Sedan the highest, while drivers rated Uber XL the highest.
Created By :- Ashirbad Routray
Completed On :- September 2025