Uber Analytics: Supply-Demand & Cancellation Analysis

📌 Project Summary

This project analyzes ride-hailing operational data from a local PostgreSQL database (uber_analytics). The goal is to evaluate driver-rider cancellation dynamics, pinpoint peak hours of service disruption, and identify geographic regions suffering from supply-demand imbalances to drive operational optimization.

---

Database Schema & ERD

erDiagram
    USERS ||--o{ TRIPS : places
    DRIVERS ||--o{ TRIPS : accepts
    LOCATIONS ||--o{ TRIPS : originates_at
    TRIPS ||--o| CANCELLATIONS : results_in

    TRIPS {
        uuid trip_id PK
        uuid user_id FK
        uuid driver_id FK
        integer location_id FK
        timestamp request_timestamp
        string status
    }

    CANCELLATIONS {
        uuid cancellation_id PK
        uuid trip_id FK
        string cancelled_by
        string cancellation_reason
        timestamp cancelled_at
    }

Loading