The dashboard visualizes data from Uber Transport Service, covering key performance indicators (KPIs) such as:
- Total Revenue: $52M
-
Total Customers: 104K
-
Total Vehicle: 150K
-
Total Distance: 3M
-
Completed Booking: 93K
-
Lost Booking: 57K
-
Average Distance: 24.64
-
Average Customer Rating: 4.40
-
Average Drivers Rating: 4.23
🔍 KEY INSIGHT
-
The total revenue generated was approximately $52 million.
-
Uber Auto recorded the highest revenue of $13 million, representing 25% of total revenue, while Uber XL had the lowest revenue at $2 million which is just 3.8%.
-
March emerged as the best-performing month in terms of revenue.
-
The lowest number of bookings was recorded in February, with 11,537 total bookings.
-
UPI accounted for 45.03% of all payment transactions.
-
The distance covered remained relatively consistent across all months, showing little variation.
💡 RECOMMENDATION
-
Focus on the Uber XL category: Since Uber XL generated the lowest revenue ($2M), the company should introduce targeted promotions, adjust pricing, and enhance visibility to boost demand and utilization.
-
Leverage March’s performance drivers: As March recorded the highest revenue, management should analyze the factors behind this peak such as marketing campaigns or seasonal demand and replicate them in other months.
-
Address low February bookings: With only 11,537 bookings in February, the company should implement early-year promotions, loyalty programs, and referral incentives to stimulate ridership during slow periods.
-
Capitalize on UPI payment preference: Since 45.03% of all payments were made via UPI, the company should strengthen UPI integration, offer cashback rewards, and highlight its convenience to enhance user satisfaction and retention.
-
Optimize revenue per kilometer: As ride distances remained consistent across all months, efforts should focus on increasing revenue efficiency through dynamic pricing, ride pooling, and premium service upselling.
- Excel
- PowerBI