This project was a deep dive into trip data, designed to uncover key insights and provide a clear, interactive view of business performance. Every element you see was carefully crafted to tell a specific data story.
Here's a detailed breakdown of the dashboard's features:
️ Overview Analysis: This dashboard provides a high-level summary of total bookings, booking value, average trip distance, and average trip time. It also breaks down key metrics by Payment Type, Time of Day/Night, and Vehicle Type (UberX, UberXL, etc.). A key feature is the Location Analysis, which identifies the most frequent pickup and drop-off points.
️Time Analysis: Focusing on temporal trends, this page visualizes Total Bookings by Pickup Time, revealing peak hours and days. The heat map gives a quick visual summary of booking volume across different hours of the day and days of the week, which is crucial for operational planning.
️Detailed Data View: To allow for a granular investigation, I’ve included a detailed table that lists every trip record. This table provides specific information on each trip, including Trip ID, Pickup Hour, Payment Type, Number of Passengers, and Total Booking Value, making it easy to drill down into the raw data.
This project was a fantastic opportunity to apply and strengthen my skills in data modeling, DAX formula creation, and advanced data visualization in Power BI.