DAW Color Mesh App:Futureproofing the Data Update Process

DAW has a goal of moving away from redundant data processing, the associated non-agile spreadsheets, and transforming to a Data Mesh organization. In the first project with One Data, the creation of (reusable) data products for the “DAW Color Mesh App”, is a first step towards the company’s decentralized data future. Among other things, the role of Product Managers is being transformed into “Product Data Owners”. DAW is thus pursuing an innovative approach to data management and at the same time remaining future proof.

Estimated reading time: 4 minutes

DAW SE is a leading German manufacturer of paints and varnishes with international operations. With different brands with various suppliers and business partners, DAW has a highly complex supply and value chain.


DAW’s important aim is to continuously improve customer satisfaction and experience—not only with new and sustainable product innovations, but also through optimizing behind-the-scenes processes, webshops, design software, digitalization, and AI. The efficient use of data is a focus area for innovation.

The company has chosen One Data as its technical partner for one of its latest data management projects. Using the software’s ability to create reusable data products, DAW wanted to automate the process of updating its central data store. The goal was to make the process more efficient, scalable, and reliable.

To do this, the color data for all items must be accurate, reliable, and continuously updated, and any changes must be distributed to all markets, web shops, etc. Until recently, an Excel and SQL database-based solution was used to supply key customer tools in the German market with the necessary product information, resulting in a highly manual, time-consuming process. Due to the DAW’s growth and new evolving requirements the existing pipeline now needed to be replaced with extensions to web stores and product configurators.


The goal of deploying One Data was to eliminate the creation of single-use data products and transform them into reusable data products that are automated, more efficient, robust, and quality-assured while reducing manual effort. This provides greater efficiency, consistency, and agility in data-driven decision making, fosters cross-functional collaboration, and supports cost-effective innovation.

First, all relevant data and source systems were integrated into One Data and the data pipeline that previously existed was migrated to One Data. As a result, the process of delivering data to the central data store is now fully automated—including automatic preparation and quality checks—ensuring high quality of the final data products.

The next step was to create a visual data map that allows Product Data Owner and specialists to easily identify data quality issues. The map includes detailed information on all items and their ingredients, as well as quality measures. A quality summary makes data quality measurable and transparent in DAW’s product data update process.

Ultimately, the two user groups that use these differently: Product Data Owners look at their respective products, with data from many assets attached to each product. This data is therefore brought together in the DAW Color Mesh App to provide a horizontal view of the assets. The specialist departments who provide the data look at individual data tables. The data map gives them a vertical perspective on that information.

If a Product Data Owner finds an error in the data for his articles, he can report it to the color department. Quality issues that come from source systems, can easily be identified and then reliably solved in the source system where they originated. In this way, the Quality App enables data owners and specialist departments to improve the quality of product data independently.

This ensures that the central data store is always populated with high-quality, up-to-date data for all existing and new items, while reducing manual effort. The end result is faster and better product data updates and a seamless sales process for retailers.


Data products help DAW to automatically maintain data quality and input data from different source systems. The targeted data products created in One Data contain automatically cleaned and up-to-date item data required for central points, such as web shops and tinting machines.

Another goal is to gradually transfer data ownership and quality responsibility to the business. The data processing structure of the previous solution was successfully captured and mapped, and the quality of the source data was visualized.

As a result, the process of updating the database for all items has become much more robust, with a significant reduction in manual work. This ensures that the points of sale are supplied with the most up-to-date and reliable data, which improves product supply, ordering, and ultimately customer satisfaction, enabling new sales potential to be exploited.

With the Color Mesh App, DAW will be able to shorten their web shop update cycles, improve data quality, and gain visibility into internal processes and data sources. In addition, the company will improve customer satisfaction and increase its competitiveness—ensuring that you get a bucket of Alpina reliably and in the exact color you want in no time.

In the future, DAW plans to build and reuse more of these innovative data products to gradually become a Data Mesh organization—and thus be at the forefront of innovation in data handling.

“Until now, we have always built single-use data products with high manual effort—in a fast-paced world with ever-changing market conditions and customer needs, we need to build reusable data products which can adapt quickly in order to ensure our competitive advantage.”

Axel Voelcker
Head of Digital Customer Experience






DAW Color Mesh App


Data quality transparency
Business ownership of data
Automate data processing logic
Minimize business risk
Process and data product reusability
Increase customer satisfaction

Download PDF

Frequently asked questions

One Data transforms businesses into data-led entities by providing a comprehensive Data Product Builder. It enables the ingestion of data from diverse systems and its exploration through an interactive map. This approach empowers business users to request and utilize data products effectively and foster a data-driven culture across the enterprise.

Absolutely. One Data bridges the gap between data experts and non-technical business users. Its intuitive interface and Data Product Marketplace allow users of all skill levels to create, manage, and share data products efficiently. This is thus democratizing data access and collaboration within the organization.

Key benefits include significant time savings in developing and managing data pipelines, and the ability to quickly deploy quality-assured data products at scale. The platform streamlines processes through repeatable workflows and fosters enhanced collaboration between business, data, and IT teams. This leads to continuous innovation, operational efficiency, and reduced data storage costs.

One Data integrates AI into every stage of data product development. This reduces manual work and ensures the quality and integrity of data products. One Data helps you guarantee that the data is reliable and aligns with business contexts, enhancing decision-making accuracy and strategic insights.

One Data provides comprehensive support for the entire data product lifecycle. It includes the initial ingestion of data, facilitating user requests for data products, as well as data product building and sharing. This ensures that data products are efficiently developed and aligned with business needs and ready for scalable deployment.

Related content

Business Value of Data Products

Data products tailored to your goals help your business navigate challenges, drive insights, and unlock strategic value.

Read More

Reusable Data Products

Watch the video and get input from thought leader Mike Ferguson (Founder of Intelligent Business Strategies & Big Data LDN) on the collaborative development of reusable data products.

Read More

Predictive Delivery Tracking

Enhancing customer experience and upselling through real-time delivery tracking.

Read More