Scalefree – Case Studies – Corporate Group in the Heavy Plate Industry Transitioned to Data Vault 2.0

About the Client

An entire corporate group, composed of top companies operating in the field of heavy plate, needed to meet the needs of their customers with a focus on quality services and products.

Problem Statement

The corporate group aimed to link the entire operation of the organization across countries. Though with previous efforts it had not been possible to map the entire value chain in the existing technical data warehouse. 

The current technical data warehouse of the corporate group solution encountered the following problems:

  • The production processes of steel can not be recorded digitally effectively
  • Up-to-date access to subject-specific data is very complex and time-consuming
  • It was necessary to increase the sensor data quality within the production
  • Lack of transparency

The Challenge

The client wanted to find the best technology stack that would enable Data Vault 2.0 to:

  • Reduce inconsistencies and fragmentation of data
  • Compile subject-specific data from multiple data sources
  • Enable data science and simplify the use of mathematical models to improve production processes

For these reasons, the client wanted a consulting partner with the necessary technical knowledge to implement a Data Vault 2.0 approach.

The Solution

The client selected Scalefree as its consulting partner for:

  • The selection process for a data warehouse automation tool
  • Integration of different technologies and Big Data technologies
  • A fully automated, traceable and faster development of ETL routes
  • A Data Warehouse solution which provided reliable and reusable KPI values that increase the consistency of the final reports
  • Self-Service BI solutions
  • A solution which supports the historization of data

Tangible Results for the Client

The project delivered important assets to the client:

  1. Implemented several technical projects for research and development
  2. Customers can now receive timely information about the production status of their orders
  3. Connected all relevant source systems to have access to all data across the organization
  4. Implemented numerous optimizations in their business logic

Technologies used

  • Wherescape 3D & Red
  • PostgreSQL on a virtual machine
  • Angular
  • Apache ActiveMQ

Interested in learning more? Get the detailed case study!

Kilian Grünhagen Senior Consultant

Kilian Grünhagen
Senior Consultant

Phone: +49 511 87989342
Mobile: +49 175 2589365

Schedule Your
Free Initial Consultation