This project presents a comprehensive Power BI dashboard built to analyze ride-sharing data. The dashboard uncovers insights into ride volume trends, booking behavior, payment preferences, and customer-driver ratings.
🔗 View Power BI Dashboard (If link not working, download pbix file)
This Power BI dashboard was created using a real-world ride-sharing dataset (attached in the repository). It answers key business questions to help stakeholders understand patterns in bookings, cancellations, revenues, and performance metrics.
- The dataset used for analysis is included in the main project folder.
- It contains booking data with columns like
Booking_ID,Customer_ID,Driver_ID,Ride_Distance,Rating,Payment_Method,Booking_Status, etc.
The following insights were generated through Power BI visualizations:
-
📅 Ride Volume Over Time
→ Analyzes ride frequency across days, weeks, and months. -
🧾 Booking Status Breakdown
→ Shows percentage distribution of successful, failed, and cancelled bookings. -
🚗 Top 5 Vehicle Types by Ride Distance
→ Highlights which vehicle types cover the most distance. -
⭐ Average Customer Ratings by Vehicle Type
→ Compares customer satisfaction across different vehicle categories. -
❌ Cancelled Ride Reasons
→ Categorizes cancellations by drivers and customers with count and trends. -
💳 Revenue by Payment Method
→ Analyzes payment types like card, wallet, cash, etc. and their contribution to revenue. -
🧍♂️ Top 5 Customers by Total Booking Value
→ Displays high-value customers based on total ride spend. -
🛣️ Ride Distance Distribution Per Day
→ Tracks how far people are traveling daily using histograms or scatter plots. -
🧑
✈️ Driver Ratings Distribution
→ Visualizes how drivers are rated across the platform. -
👤 Customer vs. Driver Ratings
→ A side-by-side comparison of average ratings given to and by customers and drivers.
- Microsoft Power BI
- DAX (Data Analysis Expressions)
- Power Query Editor
- Excel / CSV (as data source)