Data Integration Platform

SPIE is introducing a cross‑functional, scalable platform that automatically integrates and intelligently processes data from a wide range of sources. This increases transparency across our business activities, optimizes processes, and both enhances and creates new customer services.

In the digital era, the efficient use of corporate data is crucial to business success. SPIE recognized early on that a centralized data platform is key to meeting this challenge. The Data Integration Platform enables the collection, storage, and processing of data from diverse source systems.

The chosen technology allows for the integration of both structured data (e.g., traditional tabular formats) and unstructured data (e.g., IoT data, image, and video data). The platform’s flexible architecture also supports the embedding of data‑analytics components, delivering actionable insights into our business processes and guiding decision‑making. As SPIE’s central IT, our goal is to establish a strong foundation under unified governance—one that continually evolves through the iterative implementation of individual use cases within an agile development framework.

The first implemented pilot use case focuses on supporting procurement controlling at our headquarters.
The aim was to replace a previously PowerPoint‑based report and substitute the underlying Excel‑based calculations with an automated ETL process (extract, transform, load) and Microsoft Power BI. Previously, creating a report required manually combining numerous files from over 20 ERP systems—one single calculation could take up to 40 minutes on a high‑performance PC.

Excel’s limits had already been exceeded, and files had to be manually split to be processed at all. The new solution provides a central upload point, with data structured to be read into an SQL database for metric calculations. These calculations now take less than a minute.
The results can be visualized in Power BI at any time and shared effortlessly with different target audiences—significantly improving reporting speed, reliability, and accessibility.

Duration:
23.05.2024 - 23.08.2024

Contact:
Jan Mohrmann
jan.mohrmann@spie.com

Artikel teilen

Benefits

Reduction of Manual Effort
Reduced Calculation Time
Automated Plausibility Checks
Error Minimization

USE CASES
Industrial Data Management Platform
The platform optimizes maintenance through real-time monitoring, anomaly detection, and predictive servicing. It reduces downtime, lowers costs, and enhances overall efficiency.
Docudesign_Freisteller
Digital Signatures with DocuSign
Improving Business Processes with DocuSign: The digital signature solution saves time, reduces errors, and enhances security by complying with the eIDAS regulation—ideal for fast and efficient collaboration from anywhere.
Digitalization of Shipping Processes for Mann+Hummel
Optimized Shipping Processes through Digitalization: In collaboration with Mann+Hummel, we reduced search times by 20% and minimized errors using ultra-wideband tracking and barcode technology.