Harmonizing the Data Landscape of a National Financial Inst…

BI,Case Study

HARMONIZING THE DATA LANDSCAPE OF A NATIONAL FINANCIAL INSTITUTION

INTRODUCTION The client was a leading financial services company with activities ranging from mortgage to insurance that wanted to make more rational decisions by becoming data-driven. Therefore, they wanted to transform their current architecture to a data-driven enterprise platform.

CASE DESCRIPTION The company wanted to better connect different financial services to decrease operational costs by reducing data contradictions. Several acquisitions led to inconsistency and trust issues regarding the underlying data. A standardized, organization-wide data platform needed to be created. The current solution faced a few problems. In general, all data-related business processes were rigid and slow and therefore the user acceptance of the data warehouse was low. Furthermore, har- monized definitions of central business objects were missing and thus led to inefficient and costly redundancies. Overall, the current system was not able to adapt and deal with Big Data and this ineffective scaling behavior caused high but avoidable costs. Along with accommodating these problems, the client faced a few challenges which made targeted action even more difficult. A main issue was that responsibilities between different departments were unclear. This led to other ambiguities regarding an applicable architecture to solve the tech- nical challenges. Adding further, a scalable data warehouse solution would require deep technical knowledge in Data Vault 2.0 which no internal resources were able to provide.

To clarify these points, the company was looking for an experienced consulting partner with experi- ence in Data Vault 2.0 and implementation of managed Self-Service BI.

Scalefree presented the client a Solution that focused on a standard-driven conversion of the cur- rent Data Vault 1.0 model to a Data Vault 2.0 implementation. This would enable an easy integration of multiple source systems and therefore allows the client to create a standardized Managed Self Service BI solution. To allow such an implementation, the solution included the improvement and completion of an Azure-based tech stack that exceeded the client’s scalability and performance re-

Harmonizing the Data Landscape of a National Financial Institution © Scalefree International GmbH 2023

2/4

quirements. Finally, Scalefree pointed out the benefits of using a commercial automation tool and identified spots where it would outperform the client’s current solution.

The review accelerated and supported solving important problems the client faced. Currently, slow data-related processes were speeded up by introducing a Data Vault 2.0 based agile workflow, which additionally reduced related costs. Furthermore, harmonizing various data sources becomes easier and therefore the data becomes more reliable, supports rational decision-making and raises the user-acceptance level of the data warehouse.

Scalefree’s solution included a suggested architecture to solve the clients problems:

The Azure-based tech stack included Azure Data Lake Storage as a persistent or transient Data Lake. Azure Polybase would be used to extract the data from the data lake into the Azure Synapse-based data warehouse.

Harmonizing the Data Landscape of a National Financial Institution © Scalefree International GmbH 2023

3/4

Scalefree International GmbH Schützenallee 3, 30519 Hannover, Germany

P: +49 (511) 879 893 41 M:+49 (175) 811 0336 F: +49 (511) 879 893 49

info@scalefree.com www.scalefree.com

CEOs: Michael Olschimke & Christof Wenzeritt

Harmonizing the Data Landscape of a National Financial Institution © Scalefree International GmbH 2023

4/4

Page 1 Page 2 Page 3 Page 4

www.scalefree.com

Powered by