DWH - Data Integratie & kwaliteit

The roadmap showed that the design of a new Data Platform was crucial to harmonize the data from existing ERPs & the future SAP S4 ERP as well as to be ready for everything related to production OT data & AI. This platform was set up by element61 in co-development on initial reporting domains such as sales, purchasing, inventory & finance.

Smart and IoT-enabled products like the Healthbox 3.0 generate a lot of (real-time) data. To turn this data into smart services for end-users, Renson needs a capable, scalable and flexible platform. To enable these capabilities Renson has been focusing on building a data platform that is equipped to handle the incoming data flow efficiently while exploiting the incoming data to generate additional value for the customers. This platform has been designed using a cloud-first approach on Azure.

With this project, Connect Group wanted to migrate their on-premises Data Warehouse on SQL Server to a Modern Data Platform in the cloud and to Power BI to improve their BI and analytics capabilities. The platform on Azure included services like a data lake, SQL Database, ADF – to rebuild the ETL with the element61 Acceleration Kit, and Power BI implemented on top. The data platform enabled finance, sales, production, procurement & stock reporting on top of SAP ECC.

The project consisted of the development of an end-to-end set-up for IoT and sensor data to allow reporting and predictive maintenance. Technology consisted of a full Microsoft Azure stack incl. Azure IoT hub, Databricks, Azure Data Explorer & Grafana.

De Watergroep wanted to have a report on the water coming in versus the water going out in their water production facilities. This would help them both in their day to day operations and in their annual reporting.

The Electro Optics & Materials (EOM) department of Umicore had a need to get reliable insights & metrics from their operational processes so they can monitor the materials from the first batch all the way to a finished wafer. Data was extracted from their SAP BW4HANA system and enriched with data coming from sharepoint, excels,... element61 proposed the data architecture and tooling, being Azure Data Factory, Azure Functions, Azure Data Lake, Azure SQL data warehouse, TimeXtender, API’s and front-end reporting in MS Power BI

The HR department of Umicore wanted a story-approached dashboard which shows various benchmarks against strategic goals (e.g. diversity within the manager pool) and also contains historical progress and with a deep-dive into regional benchmarks. The dashboard is accessible to a wide-range of internal employees which can only see relevant data based on their role/region/... The dashboard needed to be highly secured using Row-level-security, seen the confidentiality of the data. Data was extracted from SAP BW4HANA & other internal sources. element61 proposed the data architecture and tooling, being Azure Data Factory, Azure Functions, Azure Data Lake, Azure SQL data warehouse, TimeXtender, API’s and front-end reporting in MS Power BI.

The Procurement and Trade department (P&T) of Umicore was going to change their operational systems from SAP SRM towards SAP Ariba to smoothen their processes in Strategic Sourcing, Contract Management, Buying and Supplier Management.  This resulted in the need for a new/modern data platform and related reporting requirements.  element61 proposed the data architecture and tooling, being Azure Data Factory, Azure Functions, Azure Data Lake, Azure SQL data warehouse, TimeXtender, API’s and front-end reporting in MS Power BI.  Data Quality, user experience and ability for self-service reporting were key requirements.  The project consisted of two streams, Upstream to facilitate the Strategic Source-to-Contract (S2C) process and Downstream to allow Operational Purchase-to-Receipt (P2R).

IPM wanted to accelerate on Data & Reporting. In the continuously changing market of Media, data is key – i.e., both with 1st party data – core assets for B2B advertising as well as personalization in B2C – as well as a solid data platform to harmonize & transform data fit for use – incl. BI reporting. element61 assisted in clear strategic guidance & decisions taken, build-up of a solid integrated data platform and coaching & training of skills & concrete use-cases to build step-by-step. The use-cases were to allow B2B Advertising Revenue Reporting and Campaign Reporting.