As part of the sustainability reporting, Henkel Conet commissioned to optimize the transparency and effectiveness of his reporting. For this purpose, Conet developed a robust data infrastructure that enables the company to record, process and report its sustainability data more efficiently.

Table of contents

Starting situation: Henkel strives for more transparency in sustainability reporting

With his brands, innovations and technologies, Henkel holds worldwide leading market positions in industrial and consumer business. With the ADHESIVE Technologies division, Henkel is global market leader in adhesives, sealants and functional coatings. With Consumer Brands, the company is particularly leading in many markets and categories worldwide.

Henkel strives to constantly expand the leading role in the field of sustainability and as Pioneer in the area of ​​sustainability to promote new solutions for sustainable development.

The company was faced with the challenge To optimize transparency and effectiveness of its sustainability reporting. As part of the program STAR have been identified several sub -areas that play an important role in the quality and traceability of the sustainability data.

The existing processes for data acquisition, processing, transformation and reporting showed gaps that made it difficult to precisely and timely insight into sustainability. In particular, the quality of the master data of packaging should be improved and the management and use of ESG data (ESG = Environmental, Social & Governance) should be optimized. To solve this challenge, Henkel AG & Co. KGAA commissioned the IT consulting company Conet.

Solution: Building a powerful data infrastructure for Henkel

Conet took over the task to develop a robust data infrastructurethat meets these requirements. The solution included the development of sophisticated data pipelines using Python and the Henkel framework as well as the use of DataBricks for large -scale data processing and analysis.

To improve data discovery and availability, a data catalogization and metadata management system was introduced. This enables a structured and searchable overview of all data sources and metadata, which the Increases transparency and findability of the relevant information. The use of advanced data modeling techniques and best practice seamlessly optimized ETL processes to ensure efficient data integration. In addition, a Delta Lake architecture was implemented, which A powerful and reliable data storage enables.

The monitoring and management of the cloud resources takes place via the Azure portal, while Azure Data Factory is responsible for the orchestration and automation of data workflows. To ensure data quality, processes for data quality testing and validation were introduced. Azure DevOps enables automatic processes for integrating and providing code. A version control system was also set up in order to to continuously update the report solutions and to quickly provide them.

Project management relied on the Agile Scrum method to effectively coordinate the various teams. In two -week sprints, tasks were prioritized and organized according to the business value and technical dependencies. A cross -functional team with expertise in the areas of data engineering and analyzes took care of the specific requirements of different areas such as sustainability and packaging. Regular updates held all participants about progress, challenges and upcoming milestones while a proactive risk management identified and reduced potential problems.

Use: more efficiency and transparency in Henkel's sustainability reporting

The implemented solution has significantly Improvement of transparency and efficiency of sustainability reporting contributed to Henkel. The new data pipelines and the Delta-Lake architecture enable precise and timely processing of the data, which leads to more precise and reliable insights into the sustainability performance.

The advanced data processing techniques and cloud technologies offer a solid basis that supports various reporting requirements and simplifies and improves compliance with regulations. The automated and optimized data workflows Reduce manual effort and susceptibility to errors in data processing significant.

“As a long -standing partner, Conet continued us with excellent specialist knowledge.” – Jürgen Katzemich, Corp. Director R&D / Innovation Adhesives

In total the solution promotes well -founded decision -making And drives the sustainability efforts of Henkel by enables more transparent and efficient handling of the ESG data.

Data Intelligence Mil Try

Data is the linchpin for the goals of your organization. Together with you, Conet develops how you can optimally use data on the way to comprehensive digitization. We are strategic and technically at your side and develop sustainable and innovative data solutions with you. Grab the opportunities of the digital future with us.

To our services

Was this article helpful for you? Or do you have any further questions about data intelligence? Write us a comment or please call us.


Photo: Jessica Backhaus


Jessica Backhaus is Communication Manager at Conet.

Photo: Niklas Ludwig


Niklas Ludwig has been Communication Manager at Conet since March 2020 and takes care of the internal and external communication of the Conet group of companies.


Source: https://www.conet.de/blog/success-story-henkel-fortschrittliche-datenloesungen-fuer-transparente-nachhaltigkeitsberichte/

Leave a Reply