OLA Ride Analytics Dashboard – Power BI Project

Developed a comprehensive Power BI dashboard to analyze and visualize ride data for a ride-hailing platform similar to OLA. The project aimed to provide actionable insights into customer behavior, driver performance, ride patterns, and revenue distribution. Key features included time-series analysis of ride volumes to identify peak periods, booking status breakdowns showing successful rides and cancellations, and comparisons of vehicle types based on distance traveled and customer ratings.

Additional visualizations highlighted cancellation reasons, revenue by payment method, and top customers by booking value, supporting operational and financial decision-making. Advanced visuals like histograms and scatter plots were used to examine ride distance distribution and rating correlations between customers and drivers. The project involved extensive use of Power BI tools such as DAX, Power Query, and data modeling, combined with initial data cleaning in Excel.

This dashboard enabled a deeper understanding of ride trends, customer satisfaction levels, and revenue sources, demonstrating strong skills in data transformation, KPI development, and business storytelling through interactive visualizations.