Welcome to my Ola Data Analyst project! This repository contains the complete analysis of 50,000+ Ola ride records for Bengaluru city over a 1-month period. The project explores booking trends, cancellation patterns, ride demand fluctuations and more using SQL and Power BI with the goal of uncovering actionable insights.
This project simulates real-world ride-calling data for Bengaluru and includes 20+ fields such as:
- Date & Time: Tracks booking trends and peak hours.
- Booking ID: Unique 10-digit IDs (e.g.,
CNR12345678). - Booking Status: Successful, Cancelled (Customer/Driver), or Incomplete.
- Vehicle Type: Includes categories like Auto, Bike, Prime Sedan, Mini, etc.
- Pickup & Drop Locations: Randomized across 50 prominent areas in Bengaluru.
- Cancellation Reasons: Detailed reasons for cancellations by customers and drivers.
- Ride Metrics: Includes VTAT (Vehicle Time to Arrive), CTAT (Customer Time to Arrive), Ride Distance, and more.
- Payment Methods & Booking Values: Categorized under specific thresholds for actionable insights.
- SQL: Data wrangling, cleaning and querying for insights.
- Power BI: Dashboard creation and detailed reporting.
- Python/Excel: Data preprocessing and randomization.
- Maintained 62% success rate for bookings.
- Cancellation Rates:
- Customer cancellations: <7%
- Driver cancellations: <18%
- Increased rides on weekends and match days to simulate real-world demand.
- Balanced order values:
- 70% of rides under ₹500
- 28% of rides above ₹500
- Remaining rides above ₹100.
- Insights:
- Higher booking values and distances on weekends.
- Common cancellation reasons analyzed for service improvement.
- Power BI Report: It provides detailed trends and patterns including cancellation analysis, booking success rates and more.
- Dashboard: It shows interactive visuals for quick insights on key performance indicators (KPIs).
Below is an example of how the dataset is structured:
| Date | Time | Booking ID | Booking Status | Vehicle Type | Pickup Location | Drop Location | Booking Value | Payment Method |
|---|---|---|---|---|---|---|---|---|
| 2024-01-15 | 08:30 AM | CNR12345678 | Successful | Prime Sedan | Koramangala | Whitefield | ₹480 | Online |
- Clone this repository:
git clone https://github.com/Satyam638/Ola-Data-Analyst-Project.git
- Access the Power BI report file and dataset for detailed exploration.
- Use SQL scripts for custom queries on the dataset.
If you have any questions, suggestions, or would like to collaborate, feel free to reach out:
