Jet Infosystems deploys a performance evaluation system for Danone-Unimilk


Danone-Unimilk Group of Companies and Jet Infosystems complete the deployment of a modern QlikView based system of analytical reporting for a dairy plant in Chekhov.

Danone has a corporate internal reporting standard for controlling the use of equipment. Its Russian plants used to compile their reports using Microsoft Excel. The process was fairly time-consuming, especially for production workers. The company needed a business intelligence system for automatic reporting that would include information on the effectiveness of measures to improve production.

The contract was awarded to Jet Infosystems, a company with ample expertise in analytical systems.

QlikView software based on associative data processing was chosen for the BI system.

Jet Infosystems experts started with reviewing Danone production processes and performance assessment methods. Recommendations on improving data quality were then prepared. The results of this review were taken into account when the reporting system was designed.

The analytical model and the reporting system were developed by means of iterations. The customer could use the system in pilot mode almost immediately and provide appropriate feedback, which vastly accelerated the project.

The reporting model is designed as follows. An MES (Manufacturing Execution System) collects information from production lines and copies it to an intermediate storage facility at regular (adjustable) intervals. All the necessary data are then loaded into QlikView and converted into reports.

Access to report compilation and viewing is currently available to several categories of staff, including senior management, mid-level management and production workers. Information is provided on high-level KPIs and can be broken down to individual production line events (output, scheduled and unscheduled downtime, emergencies). The system can generate reports on current productivity, hourly equipment performance, output and current productivity vs. time, overall performance.

The production analysis system is simple to use, maintain and adjust; graphs, tables and other features may be modified by the system administrator without any assistance from the developer.

“The project outcome is not some set of tables; rather, we now have a full-fledged instrument for flexible analysis of production indicators," says Sergey Tyuvetskiy, production performance manager at Danone-Unimilk. "Moreover, analytical reports facilitate and accelerate policy decision-making.”

"Instead of a standard set of reports with a fixed 'vantage point' we now have 'three-dimensional' information that can be 'rotated' and viewed from every angle in various degrees of detail,” says Vadim Bobrovskiy, Business Intelligence and Master Data manager at Danone-Unimilk. "Accordingly, we can assess production line performance as well as the reasons for any deviations from the standard.”

“Reviewing production to identify data sources and links between data is one of the most challenging stages of designing a reporting system. Every company is special, every production review is different and needs an individual approach," says Anna Kharitonova, head of the business analysis division at the Jet Infosystems’ Software Development Center. "In such projects, the customer must be completely open to communication. That is why I would like to thank the Danone-Unimilk staff for their pleasant and productive cooperation.”

Danone-Unimilk Group of Companies:

The Danone-Unimilk Group of Companies is the largest manufacturer of dairy products in Russia. Its philosophy focuses on health, innovation, care for customers and high product quality. The group currently consists of about 30 plants that use brand names such as Danone, Activia, Biobalance and others.

Danone-Unimilk is the Russian arm of Danone, an international giant that employs over 100,000 workers in 120 countries on five continents and owns 184 production facilities. Danone is a leading player in the production of healthy food such as cultured milk products (number 1 in the world), bottled water (number 2 in the world), baby food (number 2 in the world) and medical nutrition (number 1 in Europe).