Scalefree – Case Studies – Building an Effective Data Warehouse for a Consulting Company

About the Client

The client is a consulting company for capital investment processes and profit-oriented risk management. The company is active in asset/liability analyses, strategic capital investment planning, risk management, organization of capital investments, manager selection and IT/process consulting.

Problem Statement

  • The data quality was insufficient which was causing inconsistent delivery of KPI
  • There was no reliable security concept
  • Current Data Warehouse was causing many performance-related problems
  • Better compatibility of automation tools with Data Vault
  • Inconsistency of  old Data Warehouse with modern data ecosystems
  • Every new business rule required re-engineering in the old Data Warehouse which was an extremely time-consuming process

The Challenge

The client had the following challenges which Data Vault solved:

  • The existing model was not able to integrate some sources well
  • There were privacy concerns regarding GDPR 
  • A scalable BI practice was not achievable
  • The data was not achievable in a user-friendly way, meaning the client was unable to generate customized reports

The Solution

The client benefited from the following solutions:

  • The data must be available in a user-friendly format in order to satisfy business requirements which was achieved by Data Vault 2.0
  • Using one of the automation tools-in an efficient way is possible with Data Vault 2.0
  • Data Vault 2.0 fulfills all scalability and performance requirements
  • Saving time by avoiding re-engineering in case of new business rules
Multisecure data warehouse with data vault

Tangible Results for the Client

The client achieved the following results with Data Vault 2:

  • Custom reports for end-users were acquired without any delay and error
  • The client adopted rapid changing business rules without any re-engineering and saved time
  • A future-proof data warehouse was achieved was compatible with any automation tools

Technologies used

Interested in learning more? Get the detailed case study!

Marc Winkelmann Managing Consultant

Marc Winkelmann
Managing Consultant

Phone: +49 511 87989342
Mobile: +49 151 22413517

Schedule Your
Free Initial Consultation