The client was a leading financial group with a variety of services from banking who wished to migrate from an on-premise solution to a cloud data warehouse.
About the Client
Problem Statement
- Limited scalability and performance constraints of an existing data warehouse
- Inflexible architecture inhibits agility and responsiveness to handle the business requirements
- No pipelines for data quality to ensure data accuracy for analysis
- High maintenance costs and no cost management
The Challenge
- Team training for new tools and Data Vault 2.0
- Seamless communication and coordination of cross-functional teams to mitigate risks and handle tight timelines
- Compatibility from existing solution with new cloud data warehouse solutions
The Solution
The transformation tool dbt with the open-source package DataVault4dbt simplified the data vault implementation and had a high customizability for individual requirements. In addition, dbt provides generic and custom tests to ensure high data quality.
Tangible Results for the Client
Technologies involved
Interested in learning more? Get the detailed case study!
Marc Winkelmann
Managing Consultant
Phone: +49 511 87989342
Mobile: +49 151 22413517
Free Initial Consultation