Project 2 - Supply and Demand Gap Analysis

Project on Supply and Demand Gap Analysis

Table Of contents

• Aim
• Introduction
• Problem statement
• Methodology
• Analysis
• Insights
• RecomMendations
• Conclusion

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, we can find out the demand and supply Analysis gap of the Uber 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 and how many Drivers are present, How many trips are completed, and how many trips are cancelled also find out for how many trips the car is not available.

Methodology--

• In Uber Request Dataset, the first column is Request id. In this column the request-id of the customer is present.
• In the second column, the pickup point is present in this data only two Airport and City pickup points are 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 Trip 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.

Now Methodology Steps

Step1: Data Cleaning

The first step is cleaning the data. In data cleaning I cleaned the data with the transform data option present in Power BI.

In this using Replace values option, I cleaned the data and replaced the null values with 0 and then started working on it.

Step2: Data Interpretation

In Data interpretation I have found some important information.

• The data set was almost clean and completed.
• Replace the Null values with 0
• There is a total of 6745 rows and 6 columns are present.

Step3: Visualization

In visualization, I took the help of Power BI Desktop software to make graphs and charts.

Below are some relevant graphs and charts attached.

Analysis--

• In the first chart, almost 1327 trips are completed for Airport and 1504 trips are completed for City.
• For a total of 1713 trips, there is no Car Available for Airport trips and 937 trips with no car available for city trips.
• A total of 198 trips are cancelled for Airport and 1066 trips are cancelled for city trips.
• In the Second chart 15 July 2016, total 20.47 % of request IDs are placed.
• The Total of 301 Uber Drivers are available in 2016.
• In the fourth Chart, the Total Request id placed for airport is 50.99 % and the total request Id placed for city is 49.01 %.
• And in the last chart, 297 Drivers have completed the Airport trip and 299 Drivers are completed the City trip.
• The Total of 145 Drivers cancelled the Airport Trips and 291 Drivers cancelled the city Trips.

Insights—

• In conclusion, we can take a look at the final Dashboard for further Analysis.
• We analyzed the data according to the request ID

Recommendations—

• 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
• We can analyze the data with the proper format
• We can collect good datasets for more effective analysis by using charts.

Conclusion--

In Conclusion, we can take look at the Dashboard for further Analysis.

According to analysis, almost 1713 trips are cancelled for Airport trips. In airports, trips need to increase the drivers that help to increase the Business.

• The second points are that almost 1066 trips are cancelled by the customer in the city area and need to improve some features.
• A total of 1327 Drivers successfully completed the Airport trips and 1504 Drivers successfully completed the City trips.