A car insurance company wanted to have higher data quality and faster system response times when reporting. Additionally, they wanted to create a system which had the ability to store the data.
About the Client
Problem Statement
- A data management problem which resulted in more work and time waste for the client
- The system in place had problems with changing structures and therefore the effort in keeping it updated was too great
- Data quality issues and scalability problems led to the system reaching its limits
- Switching to another option was more cost intensive
The Challenge
- A more sophisticated system was needed to provide the information required
- More in-depth technical knowledge was needed which was not provided by the internal workforce
- It was necessary to have quicker testing of the operation and systems
- It was required to make better use of the information that was available to them
The Solution
- Virtual Data Vault used to show the data model
- This approach was able to adjust to modifying structures in the data
- Showed problems in file formatting and a business key problem
Tangible Results for the Client
- Optimize timings and fix data quality
- Focus on developing new features
- Make better use of their information
- Reduce their costs due to less effort with the new system
- Adjust the processes currently in use
Technologies used
- Kafka
- SQL
Marc Winkelmann
Managing Consultant
Phone: +49 511 87989342
Mobile: +49 151 22413517
Free Initial Consultation