Motor Industry – Rules Based Data Collection

This case study shows how a provider of administrative services to over 200 motor vehicle dealerships used SolveXia’s automated solution to solve its rules based data collection complication.

Client: Provider of administrative services to over 200 motor vehicle dealerships across Australia.

Problem: Need to combine data from all of the dealerships each month (200+ files). Data sourced from different systems/vendors in inconsistent formats.

Solution: Rules-based solution to append all of the data together, apply transformations and perform validation checks – that can be maintained entirely by the business.

Key metrics:

  • Prototype created within 2 weeks
  • Over 40 steps automated
  • Automated solution runs in under 3 minutes
  • Application of 20+ transformations
  • Execution of 10+ unique validations
  • System capable of processing 10m+ records
  • Significant reduction in total cost of ownership by giving control to business users
  • 80% reduction in manual effort

 Download the case study

Recent Posts

Leave a Comment

Start typing and press Enter to search