Skip to content

Latest commit

 

History

21 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 
 
 

Repository files navigation


Goodcabs Performance Analysis 🚗

Targets & Revenue

Repeat Rate

Contents

  1. Report:
    • Report.pdf: A complete description of entire project.
  2. Power BI File:
    • BI.pbix: Interactive dashboard and visualizations.
  3. SQL Query File:
    • challenge.sql: SQL scripts for data extraction and analysis.

Key Insights

  • Trip Volume Analysis
  • Repeat Passenger Behavior
  • Customer Ratings Impact
  • Fare Per Trip Distribution

Tools Used

  • MySQL
  • Power BI
  • Excel

Recommendations

  1. Launch loyalty programs to boost repeat trips.
  2. Optimize pricing strategies based on city trends.
  3. Collect passenger demographic data for targeted campaigns.

How to Use

  • Open the Power BI file to explore the dashboard.
  • Use the SQL script to replicate the analysis.
  • Refer to screenshots for a quick view of the outputs.

About

It is a Part of Resume Challenge Competion conduct by CodeBasics

Resources

Stars

0 stars

Watchers

1 watching

Forks

Releases

Packages

Contributors