Scalefree  Case Studies Proof of Concept for a Scalable Data Platform of a Kitchenware Retailer

About the Client

The client is a globally renowned manufacturer and retailer of kitchenware with international brands and retail stores – both online and in-store.

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
Future-proof data integration strategy with Microsoft Azure Blog Storage, Snowflake and Tableau

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

Interested in learning more? Get the detailed case study!