This project aims to analyze the customer funnel of Metrocar, a ride-sharing app (similar to Uber/Lyft), to identify areas for improvement and optimization.
- Extraction of user-level and ride-level aggregated dataset using SQL.
- Developing Metrocar funnel matrix regarding the given buisness questions.
- Written report of the funnel analysis.
- Prepeare presentation.
- Metrocar_funnel_analysis.docx - Metrocar funnel analysis written_report.
- Metrocar Slides - slides for a video presentation relaying the results.
- Metrocar_script.sql - SQL script used to extract data for analysis for current project.