BI,Case Study
PROOF OF CONCEPT FOR A SCALABLE DATA PLATFORM OF A KITCHENWARE RETAILER
INTRODUCTION A globally renowned manufacturer and retailer of kitchenware set out to implement a scalable, reliable data analytical platform to produce reports and dashboards on their global product and sales performance. CASE DESCRIPTION The client faced significant challenges in consolidating data from diverse operative sources, while ensuring GDPR compliance. They grappled with a complex data model with varied business perspectives and definitions of products across different countries, storefronts, and business areas, such as Sales, Manufacturing, and E-Commerce. Additionally, migrating their existing solutions into a new Data Vault 2.0 framework posed a substantial hurdle. To address these challenges, Scalefree collaborated closely with the client team. In the project’s ramp-up phase, the Scalefree-owned Data Vault 2.0 implementation package, datavault4dbt, was introduced to streamline the development process and ensure standard conformance. Adopting Data Vault implementation standards and GDPR-compliant data privacy policies was paramount. Best practices to handle personal identifiable information within the Data Vault solution were established for the new data architecture - enabling the IT team to promptly react upon data deletion requests.
Furthermore, a proof of concept of Data Vault was developed through collaboration of Scalefree experts and the internal team of data engineers. The scope involved migrating an existing data product - the global sales performance dashboard, to the new data platform powered by dbt Cloud, Snowflake, and Data Vault 2.0. The implementation consisted of modeling of product and sales data from the enterprise SAP HANA system, as well as the global product catalog management system. During the modeling process, further source systems and business perspectives were taken into consideration. The result was a future-proof model foundation with core business concepts Products and Sales Orders, where the aforementioned different business perspectives and definitions of business keys across operations are integrated. Together with the client’s BI team, Scalefree then successfully delivered an end-to-end solution to migrate the existing global sales dashboard to the new data architecture with Data Vault 2.0. As stretched goals, end-to-end solution designs for upcoming reports and dashboards were also delivered by the Scalefree team. The implementation of Data Vault 2.0 led to a remarkable improvement in data solution performance, with efficiency gains of up to 80% compared to earlier approaches. This not only ensured GDPR compliance but also future-proofed their data integration strategy, setting the stage for reliable reporting and analytics.
PROOF OF CONCEPT FOR A SCALABLE DATA PLATFORM OF A KITCHENWARE RETAILER © SCALEFREE INTERNATIONAL GMBH 2024
2/3
Scalefree International GmbH Schützenallee 3 30519 Hannover Germany
P: +49 (511) 879 893 41 M: +49 (175) 811 0336 F: +49 (511) 879 893 49
info@scalefree.com www.scalefree.com
CEOs: Michael Olschimke & Christof Wenzeritt
Page 1 Page 2 Page 3Powered by FlippingBook