Model Group

A single source of production truth for managing performance across five plants

Model Group replaced manual spreadsheets, standardized production metrics, accelerated reporting, and created a scalable foundation for data-driven management.

1 source of truth

5 production plants

6 language versions

Switzerland

Manufacturing

Corporate (400+ retail shops)

Voice of the customer

Tomáš Veselský

Process development manager

Use cases

Automated production and controlling reporting

Cross-plant performance management

Standardization of production metrics

Technologies used

Qlik Sense

Snowflake

Problem

The company worked with large volumes of production and financial data from several key systems, mainly SAP, Witron CPMS, LPMES, and ANeT. Each system covered a different part of operations, but the data was not unified into a single consistent view.

The company realized that without a modern data platform, it could not fully leverage the potential of its data or prepare for the future use of AI.

Production reporting had long been based on the so-called “Amberg spreadsheets,” which were largely prepared manually. This process was time-consuming, repetitive, and carried the risk of human error. At the same time, different interpretations of metrics emerged because calculations were not defined consistently across plants.

This made it difficult to create a unified view of group performance, slowed down management decision-making, and increased the risk of ambiguous conclusions. At the same time, there was a growing need to provide relevant data not only to central management, but also to local teams in production and operations.

Solution

We unified production and financial data from key systems into a single analytics environment and created a central source of truth for reporting across plants. As a result, the company gained standardized metrics, automated reporting, and faster access to data for performance management and everyday decision-making.

Before

Reporting based on manual exports and spreadsheets
Dependence on selected individuals for preparing analyses
Data split across multiple systems and local solutions
Slower response to production and financial changes

After

Unified view of key production and management metrics
Greater transparency across plants and teams
Centralized access to data across the group
Scalable foundation for further development of data analytics

Solution

Production data updated once a day
Standardization of key metrics across plants
Self-service analytics enabled for business users
Replacement of unstable Excel reports with a modern Qlik Sense application
Creation of a central source of truth for production and management reporting
Design of clear dashboards, also available directly on monitors by the machines
Consolidation of data from key internal systems into a unified analytics environment

The new MCZ Production Reporting application enabled us to replace long-used manual spreadsheets with an automated and reliable solution. This significantly strengthened the digitalization of our controlling processes and created a solid data foundation for the further development of analytics applications.

Tomáš Veselský

Process development manager

More case studies

Let’s talk about your data.

Whether you are working on planning, reporting, or AI, we will recommend the next step that makes sense in the context of your business.