Project Overview

In this project, I analyzed an Ncr_Ride_Booking to explore booking patterns, service performance, revenue contribution and cancellation behaviour in order to uncover trends, inefficiencies and opportunities for operational improvement. My goal was to transform raw data into actionable insights that improve service efficiency, reduce cancellation and support business growth. Data cleaning and Exploratory Data Analysis was done using SQL, visualization was done using Excel.

Tools Used

SQL and Excel

Data Overview

The dataset contains Customer and Driver information across various dimensions including:

• Date and Time of booking
• Booking ID and Customer ID
• Booking Status
• Vehicle type and Locations
• Reason for cancellation by Driver and Customer
• Average VTAT, CTAT and Booking value
• Customer Rating and Driver Rating
• Ride distance
• Payment Method

Objectives

• To explore booking patterns, cancellation behaviour, revenue contribution and service performance in order to uncover trends, inefficiencies and opportunities for operational improvement.

SQL Analysis

Below are the key SQL queries to explore booking patterns, service performance, revenue contribution and cancellation behaviour in order to uncover trends, inefficiencies and opportunities for operational improvement.

A. Key Performance Indicator (KPI)