Data Platform Strategy Workshop for a Kitchenware Retailer

BI,Case Study

DATA PLATFORM STRATEGY WORKSHOP FOR A KITCHENWARE MANUFACTURER AND RETAILER

INTRODUCTION A leading kitchenware manufacturer and retailer wants to set up a scalable data platform for its analysts to be able to analyze their product and sales performance across different channels. CASE DESCRIPTION Before the client actively started to build a new data platform, a strategy commitment and a “how- to-start” plan contained some uncertainties. A couple of decisions, at least on a high level, needed to be made upfront. From a technical perspective, a database technology needs to fit the requirements. Especially when structured and semi-/unstructured data is present, multiple database technologies may be used. Another challenge is to define a tool-stack with regards to orchestration and ETL (extract, transform, load). The aspect of code generation and automation capabilities should also get attention. From a methodological point of view, a project management framework as well as a modeling technique and a logical architecture needs to be defined. And last but not least, what skills and budget do we need to handle all this? All these platform, tool, and methodology decisions have to be made by considering some challenges regarding scalability (reaction to changes in the operating world), standardized processes, complex data structures, deletion/anonymization of personal identifiable information, and how to meet auditability requirements. That’s why they were looking for a consulting partner with deep knowledge of the provided challenges to help them to define a strategy and overall methodology in those areas. The client selected Scalefree to perform a three day workshop to go through the challenges described above. Before the workshop, a meeting between Scalefree and the Client took place to discuss the agenda and answer open questions.

As a methodology, Data Vault 2.0 was already considered, which was discussed in more detail in the workshop itself. Also the complex data structures were discussed based on best practices related to where and how to resolve the structures. Additionally, a solution was found for the GDPR challenge as well by introducing a process to deal with it while considering performance and auditability.

DATA PLATFORM STRATEGY WORKSHOP FOR A KITCHENWARE MANUFACTURER AND RETAILER © SCALEFREE INTERNATIONAL GMBH 2024

2/3

During the workshop, the technical architecture, the Data Vault 2.0 methodology, processes and best practices were discussed, and a plan for the next steps was created. This saved a lot of time for additional Proof of Concepts or try-and-error approaches. The elaborated plan during the Workshop was also accompanied and supported by Scalefree consulting to answer additional questions.

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 3

www.scalefree.com

Powered by