Ola Rides Data Analysis Dashboard
Overview
This project involves an in-depth analysis of a 1 lakh+ row dataset from Ola rides, covering bookings, cancellations, ride distances, customer behavior, and payment trends. The insights derived from this analysis are visualized using Power BI, providing a data-driven approach to understanding Ola's ride trends.
Purpose
The application provides insights into startup funding trends by analyzing data from a cleaned dataset (startup_cleaned.csv). It supports both an overall view and detailed explorations of specific startups and investors.
Key Insights & Analysis
1 . Ride Volume Over Time :- Analyzed trends in ride bookings over different time periods.
- Identified peak hours and seasonal fluctuations affecting ride demand.
- Segmented rides into Completed, Cancelled, and Pending categories.
- Highlighted major reasons for cancellations by customers and drivers.
- Ranked vehicle types based on total ride distance covered.
- Found that Prime Sedan and Mini were among the most frequently booked categories.
- Compared customer ratings across different vehicle types.
- Evaluated the distribution of driver ratings to assess overall service quality.
- Investigated cancellation reasons, distinguishing between customer-driven and driver-driven cancellations.
- Identified key factors leading to ride cancellations, such as fare issues and driver availability.
- Examined total revenue generated based on different payment modes like UPI, Credit Cards, and Cash.
- Determined which payment method was most preferred by customers.
- Identified high-value customers who contributed significantly to revenue.
- Analyzed their booking frequency and preferred ride types.
- Analyzed the distribution of ride distances per day.
- Correlated ride fares with distance and surge pricing.