BIConsult implemented QlikView in Gold Luga company

December 16, 2014. The Qlik company (NASDAQ:QLIK) and BIConsult company announced completion of implementation of industry analytical solution on the QlikView platform in Gold Luga company.

Functionality of the solution

Industry solution of BusinessQlik for Manufactoring (for food production) based on QlikView:

• Control panel with display of key indicators of activity;
• The sales forecast on the set algorithms: accomplishment of the plan for week, month;
• Dynamics of a gain of receivers of products
• Identification of potentialities of additional deliveries to receivers from similar areas / groups
• Analysis of returns/claims (facts, reasons, deviations)
• DZ (receivables), PDZ (overdue receivables), deviation from limits
• Remaining balance of goods items for date and in dynamics
• Existence of goods in a warehouse (Out-of-Stock)
• Analysis of "Chto-Esli"
• The analysis of own prices by branches, including in dynamics, Comparison with the prices of competitors
• The analysis of key indicators in different cuts
• The comparative (LFL) analysis in time
• Visualization on the map
• Designer of reports
• Analysis of orders (Funnel, conversion, shares)

Choosing a Solution

A choice was made for benefit of industry solution for production the kompaniyn to the QlikView platform developed by the St. Petersburg company BI Consult, one of the oldest Russian partners of Qlik company.

Project Progress

During the project it was succeeded to make data purification in the used accounting systems of Gold Luga company, as a result chegodanny became completely reliable and the uniform "source of the truth" for all divisions of the company was created.

Project Results

As a result bylpoluchen the tool for the instant analysis of reasons for rejection from the set standards. Its use together with a possibility of the analysis of key performance indicators in long-term dynamics led to growth of efficiency of business processes. Because the company management received the broad picture on returns of products and sales, JSC Zolotye Luga was succeeded to achieve optimization of work of production and reduction of warehouse stocks.

Development Plans

In plans of the company – further development of a BI system. Seychaspri of the help of specialists of BI Consultosushchestvlyaetsya implementing solution based on QlikView for the analysis of logistics.

"Our industry solution ideally corresponds to requirements of such large production company as JSC Zolotye Luga, – Sergey Gromov, the CEO of BI Consult comments. – With its help it is possible to balance production processes, to adjust control of losses, to create the system of production focused on demand and to make the enterprise transparent. Developing this solution on the QlikView platform, we tried to consider as much as possible all features of business of production companies, and experience shows that its implementation leads to significant growth of efficiency of all business processes of the enterprises".

"Business intelligence system implementation on the QlikView platform having not only excellent functionality, but also the thought-over evident interface, allowed to increase significantly the speed of acceptance of management decisions in the company at all levels of the management, – Tyulnev's rezyumiruyetanna, the head of department organizational modelirovaniyakompaniya Gold of Luga. – Operational data availability and a possibility of use of the designer for creation of the user report versions – unlike technology of cubes – does QlikView use visual to the most effective".

Representatives of the company integrator reported TAdviser.