The client is the IT-Department of a leading technology and manufacturing company. This company creates smart solutions and products for pushing digitalization in the industry, in infrastructure and mobility.
About the Client
Problem Statement
The Challenge
- Collect all data from several sources
- The client is not familiar with the Data Vault 2.0 concept
- Implementation of Data Vault 2.0 Model
- Moving data from a core data platform to a cloud solution
- Keeping the logic applied in the old data warehouse
- Short timeframe
The Solution
- Migrate the data from the SAP HANA solution to Snowflake
- Implement a more organized, adaptable data strategy to handle both current and incoming data
- Create data loading processes using dbt as the automation tool
- Maintenance of good practices from Data Vault 2.0
- Implementing a fully audible and automated Raw Data Vault
Tangible Results for the Client
- Centralized data collection which enhances efficiency, leading to decreased costs
- Client has successfully established a modern and future-proofed data warehouse architecture
- This architecture is key for developing reporting and analytical applications, enabling better data-driven decisions across various departments
Technologies involved
- SAP Hana DB
- DBT
- Snowflake DB
Interested in learning more? Get the detailed case study!
Marc Winkelmann
Managing Consultant
Phone: +49 511 87989342
Mobile: +49 151 22413517
Free Initial Consultation