1. Executive KPI Tracking: Monitored $4.20M Gross Revenue, 30K Total Bookings, and 395.96K KM Distance Covered across major cities (Bengaluru, Chennai, Delhi, Hyderabad, Pune).
2. Cancellation Analysis: Identified cancellation drivers to optimize operations—tracking a 7% Customer Cancel Rate and a 5% Driver Cancel Rate.
3. Revenue Breakdown: Evaluated revenue distribution across vehicle types (Bike vs. Auto) and analyzed payment trends (UPI, Cash, Cards, Wallet).
4. Advanced DAX & Data Transformation: Utilized Power Query ETL for data cleaning and implemented dynamic DAX measures (DIVIDE, SUM, COUNT) for accurate percentage metrics and KPI cards.
5. Interactive Filtering: Built dynamic city slicers (Pickup & Drop locations) and payment method filters to enable swift executive decision-making.
Like this project
Posted Oct 19, 2026
Key Highlights & Technical Features:
1. Executive KPI Tracking: Monitored $4.20M Gross Revenue, 30K Total Bookings, and 395.96K KM Distance Covered across ma...