HNG Ride Performance and Revenue Analytics

Project Overview

This PostgreSQL project analyzes HNG Ride’s operations from June 2021 to December 2024 to evaluate driver performance, revenue trends, and rider activity. Using cleaned datasets for drivers, riders, rides, and payments, the analysis identifies key business metrics like Chicago’s 19.26% cancellation rate and the retention of 1,082 riders from 2021 into 2024. Complex SQL queries were utilized to rank top revenue-earning drivers by city and determine eligibility for performance-based bonuses. Ultimately, these data-driven insights serve to help management address operational inefficiencies and improve strategic decision-making. 

Project Objectives

The primary objectives of the project are:

1. Examine HNG Ride's operations between June 2021 and December 2024.

2. Focus on key performance metrics, specifically driver performance, rider activity, revenue trends, and payment behavior.

3. Identify business strengths and address operational inefficiencies.

4. Improve decision-making for future operations through data-derived insights.

5. Evaluate specific business outcomes, such as identifying top drivers for bonuses, calculating city-wide cancellation rates, and measuring rider retention

Business Questions Answered

QUESTION 1: Find the top 10 longest rides (by distance), including the driver name, rider name, pickup/dropoff cities, and payment method.

Result:

QUESTION 2: How many riders who signed up in 2021 still took rides in 2024?

Result:

QUESTION 3: Compare quarterly revenue between 2021,2022,2023 and 2024. Which quarter had the biggest YoY Growth?

Result:

QUESTION 4: For each driver, calculate their average monthly rides since signup. Who are the top 5 drivers with the highest consistency (most rides per active month)?

Result:

QUESTION 5: Calculate the cancellation rate per city and identify which city had the highest cancellation rate.

Result:

QUESTION 6: Identify riders who have taken more than 10 rides but never paid with cash.

Result:

QUESTION 7: Find the top 3 drivers in each city by total revenue earned between June 2021 and Dec 2024.If a driver has multiple cities, count revenue based on where they picked up passengers.

Result:

QUESTION 8: Management wants to know the top 10 drivers qualified for bonuses based on:

Result:

Conclusion

This analysis of HNG Ride’s operations from June 2021 to December 2024 highlights a business with strong rider retention but clear regional inefficiencies. By leveraging PostgreSQL to evaluate over three years of data, the project successfully identified critical performance gaps, such as high cancellation rates in Chicago and the need for more structured driver incentive programs. 

These insights provide a data-driven roadmap for management to optimize revenue through targeted city strategies and to reward high-performing, consistent drivers who maintain the platform's service standards. Ultimately, the transition from raw data to actionable metrics ensures that future operational decisions are grounded in efficiency rather than just scale.