Project 2 - Supply and Demand Gap Analysis

Supply and demand gap analysis

Aim:

The aim of this project is to collect and analyze the data in detail for a cab company named as sigma cabs so that they can able to find out their positives and negatives

Introduction:

The main objective is to analyze the cab details and customer details so that we can able to understand what types of cabs are mostly preferred by customer by that we can introduce that type of cabs in large numbers for future so that we can be more profitable

Problem Statements:

• In this project we have analyzed the average customer rating and average trip distance with the help of new measure and DAX function
• We have analyzed the sum of cancellation last month and sum of customers across months
• We have analyzed the cancellation records according to the gender
• We have analyzed the trip distance according to the different types of cabs
• We have analyzed the customer rating according to the different types of cabs
• We have analyzed the life style index according to the confidence life style index
• We have analyzed the sum of all three variables according to the different types of cabs
• We have analyzed the total trip distance according to the gender
• We have analyse the customer across months and surge pricing type according to destination type
• We have analyzed the cancellation last month and sum of customers across months according to cab type
• We have analyzed the customer across months according to gender
• We have analyzed the sum of all three variables according to gender

Methodology:

Step 1:

Data Importing:

In power BI desktop with the help of the get data option, import the CSV data which is named as sigma_cabs and click load option

Step 2:

Data Cleaning:

After loading the data and after analyzing the data I understood that there are 131662 rows and 14 columns. And in that some of the columns contained null values I have replaced the null values by 0 with the use of replace functions and started working on the data.

Step 3:

Visualizations:

In visualization part with the help of power BI desktop software I have used different kinds of charts, graphs, cards and table to display the data in the format which will be easy to understand

Analysis:

In analysis part first we have analyzed the average customer rating and average trip distance by creating new measures and used average DAX function and finally we have obtained the above results and used cards to display that

In the second analysis we have analyzed the total cancellation that was done last month and also obtained the total customer since months and we have obtained the above results and used cards to display that

In the above image we have analyzed the cancellation in last month by gender and we can able to find that more cancellation was done by male customers rather than female customers that is male customers has done 74k cancellations and female customers has done only 29k cancellations

In the above image we have the analyzed trip distance according to types of cab and we can able to find that B type of cab has been travelled more distance followed by C type and A type

In the above image we have analyzed the customer rating according to type of cab and we can able to find that B type of cab has been having good rating followed by C type and A type

In the above image we can able to find that B type of confidence life style index has highest number of life style index followed by C and A type

In the above image we have analyzed the sum of all variable according to different types of cabs and we can able to find that the B type cab has highest value in all three cases followed by C type and D type

In the above image we have analyzed the total trip distance travelled according by gender and we can able to find that male customers has travelled more distance rather than the female customers

In the above image we have analyzed the number of customers and surge pricing type according to the destination type and we can able to find that the destination type A has more number of customers and more number of surge pricing type followed by B destination type and C destination type

In the above image we have analyzed the sum of cancellation last month and sum of customer since months according to type of cab and we can able to find that that B type has more number of customer and C type has more number of cancellation

In the above image we have analyzed the number of customers according by gender and we can able to find that male customers are more than female customers

In the above image we have analyzed the sum of different variables according by gender and we can able to find that sum of variable of male customers are higher when comparing to female customers

Insights:

• Here we have analyzed the average trip distance and average customer rating so that we able to calculate what will be average distance that the customer wants to travel and by average customer rating we can able to find our service satisfaction so that we can improve for future
• And also analyzed the customer rating and trip distance according to type of cab so that we can able to understand which type of cab is preferred by people
• And also analyzed the no of customer details and cancellation details according by gender so that we can able to understand which gender is using the cab facilities more frequently
• And also analyzed which is the most frequently selected destination type and so that we can able to understand which destination needs more cabs

Recommendations:

• From the above analyses we can able to find that B type of cab is mostly used cab by distance and it’s also highly rated by customer rating so it will be good to launch B type of cabs more frequently in future so that profit will be increased
• And also we came to know that male customers uses cab services more often , so if we do advertisements more frequently means there will be chance of getting more female customers also
• And destination type A is most preferred destination followed by destination type B and C so having more cabs for that destination will increase profit

Conclusion:

From the above analysis we are able to know that we have to do some changes for that if we follow the above recommendations by doing continuous improvisation we will more successful in future.