Manage Self-Service BI for Useful Reporting

INTRODUCTION One of the privately owned banks sought to enable their business users to create and adjust their own self-service BI platform without the need for IT assistance in order to achieve fast- er results. It also wanted to create a data warehouse that could generate internal and exter- nal reports from a single source and present all pertinent data from across the company. CASE DESCRIPTION

One of the leading private banks in Germany wants to offer their business users a centralized enterprise data warehouse that would support self-service clients, allowing them to build and adapt their own business intelligence platforms while still allowing dedicated service clients to conduct audits without risk. However, the cur- rent data warehouse infrastructure had reached its limitation regarding storage and agility. For example, complex calculations for hashing be- come a problem due to less memory. Due to these limitations, the bank decided to redesign the data warehouse from scratch with the following requirements : Self Service BI: The finance team wanted to use a Business Rule Management System (BRMS) to design their own solutions and lessen their reli- ance on IT Auditibility: 100% auditability of the data in the new data warehouse Security: Protecting sensitive data with an ex- tra layer of security Before making a final choice, the bank had scheduled a comprehensive Data Vault 2.0

training with Scalefree that included both the Data Vault 2.0 Modeling Class and the Data Vault 2.0 Boot Camp. The team decided to use an Scrum approach internally and introduce agile sprints. The first sprint was dedicated to defining database sche- mas for implementing the data warehouse’s different levels, including numerous user spac- es for Managed Self-Service BI. The team also defined the overall architecture , security, wiki documentation, roles and responsibilities for the project. During this sprint, the team started working on the functionality. For the first set of data, the team implemented Raw Data Vault, certain Business Vault entities and a virtualized information mart on top of these structures. The actual business logic, the soft rules, were left for the second sprint. The method was simi- lar to that taught in the Dat Vault 2.0 Boot Camp. After the successful first sprint, focus of the sec- ond sprint was on the implementation of the business logic using BRMS. The second sprint raised some issues that were later resolved. The final sprint focused on the technical review and successful delivery.

2/4

Manage Self-Service BI for Useful Reporting I © Scalefree International GmbH 2023

Powered by