Finding the best Tool Stack to increase report performance

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

Powered by