Qlik Case Studies Implementing the Production Performance Analysis System in Group of Companies Danone-Unimilk
Edit This Case Study Record
Qlik Logo

Implementing the Production Performance Analysis System in Group of Companies Danone-Unimilk

Qlik
Analytics & Modeling - Real Time Analytics
Consumer Goods
Food & Beverage
Discrete Manufacturing
Quality Assurance
Manufacturing System Automation
Predictive Maintenance
Data Science Services
System Integration
Danone-Unimilk, a division of Danone Worldwide, was facing challenges in preparing reports on production efficiency. The company had developed an internal corporate standard of reports for controlling equipment use efficiency. However, the process of data input in MS Excel was time-consuming and the timeframe of reports preparation for production lines efficiency analysis was not satisfactory. The company needed a tool for preparing internal standard reports to the parent enterprise and for analyzing the information to uncover the efficiency of the measures for equipment performance improvement. The new system had to meet several requirements including compliance with the corporate standard of reports, no data contamination, possibility of data analysis with hourly refinement of production lines use efficiency, support of associative data model, automatic data updating on schedule, support of web-access and mobile devices, and 24/7 system availability.
Read More
Group of companies Danone-Unimilk is the largest manufacturer of dairy products in Russia. The company focuses on health and innovations, care of consumers and constant orientation to high quality of products. The Group comprises about 30 factories which manufacture the products under various brands. Danone-Unimilk belongs to Danone Worldwide, which operates in more than 120 countries. The company divisions employ more than 100,000 persons and are located in 120 countries on five continents. Danone owns 184 production centers and occupies leading positions in four areas of healthy foods production: fresh dairy products, water, infant food and medical nutrition.
Read More
The company decided to introduce a state-of-the-art BI system and selected Infosystems Jet as the contractor for the project. The project was implemented in several stages. The first stage involved collecting the requirements to reports and data representation. The second stage involved the development of the analytical model and implementation. The system was implemented iteratively, allowing the customer to start using the system practically at once and introduce recommendations on the analytical model improvement. The system works by collecting data on the production lines performance from MES, replicating the information in the intermediate storage with configurable frequency, and then moving the information from the storage into QlikView. The system allows access to reports generation and viewing for several categories of employees, including managers of production and other division managers and the company management.
Read More
The customer has received a state-of-the-art BI system which helps to duly estimate the factory production lines efficiency and promotes operative and effective business decision-making.
The system allows to supervise efficiency of the lines, trace operational shutdowns and the reasons for them.
All necessary data can be received via a browser from any PC or laptop, or a mobile device.
Download PDF Version
test test