This is one of 4552 IT projects that we have successfully completed with our customers.

How can we support you?

Creation of a data warehouse

Brief description

The existing, complex data warehouse (DWH) at the German retail subsidiary of a global corporation is to be rebuilt. In addition to the analysis options, the DWH is also to function as a company-wide data hub.

Supplement

The data flows in the DWH to be created should be simplified and standardized compared to the existing solution. All data flows should be made easily monitorable. The connection of new sources to the DWH should be easy to implement. In addition, it should be possible to analyze incoming data well. Since the company already uses a Microsoft environment intensively, the DWH will be built based on SQL Server 2019. The data flows are implemented using PowerShell scripts, which are controlled by SQL Server agent jobs.

Subject description

The goal is to build a clear, stable and easily supportable reporting system that also serves as a data hub between the various connected systems. Specific standard reports are automatically sent daily, weekly or monthly via HTML email. The HTML email itself is created via PowerShell.

Overview

Project periodProjektbeginn01.04.2020

Have we sparked your interest?

Marcus Rödiger

Retail sector manager

Jetzt Kontakt aufnehmen

Zum Umgang mit den hier erhobenen Daten informieren wir in unserer Datenschutzerklärung.

Contact now

We provide information on the handling of the data collected here in our privacy policy.

Download file

We provide information on the handling of the data collected here in our privacy policy.