Date: May 2025 Role: Data Analyst Technologies: Power BI, Power Query, DAX Data Source: Good Cab Transportation CSV Data (May–Jun 2025)

Good Cabs, a fast-growing urban mobility service provider, needed insights into its trip volume, passenger satisfaction, and city-level performance. As the Data Analyst on the team, I developed a comprehensive Power BI dashboard to help stakeholders monitor performance, identify underperforming regions, and improve customer retention.

To clean and model the data using Power Query, build KPIs using DAX, and visualize operational insights to help the business:

Understand trends in trips, revenue, and customer behavior

Identify cities with growth opportunities or concerns

Compare new vs repeat customer dynamics

Track performance against targets at city and company level

Total Trips: 426,000

Total Revenue: ₹108M

Passengers Served: 238K

Average Ratings:

Total Distance Travelled:

Average Fare per KM:

Top Cities (by Revenue): Jaipur, Kochi, Chandigarh

Bottom Cities: Mysore, Vadodara, Coimbatore

Passenger Satisfaction:

Peak Months: February & March

Low Demand Month: June

Weekday vs Weekend Trips:

Repeat Trip Drop-off:

Highest Repeat Rate: Surat (42.63%)

Lowest Repeat Rate: Mysore (11.23%)

Performance Against Target:

Strengthen loyalty programs to retain new customers

Investigate reasons for low repeat satisfaction

Allocate marketing spend in underperforming cities

Launch seasonal campaigns to recover June's slump

Use Surat’s repeat strategy in other cities

Power BI: Dashboard development & data storytelling

Power Query: Data transformation & cleanup

DAX: Custom metrics like Avg Fare/KM, Retention %, Target vs Actual

The Good Cabs dashboard empowered leadership to make data-driven operational and marketing decisions. It brought visibility into customer satisfaction, regional performance, and repeat behavior—enabling targeted interventions to boost trip volume and retention.

Created by ,

Data Analyst