Interactive analytics for Swiss Krono: production control not in Excel, but in real time

Tags:

Business Intelligence (BI)Data Engineering

About the project

The centralized model brought all of the company's data together into a single structure.

Swiss Krono is not just a brand, but one of the world leaders in the production of wood-based building materials. The company owns factories in Ukraine and more than 10 countries around the world. They provide a full cycle of production of laminate, chipboard, and OSB boards. Swiss Krono successfully combines technology with natural raw materials and shapes the future of construction and design.

The client's problem

The company used Excel-based reports, but this approach made it difficult to get a clear and timely view of production processes.
Manual data updates were time-consuming, and KPI analysis required constant clarifications and cross-checks.

Core issues:

no unified source of truth for data;
difficulty in tracking the actual status of production processes;
delays in creating and verifying reports.

Swiss Krono needed a modern solution to automate data processing, simplify analysis, and give management real-time visibility into production performance.

Case information

The model built in Power BI has increased the efficiency of management decisions.

The adaptive dashboard shows the actual state of production, identifies deviations, and helps you take action before problems arise.
Our approach:
IWIS specialists began working on the project by defining key production metrics and KPIs. These most accurately reflect production volumes, defect rates, equipment productivity, etc. Next, we structured the indicators for reporting, agreed on the logic of calculations, the level of detail, and the frequency of data updates. After agreeing on the model, we created a solution in Power BI based on it. It is capable of transforming complex tables into visual, understandable analytics for quick management decisions.

Work results:

Our collaboration with the customer transformed manual reporting into convenient digital management. Key implementation steps:
introduced an adaptive dashboard with filters by date, line, workshop, and shift;
- built a centralized model in Power BI with automatic data updates and dynamic calculations;
- replaced Excel reporting with interactive analytics, which reduced the time needed to prepare reports;
the color indicators of deviations that we have added allow you to instantly identify problems in production processes;
- improved the efficiency of management decisions: managers monitor KPIs in real time.
Thanks to these solutions, data works faster and management is based on accurate indicators rather than guesswork.