Project 2 - Supply and Demand Gap Analysis

PROJECT 2

AIM

The aim of this project is to collect and analyze the data in detail of the Request by status of the trip and request by pickup point of the trip from 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 requests 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. The data set was almost clean and completed. Replace the Null values with 0.

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.

ANALYSE

From the visualization finding some interesting points,

• In the first chart shows the values of the pickup point orders depends on the status of the order.
• That chart shows the trip completed, cancelled, no cars available data in both airport and city values with percentage.
• The next chart also like first chart. But this chart shows values depends on the pickup point data.
• Another chart of the dashboard is showing the total of completed trips.
• The dashboard contains 4 filter option-based status, pickup point, Driver ID and Request ID.
• Using the above slicers we get the data for every single order’s status, the pickup point of that order also the driver id.

INSIGHTS

In conclusion, we can 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.

We create the dashboard using the Uber Request data, the dashboard contains all the information for a Request id. Using this dashboard we get all the data for each driver id .