This project is a comprehensive analysis and visualization of operational data for GoodCabs, a cab service company committed to supporting local drivers and providing excellent customer service. The primary focus is to extract actionable insights and develop a data-driven strategy to enhance operations, customer satisfaction, and revenue.
The analysis and recommendations align with the company's goals of sustainable growth and excellence in customer experience.
-
Interactive Power BI Dashboard:
- Trips Dashboard:
- Peak and low-demand months by city.
- Total trips analysis (weekdays vs. weekends).
- Monthly target trips by city.
- Passenger Dashboard:
- Repeat vs. new passenger trends.
- Peak demand by passenger type and day.
- Passenger ratings and city-wise comparisons.
- Driver Dashboard:
- Driver ratings by passenger type and city.
- Performance trends for repeat passengers.
- Revenue Dashboard:
- Monthly and seasonal revenue patterns.
- Revenue by passenger type and city.
- Trips Dashboard:
-
Key Insights:
- Business-focused cities (e.g., Surat, Vadodara) show high weekday trip volumes and repeat passenger loyalty.
- Tourism-focused cities (e.g., Jaipur, Chandigarh) excel in weekend and seasonal demand.
- Opportunities to leverage EV policies in Gujarat for sustainable growth.
-
Recommendations:
- Strategic pricing adjustments for business and tourism cities.
- Partnerships with local businesses and tourist hotspots.
- Deployment of EVs and development of charging infrastructure.
- Power BI: For interactive dashboard creation and visualization.
- SQL: For querying and analyzing large datasets.
- Data Sources: Trip data, passenger ratings, revenue metrics, and external industry insights.
-
Explore the Dashboard:
- Access the interactive dashboard here.
- Navigate through the pages to understand trip patterns, passenger behavior, driver performance, and revenue trends.
-
Repository Structure:
Business Request Data/: Contains processed datasets requested by the business.datasets/: Includes all the datasets and database files provided by the business.Business requests SQL: Script containing SQL queries for data processing.
-
Key Insights and Recommendations:
- Refer to the
Goodcabs Presentation.pptxfor a detailed overview of actionable strategies.
- Refer to the
For questions or suggestions, reach out to:
- [Amit Subhash Chejara]: [amitsubhashchejara@gmail.com]
- LinkedIn: [https://www.linkedin.com/in/amitsubhashchejara/]
- My Website: [https://amitsubhashchejara.github.io/mywebsite/]
- X: [https://x.com/amitschejara]