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.
- 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