Challenge

Project 2 - Supply and Demand Gap Analysis

PROJECT 2

Aim:

The primary aim of our project is to collect and analyze the data to create visualizations which helps to understand the US Cab of Pink and Yellow cab on 2016 -2018

Introduction:

A cab, is a type of vehicle for hirewith a driver, used by a single passenger or small group of passengers, often for a non-shared ride. A taxicab conveys passengers between locations of their choice. This differs from public transportwhere the pick-up and drop-off locations are decided by the service provider, not by the customers, although demand responsive transport and share taxis provide a hybrid bus/taxi mode.
Taxi service can be an important backup option for other alternative forms of transport, such as allowing pedestrians to carry large loads back from a store, providing an emergency ride home when a cyclist has a medical or mechanical problem, or a Guaranteed Ride Homefor rideshare or transit commuter.
Informal taxi service often develops in rural communities where certain motorists will drive their neighbor’s for a fee. This data analyzes the difference between pink and yellow cab company and give a brief understanding about the profit, users, traveled distance and etc.

Problem Statement:

Methodology:

Data collection : The data used in this analysis has been retrieved from kaggle US Cab dataset 2016-2018.
Data investigation : In this step, organized and verified whether the data contains the relevant fields that required to fulfill the problem statement, and whether it satisfies the tools for the visualization
Data interpretation: Data interpretation is the step in which to analyze and process the data. Here, I made users trend, distance percentage, travel distance, profit, summary, price charged using the dataset.
Visualization: In this final step I’ve used 100% stacked column char Line chart, area chart, donut chart, funnel to make the visualization easier to read and understand.

Analysis:

In the given data set of US cab, we can simply understand that there are two companies providing cab facility for some cities around US.
One is yellow cab and other is pink cab here I used the data from both of these companies to analyze and to make visualization with the use of it.
The data contains the relevant fields about the charges made for a trip, distance traveled and cost of trip with respect to the date. It makes easy to understand and manipulate the data to create a better visualization.
And it is helpful to find the variations of profit and cost of trip and also traveled distance for each of the city.

Conclusion:

This is some of the detailed analysis and information of the US Cab data of 2016-2018.
From this I came to know the interesting facts about the daily usage of cab services by each city and how yellow and pink cab doing their major role in the cab service.
And also it helped to found the shortage of users in pink cab which leads some lower while compared with yellow cab, and how it affects the revenue and the market status of each company.
And here I conclude that I clear the problem statements with the help of power BI

Ship work like this
in your own course.