Welcome to the Goodcabs Data Insights and Performance Analysis project repository! This project delivers actionable insights and recommendations to enhance the performance and revenue of Goodcabs, a cab service provider specializing in tier-2 cities across India.
- 🚀 Project Overview
- ❓ Problem Statement
- 🏢 About Goodcabs
- 🛠️ Tools & Technologies
- 📈 Dashboards
- 📊 Key Insights
- 📂 Repository Contents
- 📋 Steps Followed
- 💡 Recommendations
- 📜 Live Dashboard
- 📝 Contact
The Goodcabs Data Insights and Performance Analysis project aims to provide actionable insights to the Chief of Operations at Goodcabs by analyzing key performance metrics and addressing critical business questions in the transportation and mobility domain.
Goodcabs faced several challenges, including:
- Identifying top-performing cities and regions.
- Tracking and achieving key revenue targets.
- Understanding passenger behavior, especially repeat customers.
- Discovering opportunities for growth in underperforming cities.
This project was designed to tackle these challenges and support data-driven decisions.
Goodcabs is a cab service provider specializing in tier-2 cities in India. The company focuses on delivering affordable and reliable transportation services while maintaining high customer satisfaction through efficient operations.
- Power BI: Interactive dashboards and visualizations.
- SQL: Querying, aggregating, and transforming data.
- Power Query: Data preparation and transformation workflows.
- Canva: Creating visually appealing presentations.
- City and Month Analysis:
- Compare performance metrics city-wise or month-wise dynamically.
- Repeat Passenger Analysis:
- Explore trends and factors influencing passenger retention.
- Actual vs Target Metrics:
- Compare actual performance against targets to identify gaps.
- Revenue Metrics:
- Insights into average fares and city contributions to overall revenue.
- Top Cities: Cities like Pune and Nashik dominate revenue generation.
- Fare Efficiency: Insights into average fare per kilometer and per trip.
- Repeat Passenger Trends: Identified cities with higher passenger retention rates.
- Target Metrics: Unveiled growth opportunities in underperforming cities.
SQL-Scripts/: SQL queries for data extraction and transformation.PowerBI-Report/: Power BI report file for visualizations (Goodcabs_Report.pbix).Presentation/: Business presentation with insights and recommendations.Live-Dashboard/: Link for the live dashboard.
- Data Extraction:
- Retrieved data from sources such as
fact_tripsandtargets_db.
- Retrieved data from sources such as
- Data Cleaning:
- Ensured consistency, removed duplicates, and addressed missing values.
- Data Transformation:
- Aggregated metrics like average fares and contribution percentages.
- Data Loading:
- Imported clean datasets into Power BI for analysis.
- Visualization:
- Designed interactive dashboards for key business metrics.
- Insights & Recommendations:
- Delivered actionable insights for performance improvement.
- Focus on Top Cities:
- Enhance marketing and service quality in high-revenue cities.
- Loyalty Programs:
- Introduce rewards or discounts for repeat passengers.
- Expand to Tier-2 Cities:
- Invest in cities with untapped demand potential.
- Dynamic Pricing:
- Adjust fares during high-demand periods to boost revenue.
- Operational Efficiency:
- Optimize fleet routes using predictive analytics.
- Employee Incentives:
- Introduce rewards for achieving monthly targets.
Live Dashboard - Click here to view the dashboard
Feel free to reach out for questions or feedback:
- Name: Ganesh Gadekar
- Email: ganesh.gadekar474@gmail.com
- GitHub: https://github.com/grgadekar