Case study: a data-driven process audit for a car rental and sales company

Context

Sales, rental and service were recorded in three separate systems. Management decisions relied on fragmented reporting, with no unified analytical model of customer activity.

Task

Build systematic analytics and identify process optimization points.

Implementation

• Operations data consolidation and cleaning (100,000+ records)
• An end-to-end rental funnel built from the three systems' data
• Management reports and visualizations
• Customer segment and behavioral pattern analysis

Results

• Report preparation time reduced from days to hours
• Identified and resolved the largest funnel drop: the share of requests fell from 61% at booking to 24% at confirmation and payment — a loss of 37 percentage points
• Identified factors affecting fleet utilization and conversion
• Data-backed process optimization recommendations

The project became the foundation for regular data-driven management.