About the Client

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.

Problem Statement

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

The Challenge

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

The Solution

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.

Tangible Results for the Client

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

Technologies used

  • 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

Interested in learning more? Get the detailed case study!

Make An Appointment with Us

Profile Photo of Jürgen Dackweiler


Phone: +49 (511) 879 89342
Mobile: +49 (175) 811 0336