Project 2 - Supply and Demand Gap Analysis
Project 2 Power BI Supply and Demand Gap Analysis
Akshay Umakant Bandewar
Aim:-
This project aims to collect and analyse the data of Trip Pricing with Taxi Mobility Analytics site data and analyse it in detail by each Destination type, Gender, Type of Cab and Customer Rating, trip destination, etc. on that site.
Introduction:-
The main objective of this project is to analyse the data on, Trip pricing with taxi mobility. Through the Analysis of data, we can find out some important insights.
Problem Statement:-
We can find out how many males/females are on how many long destinations.
Total pricing by gender and then by type of cab. In this analysis, we can see the number of cancellations in the last month, the Lifestyle index, etc.
Customers since month by destination type etc.
Methodology:-
Step 1: Data cleaning
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.
Step 4: Data interpretation
I found some important information about the data set in this data interpretation step. The data set was almost clear and completed.
I replaced the null values with 0. There is a total of 131664 rows and 14 columns.
Step 5: 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.
Report View
Trip Distance By Type Of Cab
Top 3 Highest Customer Rating
Surge Pricing By Destination Type
Report View All
Trip Distance By Type Of Cab
Top 3 Highest Customer Rating
Surge Pricing By Destination Type
Analysis (Datasheets about it):-
In observation found some interesting points that are mentioned below.
Report Page All View
Their are 5 Types of Cabs
According to Gender the Maximum is Male
Maximum Trip Distance By Type of Cab B is 1296.11K
Top 3 Highest Customer Rating Type of Cab B is 90458.96
Surge Pricing By Destination Type
Insights:-
In conclusion, we can take a look at the final Dashboard for further analysis.
We can see the values according to gender.
Recommendations:-
We can collect a large dataset for analysis.
We can analyse the data of the trip destination.
Like this dataset we can perform operations with various types of cabs, gender, or destination type, Max week, Count of Canselation Last Month, Sum of base price, Sum of checkout price
We can work on large datasets and analyse them with the proper format of the chart.
Conclusion:-
In conclusion, we can take a look at the final Dashboard for further analysis.