About the Client

A family-owned company specializing in the development, design, production and distribution of diaphragm pumps in the industry wanted to find a better BI tool stack since their current one was not able to rapidly deliver reports.

Problem Statement

The manufacturer was already using Data Vault but they discovered they had the wrong implementation which caused low performance overall. Their BI reports were not precise and not deployed quickly enough for the business users. Some problems observed were:

  • Data loads took too long
  • The wrong data modeling led to errors and low performance
  • Data was not updated 
  • Lack of security requirements compliance

The Challenge

  • Find the best tool stack setup for the entire Business Intelligence process
  • Calculate and compare the total cost of ownership (TCO) 
  • Overcome performance issues by using the correct insert-only approach
  • Ingest data from SAP with incremental loads four times a day
  • Implement independent securities, access management and automation concepts
  • Apply business logic through Business Vault to reduce future reengineering efforts

The Solution

  • Implemented Proof of Concept document using the designated tool stack
  • Model and orchestration of the data from the source to front end through DWH using DV 2.0 best practices
  • Provided row and column level authorization that complies to security requirements
  • Registered technical issues to the tool’s customer services using ticketing system
Finding the Best Tool Stack to Increase Report Performance For a Pump Manufacturer

Tangible Results for the Client

  1. Presentation of advantages and disadvantages of the designated tool stack and the different approaches available in this Proof of Concept to help the customer decide
  2. Improved measurement of performance and Total Cost of Ownership (TCO)
Finding the Best Tool Stack to Increase Report Performance For a Pump Manufacturer
Finding the Best Tool Stack to Increase Report Performance For a Pump Manufacturer
Finding the Best Tool Stack to Increase Report Performance For a Pump Manufacturer

Technologies used

  • Azure Data Cloud and Services
  • Vaultspeed
  • Power BI

Interested in learning more? Get the detailed case study!

Make An Appointment with Us

Profile Photo of Jürgen Dackweiler
JÜRGEN DACKWEILER

SALES MANAGER

Phone: +49 (511) 879 89342
Mobile: +49 (175) 811 0336