Finding the best Tool Stack to increase report performance

BI,Case Study

FINDING THE BEST TOOL STACK TO INCREASE REPORT PERFORMANCE OF PUMP MANUFACTURER

INTRODUCTION A provider of cable network services in Germany wanted to understand why their Data Warehouse development had constant delays and results were not being delivered in the requested time frame which necessitated guidance on fixing those issues. CASE DESCRIPTION

The manufacturer was already using Data Vault but they discovered they had the wrong imple- mentation which caused low performance over- all. Their BI reports lacked precision and were not created quick enough for the business users. Some problems observed were slow data load- ing, the presence of errors, low performance led by wrong data modeling, out-of-date data on the front end and lastly the lack of security and pri- vacy requirements compliance. The client sought Scalefree’s services to help them find the best tool stack to implement throughout the Business Intelligence process,

calculate and compare the total cost of owner- ship (TCO), overcome performance issues by using the correct insert-only approach, achieve data ingestion with automated and scheduled incremental loads four times a day, implement independent securities, access management and automation concepts and apply business logic through Business Vault to reduce future reengineering efforts. The Figure 1 show below demonstrates the road taken from problem to solution in this Proof of Concept:

Figure 1: Problem to solution

Finding the best Tool Stack to increase report performance of Pump Manufacturer © Scalefree International GmbH 2023

2/4

By the end of the evaluation, Scalefree was able to implement the Proof of Concept document using the designated tool stack. Additionally, Scalefree was able to assist in the modeling and elaboration of the data orchestration from the source to front end through the Data Ware- house using Data Vault 2.0 best practices and standards while providing an authorization concept as a means to meet all of the security and data privacy requirements.

Figure 2 illustrates the problem of authorization and the solution implemented. Users were hav- ing unauthorized access to measures and rows in the two tables of the Sales Org and Product Center. The concept puts in place three com- bined authorization methods to overcome this:

● Authorization layer as a procedure ● Row-level and column-level authorization.

Figure 2: Authorization concept

TANGIBLE RESULTS FOR THE CLIENT The results observed were the compilation of advantages and disadvantages of the designated tool stack and the different approaches available in the Proof of Concept which enabled the client to make a decision regarding the Tool Stack and the implementation approach, combined with the estimation of performance improvement and Total Cost of Ownership (TCO).

Finding the best Tool Stack to increase report performance of Pump Manufacturer © 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

Page 1 Page 2 Page 3 Page 4

www.scalefree.com

Powered by