Ola Data Analyst Project

Problem Statements (Data Extraction)

  1. Retrieve all successful bookings
  2. Find the average ride distance for each vehicle type
  3. Get the total number of cancelled rides by customers
  4. List the top 5 customers who booked the highest number of rides
  5. Get the number of rides cancelled by drivers due to personal and car-related issues
  6. Find the maximum and minimum driver ratings for Prime Sedan bookings
  7. Retrieve all rides where payment was made using UPI
  8. Find the average customer rating per vehicle type
  9. Calculate the total booking value of rides completed successfully
  10. List all incomplete rides along with the reason

Problem Statements (PowerBI Dashboard)

  1. Ride Volume Over Time
  2. Booking Status Breakdown
  3. Top 5 Vehicle Types by Ride Distance
  4. Average Customer Ratings by Vehicle Type
  5. cancelled Rides Reasons
  6. Revenue by Payment Method
  7. Top 5 Customers by Total Booking Value
  8. Ride Distance Distribution Per Day
  9. Driver Ratings Distribution
  10. Customer vs. Driver Ratings

SQL Queries

  1. Retrieve all successful bookings:
    SELECT * FROM bookings WHERE Booking_Status = ‘Success’;
  2. Find the average ride distance for each vehicle type:
    SELECT Vehicle_Type, AVG(Ride_Distance) as avg_distance FROM bookings GROUP BY
    Vehicle_Type;
  3. Get the total number of cancelled rides by customers:
    SELECT COUNT(*) FROM bookings WHERE Booking_Status = ‘cancelled by Customer’;
  4. List the top 5 customers who booked the highest number of rides:
    SELECT Customer_ID, COUNT(Booking_ID) as total_rides FROM bookings GROUP BY
    Customer_ID ORDER BY total_rides DESC LIMIT 5;
  5. Get the number of rides cancelled by drivers due to personal and car-related issues:
    SELECT COUNT(*) FROM bookings WHERE cancelled_Rides_by_Driver = ‘Personal & Car
    related issue’;
  6. Find the maximum and minimum driver ratings for Prime Sedan bookings:
    SELECT MAX(Driver_Ratings) as max_rating, MIN(Driver_Ratings) as min_rating FROM
    bookings WHERE Vehicle_Type = ‘Prime Sedan’;
  7. Retrieve all rides where payment was made using UPI:
    SELECT * FROM bookings WHERE Payment_Method = ‘UPI’;
  8. Find the average customer rating per vehicle type:
    SELECT Vehicle_Type, AVG(Customer_Rating) as avg_customer_rating FROM bookings
    GROUP BY Vehicle_Type;
  9. Calculate the total booking value of rides completed successfully:
    SELECT SUM(Booking_Value) as total_successful_value FROM bookings WHERE
    Booking_Status = ‘Success’;
  10. List all incomplete rides along with the reason:
    SELECT Booking_ID, Incomplete_Rides_Reason FROM bookings WHERE Incomplete_Rides =
    ‘Yes’;

PowerBI Dashboard