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

Edit This Case Study Record

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

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

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics Functional Applications - Manufacturing Execution Systems (MES)
Applicable Industries	Consumer Goods Food & Beverage
Applicable Functions	Discrete Manufacturing Quality Assurance
Use Cases	Manufacturing System Automation Predictive Maintenance
Services	Data Science Services System Integration
Challenge	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
About Customer	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
Solution	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 Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Functional Applications - Manufacturing Execution Systems (MES)

Applicable Industries

Consumer Goods

Food & Beverage

Applicable Functions

Discrete Manufacturing

Quality Assurance

Use Cases

Manufacturing System Automation

Predictive Maintenance

Services

Data Science Services

System Integration

Challenge

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.

About Customer

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.

Solution

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.

Impact #1	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.
Impact #2	The system allows to supervise efficiency of the lines, trace operational shutdowns and the reasons for them.
Impact #3	All necessary data can be received via a browser from any PC or laptop, or a mobile device.

Impact #1

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.

Impact #2

The system allows to supervise efficiency of the lines, trace operational shutdowns and the reasons for them.

Impact #3

All necessary data can be received via a browser from any PC or laptop, or a mobile device.

Download PDF Version

Overview

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

Operational Impact