This Power BI project analyzes Uber trip data from New Jersey in June 2024 to uncover booking trends, revenue patterns, time-based demand, and geospatial insights.
-
Overview Analysis
- KPIs: Total Bookings, Revenue, Avg Distance & Duration
- Filters: Payment Type, Trip Type, City
- Dynamic Measure Selector and Titles
-
Time Analysis
- Heatmaps, Area and Line Charts
- Booking and revenue trends by time of day and day of week
-
Details Tab
- Drill-through to trip-level data
- Toggle between filtered and full view
-
Spatial Analysis
- US geocoded map focused on New Jersey
- Interactive slicers:
- Fare Bins (grouped in intervals of 10)
- Payment Type (Cash, Uber Pay, Amazon Pay, Google Pay)
- Vehicle Type (UberX, UberXL, Comfort, Green, Black)
- Peak demand: 12 PM – 6 PM, especially weekends
- Saturday evenings lead in revenue & trip distance
- UberX most used; Uber Black & Comfort have higher value
- Growth opportunity in digital payment adoption
- Power BI (DAX, Bookmarks, Slicers, Map Visuals)
- Power Query for data transformation
- Drill-through, conditional formatting, export features
Watch demo: https://www.linkedin.com/feed/update/urn:li:activity:7330567842402095105/
📧 Email : abhinavxsingh28@gmail.com
🔗 linkedin : https://www.linkedin.com/in/abhinavxsingh28/