The client is a globally renowned manufacturer and retailer of kitchenware with international brands and retail stores – both online and in-store.
About the Client
Problem Statement
The client set out to implement a GDPR-compliant, scalable, and reliable data platform to produce reports and dashboards on their global product and sales performance. An architecture foundation based on Snowflake and the Data Vault methodology for the implementation had already been considered.
The Challenge
- Consolidation of data coming from diverse operative sources
- Complex data model with varied business perspectives
- Various business definitions of product from different countries and storefronts
- Migration of existing solution into the new Data Vault 2.0 solution
The Solution
Scalefree worked alongside the client team and provided support in the following:
- Introducing Scalefree’s Data Vault 2.0 implementation package datavault4dbt in the development project – enabling standard-conformed and accelerated development of data solutions
- Adopting Data Vault implementation standards and conventions with regards to GDPR-compliance and data privacy policies
- Development of a proof of concept with Data Vault 2.0 for the global sales performance report
- Consistent data model across global operations for a future-proof data integration strategy
Tangible Results for the Client
- End-to-end solution for the global sales report.
- Development of solution designs for upcoming reports
- Improved performance of data solutions by up to 80% with Data Vault 2.0, compared to earlier approaches
Technologies involved
- Snowflake
- Dbt Cloud with datavault4dbt
- Microsoft Azure DevOps
- Tableau
