Skip to content

Master school mastery project: Metrocar funnel analysis

Notifications You must be signed in to change notification settings

Dan3Moshe/Metrocar_funnel_MS

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

20 Commits
 
 
 
 
 
 

Repository files navigation

Metrocar funnel analysis Master school

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.

The project features four stages:

  1. Extraction of user-level and ride-level aggregated dataset using SQL.
  2. Developing Metrocar funnel matrix regarding the given buisness questions.
  3. Written report of the funnel analysis.
  4. Prepeare presentation.

Table of contents

  1. Metrocar_funnel_analysis.docx - Metrocar funnel analysis written_report.
  2. Metrocar Slides - slides for a video presentation relaying the results.
  3. Metrocar_script.sql - SQL script used to extract data for analysis for current project.

Links To Spreadsheets

1.Metrocar Aggregated Data

2.Price Surging

Links to Tableau Dashboards

1.Price Surging Dashboard

2.User/Rides Funnel Level Dashboard

About

Master school mastery project: Metrocar funnel analysis

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published