Project 2 - Supply and Demand Gap Analysis

Aim

The main aim of this project is to collect data and analyse it according to the dataset. Our aim was to try to analyse the prices of these ride-sharing apps and try to figure out what factors are driving the demand.

Introduction

We have a dataset in which there are records of Cab prices in which the main data fields are distance, cab type, time stamp, destination, source, price, surge multiplier, id, product id and name. Uber and Lyft's ride prices are not constant like public transport. They are greatly affected by the demand and supply of rides at a given time.

Problem Statement

You have an emergency to reach a destination point, but unfortunately no cabs are available or maybe cancelled by cab driver. Most of us faced this situation in our real life, while travelling to Airport or Railway station etc. This will surely affect the revenue and reputation 

Methodology

Import and organise data: This step involves importing of data into POWER BI

Explore and visualize data: In this step we use various visualisation tolls in POWER BI. This may involve carts and other visualisation 

Analyse data: Use the analytical tools in Power BI to perform more in-depth analysis of the data.

Recommendation

These cab service may provide some better incentives for driver who rides a lot of distance

Some areas may require some more cabs

Conclusion

The use of Uber and Lyft Cab is 56% and 44% respectively.

There are 693071 unique id’s.

Mostly people use Black SUV and Lux Black SUV while Shared cab is used by few one