Rideshare Business Analysis: Revenue, Retention & Demand Insights

📌 Overview

This project analyzes a rideshare platform dataset to uncover key drivers of revenue, demand patterns, driver performance, rider retention, and payment reliability. The objective is to transform raw data into actionable insights that can support business decisions around growth, efficiency, and user retention.

📌 Executive Summary

• Revenue growth is highly volatile (+13.64% to -19.84%) with no sustained upward trend
• Top ~20% riders contribute ~65–70% of revenue, indicating dependency risk
• High early-stage churn (1–5 trips) is the primary growth bottleneck
• Growth opportunity lies in improving retention and increasing ride frequency

❓ Business Questions

1. How is monthly revenue trending, and how volatile is it?
2. When is demand highest — by hour and day of week?
3. Who are the top-performing drivers, and who is underperforming?
4. Who are our most valuable riders, and are we retaining them?
5. Are payments completing successfully, and which methods dominate?

📊 Dashboard Preview

📊 Dashboard Breakdown

The interactive dashboard enables stakeholders to:

• Monitor revenue trends and growth stagnation
• Identify peak demand windows for pricing and supply optimization
• Analyze driver performance trade-offs (efficiency vs reliability)
• Understand rider segmentation and churn patterns
• Track payment success rates and system reliability

🔍 Key Insights

1. Revenue Volatility & Growth Pattern
   • Revenue exhibits high volatility, with MoM changes ranging from +13.64% to -19.84%, and frequent fluctuations between positive and negative growth.
   • Despite occasional spikes, there is no consistent upward trend, indicating unstable growth driven by short-term demand variations rather than sustained user engagement.
   • This pattern suggests that revenue growth is not being sustained over time, likely due to high early-stage churn and inconsistent rider activity, highlighting the need to improve retention and repeat usage.
2. Demand is Highly Time-Concentrated
   • Peak demand occurs during weekday commute hours (morning & evening)
   • Indicates strong dependence on commuter-driven usage patterns
3. Revenue is Concentrated in Power Users
   • Top ~20% of riders contribute ~65–70% of total revenue
   • Indicates strong revenue concentration, where a small user segment drives majority of business value
   • This creates scalability risk, as growth depends heavily on retaining a limited group of users
4. High Early-Stage Rider Churn
   • A large percentage of users drop off after 1–5 trips
   • Indicates weak onboarding or low initial engagement
5. Driver Efficiency vs Reliability Trade-off
   • Weak correlation between trip volume and ratings
   • High-performing drivers are not always the most reliable
6. Payment System is Highly Reliable
   • Payment success rate is ~99% across all methods
   • Confirms strong transaction infrastructure and minimal friction

📈 Business Recommendations

• Improve Early Retention
  • Introduce incentives (discounts/offers) for first 3–5 rides
  • Goal: Increase user lifetime value (LTV)
• Reduce Revenue Dependency Risk
  • Launch loyalty/subscription programs for frequent riders
  • Encourage mid-tier users to increase ride frequency
• Optimize Peak Demand
  • Apply dynamic pricing during high-demand hours
  • Improve driver allocation in peak windows
• Enhance Driver Performance
  • Incentivize high ratings and reliability, not just volume

These strategies aim to increase retention, stabilize revenue, and drive sustainable long-term growth.

🧠 Approach

• Performed data extraction and analysis using SQL
  • CTEs, window functions, aggregations
• Built interactive dashboard using Power BI
  • Data modeling, DAX, slicers, bookmarks
• Conducted:
  • Time-series analysis (MoM trends)
  • Rider and driver segmentation
  • Demand pattern analysis

🛠️ Tools & Techniques

• SQL (Advanced querying, window functions)
• Power BI (Dashboarding, DAX, data modeling)
• Data Analysis & Business Insight Generation

🎯 Why This Project Matters

Rideshare platforms depend heavily on user retention, demand forecasting, and operational efficiency.

This project simulates real-world decision-making by:

• Identifying hidden revenue risks

• Highlighting churn bottlenecks

• Providing data-driven strategies for growth

• 
  

📁 Project Structure

rideshare-analytics/
│
├── data/
├── sql/
├── powerbi/
├── images/
│
└── README.md

🚀 How to Use

1. Run SQL files to explore and analyze the dataset
2. Open the Power BI file to interact with the dashboard
3. Use slicers to filter data and explore trends

📦 Data Source

Dataset sourced from Kaggle (Uber-like rideshare dataset), used for analytical and educational purposes.

📈 Key Takeaway

Sustainable growth in rideshare businesses is driven not by acquiring more users, but by retaining and activating existing ones.