CAB COMPANY INVESTMENT

The Problem Statement

The Client

XYZ is a private firm in US. Due to remarkable growth in the Cab Industry in last few years and multiple key players in the market, it is planning for an investment in Cab industry and as per their Go-to-Market(G2M) strategy they want to understand the market before taking final decision.

Project delivery:

You have been provided with multiple data sets that contains information on 2 cab companies. Each file (data set) provided represents different aspects of the customer profile. XYZ is interested in using your actionable insights to help them identify the right company to make their investment.

The outcome of your delivery will be a presentation to XYZ’s Executive team. This presentation will be judged based on the visuals provided, the quality of your analysis and the value of your recommendations and insights.

the datasets:

You have been provided 4 individual data sets. Time period of data is from 01/01/2016 to 31/12/2018.

Below are the list of datasets which are provided for the analysis:

Cab_Data.csv – this file includes details of transaction for 2 cab companies

Customer_ID.csv – this is a mapping table that contains a unique identifier which links the customer’s demographic details

Transaction_ID.csv – this is a mapping table that contains transaction to customer mapping and payment mode

City.csv – this file contains list of US cities, their population and number of cab users

THE GOAL

Provide actionable insights to help XYZ firm in identifying the right company for making investment.

RESULTS

• Cab_Investment_EDA_model.ipynb - this is the model built to extract insights from a gloabal datset called "Global_cab_data" got by performing inner join of the 4 different datasets.

• Cab_Investment_Data Intake Report.pdf - this file that comprises informations abou the dataset.

• Cab_Investment_Recommendations.docx - this file is the summarization of all hypothesis derives from the insights.

• CabInvestment.pptx - this file is the powerpoint presentation that can be used to vusially present the result of the insight extraction to an organization.