Über den Kunden

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.

Problemstellung

The client undertakes the responsibility of consolidating vast amounts of data from a multitude of sources and disseminating it to numerous departments within the organization. A key obstacle is the inadequacy of the current database and its antiquated structure, leading to considerable inefficiencies and heightened operational expenses. This inefficiency underscores the need for a more modernized and streamlined data management solution.

Die Herausforderung

The client expressed a desire for Data Vault 2.0, emphasizing alignment with the architecture set by their internal IT department. Consequently, the following aspects required careful consideration:

  • 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

Die Lösung

Der Kunde wählte Scalefree als seinen Beratungspartner, um:

  • Migrate the data from the SAP HANA solution to Snowflake
  • Implement a more organized, adaptable Datenstrategie 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
Automated Migration with Data Vault 2.0

Konkrete Ergebnisse für den Kunden

The project delivered important assets to 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

Beteiligte Technologien

  • SAP Hana DB
  • DBT
  • Schneeflocke DB

Möchten Sie mehr erfahren? Holen Sie sich die ausführliche Fallstudie!

Vereinbaren Sie einen Termin mit uns

Profilfoto von Jürgen Dackweiler
JÜRGEN DACKWEILER

SALES MANAGER

Telefon: +49 (511) 879 89342
Mobil: +49 (175) 811 0336