Ride-Sharing Analytics Platform — SQL Data Engineering Project

Built a relational ride-sharing analytics database using real NYC taxi trip data to generate business KPIs, pricing insights, rider retention metrics, and driver performance analysis.

PROJECTS

Chandan N

2/27/20261 min read

Problem
Raw ride-sharing trip datasets lack structure for meaningful pricing, customer, and driver performance insights.

Objective
Design a structured analytics database to support:

Trip performance analysis
Pricing optimization insights
Customer retention tracking
Driver income analytics

What I Built?

Relational schema (Drivers, Riders, Trips, SurgePricing)
Integrated 50k+ trip records (NYC Taxi dataset + synthetic enrichment)
Developed 25+ advanced SQL analytical queries
Created KPI-focused reporting structure

Key Analyses

Surge pricing revenue impact
Trip cancellation patterns
Rider retention cohorts
Loyalty rider segmentation
Driver earnings inequality analysis

Tools & Technologies
SQL, Relational Database Design, Data Modeling, Data Analytics

Outcome
Demonstrated an end-to-end data engineering workflow converting raw trip data into structured analytics and business insights.

Link: https://github.com/chandan-n-max/NYC_Taxis_ChandanN