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.
About the Client
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
Tangible Results for the Client
- 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
- Improved measurement of performance and Total Cost of Ownership (TCO)
Technologies used
- Azure Data Cloud and Services
- Vaultspeed
- Power BI
