References

RESIDUAL VALUE MONITORING & INFORMATION FLOW MODELING

Project outline

  • A car manufacturer wishes to accurately determine the residual value (RV) of vehicles at the end of the leasing period.
  • In this context, the manufacturer’s Residual Value department wishes to improve the monitoring of the residual value of the group’s vehicles and those of its competitors by creating a homogeneous database from various external sources (CAP, Argus, DAT, Eurotax, etc.) in order to facilitate analysis and decision-making.

Project approach

  • Implementation of an automation procedure for standard reporting on residual value.
  • Creation of a method to homogenize source databases (Argus, Eurotax, DAT, CAP, etc.) via Alteryx.
  • Writing of a user manual explaining the operating modes to generate quarterly reports via Alteryx.

Results

  • Tool to connect the different data sources (Residual Value, Used Vehicle, New Vehicle).
  • Algorithm for creating a common database for the different sources under Alteryx.
  • Quarterly reporting of key residual values to brands worldwide (approximately 100 contacts).
  • User manual for automated reporting (use, maintenance, evolution).
  • Creation of a vehicle | version ID correspondence exploitable in the data-hub and in the VR modeling tools used by other departments of the group (Vehicle Financing).
  • Animation of Alteryx trainings.

Pagamon is a strategy and transformation consulting firm founded in 2013. We support major players in the industry, services and life sciences sectors in their search for balance. Helping them structure their strategic vision, transform their operational and/or digital model, and drive change. To support profitable, sustainable and responsible growth. As a committed player, Pagamon leads the Observatory of the Balanced Organization™, articulated around a "think tank" and an annual survey. In order to provide an innovative, sometimes offbeat, perspective on the strategic and operational implementation of transformations to support the growth of companies.