Project 2 - Supply and Demand Gap Analysis
Aim:-
This project aims to collect and analyze the data of Trip Pricing with Taxi Mobility Analytics site data and analyze 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 analyze 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 2: 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 3: 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.
Analysis (Data sheets pertaining to it):-
In observation found some interesting points that are mentioned below.
• The highest customer rating is 100K and the 35K Cancellation last month by the Confidence Lifestyle index.
• Maximum Trip distance is 0.48M by type of cab C.
• According to gender, the maximum is male.
• Maximum Distance is 1.5M in gender male by confidence lifestyle B.
• The Maximum customer rating is 110K in confidence lifestyle A and the Maximum Cancellation in the last month is 35K in confidence lifestyle A also.
• Maximum Trip distance is 5.06K by type of cab B and pricing is 19K by type of cab C Minimum Trip distance is 2.7K by type of cab E and pricing is 9K by type of cab E by Female gender.
• Maximum Trip distance is 7.5K by type of cab C and pricing is 46K by type of cab C Minimum Trip distance is 5.2K by type of cab E and pricing is 22K by type of cab E by Male gender.
• You can see the blowing table blue color indicates the maximum values and light blue values indicate the minimum value.
We can see the maximum value is 81367 of the pricing type of females.
Insights:-
• In conclusion, we can take a look at the final Report for further analysis.
• We can see the values according to gender.
Recommendations:-
• We can collect a large dataset for analysis.
• We can analyze the data of the trip destination.
• Like this dataset we can perform operations with various types of cabs, gender, or destination type.
• We can work on large datasets and analyze them with the proper format of the chart.
Conclusion:-
In conclusion, we can take a look at the final Report for further analysis.
As we can see in the Report, The highest value of the pricing type, etc. and we can see the maximum value is, 81367 of the pricing type of females.