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

• Finding the Customers Rating by Source name
• Finding the Customers travelled from last month by trip Id with cab type
• Finding the Total Cancellation of last month by source name with Trip Id
• Finding the distance of customers by source name
• Finding the price by distance

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

In observation found some interesting points that are mentioned below.

• Customers Rating by Source name
• Customers travelled from last month by trip Id with cab type
• Total Cancellation of last month by source name with Trip Id
• Distance of customers by source name
• Finding the price by distance

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 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 Dashboard for further analysis.