Uber Ride Analytics Dashboard Overview





π Uber Ride Analytics Dashboard Overview
Focus Areas: Booking Value π° | Vehicle Type π | Payment Method π³ | Location Demand π
Period Covered: Multi-month transactional dataset
π° 1. Booking Value & Performance Metrics
- By Customer Rating: $445K
- By Payment Method: $5.22M (7,166 bookings)
- By Driver Rating: $64.31K
π Insight:
Payment method preferences significantly drive revenue (5.22M), while customer/driver ratings have limited direct correlation with booking value.
π 2. Location-Based Booking Metrics
- Top Zone: Vile Parle dominates both pickup and dropoff booking values (~55K)
- Frequency: Pickup β 2,168 vs Dropoff β 12,000+
π Insight:
Drop-off locations are revenue hotspots β especially business and commercial hubs. Fleet allocation and surge pricing should be prioritized here.
π 3. Vehicle Booking Frequency
- Most Popular: Auto (2.98K bookings) followed by Go Mini & Bike
- Premium Categories: Uber XL & Lux show very low adoption
- Monthly Trend: ~3.02K rides, stable but no growth
π Insight:
Market is highly price-sensitive β low-cost vehicle categories dominate. Premium rides require targeted promotions to boost adoption.
π³ 4. Payment Insights
- Cash: 32%
- Credit Card: 30.6%
- Digital Wallets (UPI, Uber Wallet): Smaller share but growing
π Insight:
Cash and cards remain dominant, but digital payments are a growth opportunity. Incentivizing wallet/UPI usage can reduce operational costs.
π 5. Booking Value Trends
- Ride Distance vs Value: Declining trend β shorter trips or lower spend per km
- Customer & Driver Rating vs Value: Consistent but falling β limited impact on revenue
π Insight:
Overall decline suggests either seasonality or competitive pressure. Monitoring churn and promotions could help stabilize growth.
π Key Recommendations
- π Address Decline: Investigate seasonality vs competitor influence behind falling booking values.
- π± Push Digital Payments: Offer cashback/discounts to accelerate UPI & wallet adoption.
- π Optimize Locations: Focus on top 10 drop-off hubs with driver incentives & surge pricing.
- π― Grow Premium Rides: Upsell from Auto/Bike users to Go Sedan/Uber XL via loyalty offers.
- β Improve Experience: Link customer & driver ratings to rewards to enhance service quality.
Code Snippet
Vehicle breakdown type = SUMMARIZE(ncr_ride_bookings,ncr_ride_bookings[Vehicle Type],ncr_ride_bookings[Date].[Month],
"vehicle type booking frequency",countrows(ncr_ride_bookings),
"vehicle type booking value",sum(ncr_ride_bookings[Booking Value]),
"Distance Covered",SUM(ncr_ride_bookings[Ride Distance]))
premier sedan = CALCULATETABLE (
SUMMARIZE(ncr_ride_bookings,ncr_ride_bookings[Vehicle Type],ncr_ride_bookings[Pickup Location],ncr_ride_bookings[Date].[Month],
"premier sedan booking frequency",countrows(ncr_ride_bookings),
"premier sedan booking value",sum(ncr_ride_bookings[Booking Value]),
"premier sedan Distance Covered",SUM(ncr_ride_bookings[Ride Distance])),
ncr_ride_bookings[Vehicle Type]="premier sedan",
ncr_ride_bookings[Cancelled Rides by Customer]=0
)
frequency payment method = CALCULATETABLE (
SUMMARIZE (
ncr_ride_bookings,
ncr_ride_bookings[Date].[Month],
ncr_ride_bookings[Payment Method],
"Payment Method Count", COUNTROWS ( ncr_ride_bookings ),
"Total Booking Value",FORMAT( SUM ( ncr_ride_bookings[Booking Value] ), "$#,##0")
))



















