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.
Über den Kunden
Problemstellung
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
Die Herausforderung
- 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.
Die Lösung
- The selection process for a Data Warehouse-Automatisierung 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
Konkrete Ergebnisse für den Kunden
- Implemented several technical projects for research and development
- Customers can now receive timely information about the production status of their orders
- Connected all relevant source systems to have access to all data across the organization
- Implemented numerous optimizations in their business logic
Verwendete Technologien
- Wherescape 3D & Red
- PostgreSQL on a virtual machine
- Eckig
- Apache ActiveMQ
Kilian Grünhagen
Senior Consultant
Telefon: +49 511 87989342
Mobil: +49 175 2589365
Kostenlose Erstberatung