Setting up an Enterprise Data Warehouse

Challenge

The existing data warehouse, which had grown over many years, could no longer meet the current requirements for speed and flexibility. The data flows, which are classically built on redundancy, only allow changes to existing models with great effort and thus significantly reduce the speed of adaptation, which in turn led to dissatisfied departments and increased shadow IT. Self-service approaches could hardly be implemented due to the lack of performance.

Facts about the customer

Industry: Information technology in banking and commerce

Company size: Corporation

Solution

The implementation of a data warehouse based on SAP HANA has more than fulfilled the requirements of a modern data warehouse architecture. Flexible and easily adaptable models were designed through database-related processing in conjunction with strong virtualisation, which allow an agile approach to data provision. Due to the high processing speed of an in-memory solution, high-performance reporting has become possible which allowed the departments to work independently on their data.

 

Customer benefit

Regularly required reports can be made available on time and with high performance. Due to the lean virtualised architecture, adjustments to new customer requirements can be made easily and quickly. Data models can be linked virtually and allow new insights into company data and processes. This can significantly accelerate and qualitatively strengthen the process of decision-making.