BI,Case Study
SOLVING PRIVACY, SECURITY AND AUDITABILITY ISSUES FOR A BANK
INTRODUCTION One of our clients, who mainly had problems with the implementation of privacy, security and auditability in the data warehouse, is a large financial service provider from Germany. As a bank, they are diversified and offer both b2b and b2c products. CASE DESCRIPTION As a financial services provider, the company collects and processes a large volume of data and must protect it properly, given compliance requirements in this sector. However, the existing data warehouse did not allow the company to comply with today’s standards in Data Warehousing. In particular, the implementation of privacy, security, auditability and the new master data manage- ment caused the customer major problems in the existing data warehouse. This led to major challenges for the management to solve, which could have led to a cost explosions and worse if ignored:
● Privacy (GDPR, AML etc.) - legal consequences and loss of customer trust ● Security - high costs after disaster and loss of customer trust ● Auditability - lack of traceability and data quality problems ● Lack of master data management - data quality issues
Due to this, the client wanted to build a new data warehouse and needed a suitable solution to these problems. After extensive research and comparison of the possible solutions on the market, it be- came clear to the customer that Data Vault 2.0 provides solutions for these typical problems and can be implemented through Data Warehouse Automation. Therefore, the customer decided to rebuild their BI landscape using Data Vault 2.0 and WhereScape. A rough overview of the architecture can be seen in Figure 1. In addition, the customer uses the following TechStack for implementat
● Microsoft SQL Server ● WhereScape 3D & RED
● Azure DevOps ● Microsoft Power BI
2/3
Solving Privacy, Security and Auditability Issues for a Bank © Scalefree International GmbH 202 3
Building the data warehouse allowed Scalefree to solve the customer’s problems and implement a modern BI solution. As a result, there is a strong risk and possible consequential cost minimization through fully comprehensive security and privacy concepts. Furthermore, we prevent data quality problems by introducing the new master data management and data lineage. Lastly, it was possible to provide the first reports very quickly because the development is achieved quickly within Data Vault 2.0 and Data Warehouse Automation.
With the introduction of Data Vault 2.0, the customer was finally able to implement a BI solution in accordance with today’s standards. If you would like to learn more about Data Vault 2.0 and how it addresses the described issues, or learn more about our consulting services, please do not hesitate to contact us.
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
3/3
Solving Privacy, Security and Auditability Issues for a Bank © Scalefree International GmbH 202 3
Page 1 Page 2 Page 3Powered by FlippingBook