https://www.kaggle.com/datasets/arashnic/taxi-pricing-with-mobility-analytics?resource=download.

TRIP PRICING WITH TAXI MOBILITY ANALYTICS

AIM:

The aim of the project is to collect and analyze the data of trip pricing with taxi mobility analytics. To analyze the data in detail by each destination type, gender, type of cab, customer rating, and trip destination.

INTRODUCTION:

The main objective of this project is to analyze the data on, Trip pricing with taxi mobility. Through the analysis of the data, we can find out some important insights.

PROBLEM STATEMENT:

• We can find how many males/females are on how many long destinations.
• We can find total pricing by gender and by which type of cab they are pricing.
• In this analysis, we can see the number of cancellations is done in the previous month.
• We can see the lifestyle index, etc.
• Customers month wise destination type.

METHODOLOGY:

We can do data cleaning process with the help of power bi transform the data and clean it, because the dataset was not cleaned. It contains some missing values, with the help of duplicates function in power bi we can clean the data and replace the missing values to the null values with 0 and start working on it. Now the data set is almost clear and completed. The dataset is a total of 131663 rows and 14 columns. We can make graphs and charts with the help of power bi visualization. We can make some relevant graphs and charts.

ANALYSIS:

By observing the dataset, we found the highest customer rating is 100k and the 35k cancellation are done by last month by the confidence lifestyle index. Maximum trip distance is 0.48M by the type of cab c. According to the gender, the maximum of the gender is male.

INSIGTHS:

We can see the values according to the gender.

RECOMMANDATIONS:

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 dataset 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.