Uber 2024 Ride Data: Operations & Revenue Dashboard
Summary
This project develops an interactive Shiny dashboard to help an operations manager at Uber understand how the business is performing across bookings, revenue, cancellations, and service quality. The dashboard is built around concrete job stories: reporting an overview to leadership, comparing vehicle types, analyzing cancellations, assessing seasonality, and monitoring ratings across service categories.
Using Python, Shiny, and reactive components, the app transforms raw ride-level data into a set of KPIs and visualizations that can be filtered by date range and vehicle type. Users can quickly see total bookings, total revenue, and cancelled bookings; break down revenue by vehicle category; examine booking value over time; compare average ratings by vehicle type; and explore booking status and cancellation reasons in a hierarchical view.
Data & Intended Users
The dashboard is designed for an operations lead (e.g., a city GM or regional ops manager) like “James,” who regularly reports performance up to the CEO and needs to understand which parts of the operation are driving revenue, where cancellations are concentrated, and how service quality compares across vehicle types. [file:130]
The underlying dataset contains ride-level records from Uber’s 2024 operations, including timestamps, booking values, vehicle categories, booking statuses, and cancellation reasons. The dashboard focuses on high-level metrics and patterns rather than predictive modeling, with an emphasis on clarity and decision support for non-technical stakeholders.
Key Questions the Dashboard Answers
- Overall performance: What are the total bookings, total revenue, and number of cancelled bookings in the selected period, and how does this change when focusing on a specific vehicle type?
- Vehicle mix and revenue: Which vehicle categories generate the most revenue, and how does the revenue mix shift over time or by filter?
- Cancellations and inefficiencies: How many bookings are being cancelled, and what are the main cancellation reasons within the selected date range and for specific vehicle types?
- Seasonality: How does total booking value evolve over time, and what seasonal or trend patterns emerge when zooming in on particular vehicle types?
- Service quality: How do average driver ratings compare across vehicle categories, and which segments may require attention from a customer satisfaction standpoint?
Dashboard Design & Interaction
The app is structured around a few core controls and reactive calculations: a date range slider, a vehicle type selector, and reactive datasets that feed KPIs and charts.
- Filters: A date range slider and a vehicle type select input control the main filtered dataset used by most components.
- KPIs: Text outputs display total bookings, total revenue, and cancelled bookings, with dynamic labels that update when a vehicle type is selected.
- Revenue by vehicle type: A pie chart shows the revenue breakdown across vehicle categories for the selected date range; clicking a slice filters the rest of the dashboard to that vehicle type.
- Booking value over time: A line chart shows total booking value over time, reflecting both the date and vehicle filters, with a dynamic title.
- Ratings by vehicle type: A bar chart compares average driver ratings across vehicle categories; clicking a bar updates the vehicle filter and propagates through other components.
- Status and cancellations: A sunburst chart visualizes booking status and cancellation reasons hierarchically, helping users see the distribution of ride outcomes and underlying causes.
Click interactions on the revenue pie chart and ratings bar chart update the vehicle type selector via reactive logic, ensuring that the whole dashboard responds coherently to user exploration.
Example Insights
With these components, an operations manager can quickly discover patterns such as:
- Specific vehicle categories that generate strong revenue but show lower average ratings, indicating a possible trade-off between volume and service quality.
- Periods with elevated cancellation rates for certain vehicle types, pointing to potential supply, pricing, or communication issues.
- Seasonal peaks in booking value that may warrant targeted driver incentives or dynamic pricing strategies.