Uber Supply Demand Gap Analysis

Project Overview

This Exploratory Data Analysis (EDA) project aims to identify the root causes of the supply-demand gap for Uber rides, specifically focusing on the route between the City and the Airport.

Business Problem

Customers frequently face ride cancellations or "No Cars Available," leading to a massive 72% unfulfilled request rate on this critical segment.

Key Insights

• Morning Peak (5 AM - 9 AM): High rate of driver cancellations from City to Airport due to fear of empty returns.
• Evening Peak (5 PM - 9 PM): Severe lack of cab supply at the Airport to match incoming flight demand.

Proposed Solutions

1. Targeted Morning Incentives
2. Surge Pricing during Evening Rush
3. Assured Return Rides

Files in this Repository

• Sample_EDA_Submission_Template.ipynb: Full Python code, data wrangling, and visualizations.
• Uber_Driver_Analysis.sql: All SQL queries for creating insights.
• Uber_Cleaned_Data_Dashboard.xlsm: This file contain the CLeaned data and the dashboard which is created by using excel.
• Uber_Data_Insights.pdf: This is the pdf of all the insights we gain in this project.

Dashboard Preview