Challenge

Project 2 - Supply and Demand Gap Analysis

PROJECT-2 SUPPLY AND DEMAND CHAIN ANALYSIS

AIM:

The aim of the project is to analyze the dataset file and visualize the dataset according to the data given in the dataset.

INTRODUCTION:

PROBLEM STATEMENT:

From the dataset, we can find how many requests id is placed from the city and airport. And we can find the status of the pickup and drop. And we can find how many trips are cancelled.

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 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.

VISUALIZATION:

In visualization, I took the help of Power BI Desktop software to make graphs and charts here some relevant graphs and charts are attached.

In the above visualization, I have analyzed driver id by pickup point and drop point.
In the above visualization, I have analyzed driver id by year and status.

ANALYSIS:

From the above analysis, we can know that
In the first chart, we may know that trip is complete, and the trip was cancelled in both city and the airport.
In the 2nd chart, In 2016, trips completed overall 69% and trips cancelled is nearly 30%
In the 3rd chart, year by status is shown, that’s the trip completed, no car available and cancelled are shown clearly.
In the 4th chart, the driver id and pickup point are taken. Therefore, the count of driver id in city is high compare to airport.

INSIGHT:

RECOMMENDATION:

We can analyze the data of the overall Trips in the City.
Like this dataset, we can Analyze the Data according to the Different Cities-Area it takes more clarity to how to fill the supply and demand gap.

CONCLUSION:

From the analysis, we know that increase more number of cars in city and the airport.
Cancel should be avoid for better profit.

Ship work like this
in your own course.