Project 2 - Supply and Demand Gap Analysis

Aim

The aim of this project is to collect and analyze the data in detail of the Pickup point of the Airport and City Request id in Uber Request Data.

Introduction

Uber provides the 2016 data. By using this data find out the demand and supply Analysis gap of the cab.

The main objective of this project is to analyze the data on, Uber Request data. Through the analysis of data, we can find some important insights.

Problem Statement.

In this project, we find out how many request id is placed from the pickup point of the Airport and city, How many Drivers are present, How many trips are completed, and how many trips are cancelled also find out how many trips the car is not available for the trips.

Methodology

• In Uber, the Request Data set the first column is Request id in this column the request-id is present the placed by the customer.
• In the second column, the pickup point is present in this data only two Airport and City pickup point is present.
• The next column is Driver Id in this column so many drivers are present each driver assigns a separate driver ID.
• Another column is Status in this Status column three statuses are present completed, cancelled and No car available.
• The last two columns are the Request timestamp and Drop Timestamp in this column the request time and drop time are present.
• The first step is cleaning the data. In data cleaning I cleaned the data with the transform data option present in Power BI because the dataset was not cleaned and included some missing values, so with the help of the duplicates function in Power BI, I cleaned the data and replace the null values with 0 and then started working on it.
• After Data cleaning performs the Data interpretation step. In Data interpretation found some important information.

Verdict:
Overall analysis says that uber has a huge gap in demand supply chain. Total demand is 6745 but there is a supply of only 2831 i.e. 41% and huge gap of 3914 which is 58%, so this is very alarming situation. They need to improve their service to reduce this huge gap & I have some suggestions given below:
1. Increase cab count in city.
2. Focus on Peak hours like office hours.
3. Also focus on non peak hours.
4. Increse pick up point availability.
5. Increase cab drivers & motivate them by providing lucrative
incentives.
6. Look for investors to suport their business by pumping financial
asistance.
7. Introduce dynamic pricing as per the peak hours of the day to avoid
cancellation.
8. Prioratise returning customer by giving exciting deals.
9. Adjust and increase cab facility on the special occations like Navratri,
Diwali, etc.
10. Reforms in shared cab service.
11. Listen to customer feedback & drivers and work on those issues.
12. Keep an on other players in the market and their constant changing
strategies.