Scalefree - Fallstudien - Implementing a Presentable Data Warehouse for a Leading Consulting Company

Über den Kunden

The client advises top-level management and operates in over 65 countries. The consulting  company pursues the goal of substantially and permanently improving the performance of its clients.

Problemstellung

The existing on-premise Data Warehouse solution did not use leading state of the art technologies. As a consulting  company, the client wanted to implement a showcase project to present to their clients as well. In this way, the client wanted to overcome  the following issues which were not feasible in the current solution as:

  • The on-premise solution was limited to certain sources
  • There were many bugs due to a misconfigured automation tool 
  • There were  performance issues with the old Data Warehouse
  • Problems connecting to cloud services plagued to process

Die Herausforderung

Due to the fact that an on-premise solution was used, there were some challenges that arose in this regard, those being:

  • Performance issues due to limits in scaling-up and scaling-out
  • The on-premise solution was missing connectors to cloud services 
  • The current model could not integrate new sources that well
  • The client did not have technical knowledge regarding certain tools

Die Lösung

Against the background that there was no presentable architecture in place, we decided to create a cloud architecture and use the Data Vault 2.0 approach.

Konkrete Ergebnisse für den Kunden

With the new solution, the customer was able to:

  • Query the Enterprise Data Warehouse faster and with more concurrent users
  • Derive information with a higher business value due to the integration of new sources
  • Deliver new features without errors and in a quicker timeline

Verwendete Technologien

  • Data Lake on Amazon S3
  • Enterprise Data Warehouse on Snowflake
  • Data Warehouse Automation with Wherescape 3D/RED
  • Data Integration with snowmirror and snapLogic
  • Reporting/Dashboarding with Power BI and Tableau

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

Julian Brunner Senior Berater

Julian Brunner
Senior Consultant

Telefon: +49 511 87989342
Mobil: +49 171 9127711

Planen Sie Ihre
Kostenlose Erstberatung