Lebedyansky, joint stock company (IBM Cognos Business Intelligence)

System implementation of Cognos 8 BI in JSC Lebedyansky company

In recent years one of the most quickly growing industries of the Russian economy is production of food. More and more western operators come to the domestic market, forcing domestic enterprises to find different methods of deduction of the positions in the market and a business development path. The becoming tougher competition forces to increase efficiency of activity of the enterprise at all levels. In such conditions the special importance is purchased by the tools allowing to perform effective strategic planning and the multidimensional analysis of all indicators of financial and economic activity of the enterprise.

The companies which already successfully passed a stage of implementation of the accounting system come to understanding that the accumulated sales informations, to customer relations, purchases, logistics, production, personnel and financial information should be used effectively for acceptance of high-quality and timely management decisions.

The management of JSC Lebedyansky, the leader of the Russian market of juice and one of the producers of baby food, largest in the country, realizing need to improve process of strategic management, made the decision on creation of the data warehouse and not its base - a corporate portal of the analytical reporting on the Cognos platform – Cognos 8 Business Intelligence (BI).

Project Task

JSC Lebedyansky is the large, fast-growing enterprise with the distributed structure: since 2003 the annual gain of revenue of the company averages about 40%. For maintenance of positive dynamics of business of the company top managers and analysts needed to have at the order powerful tools of the analysis and reporting, first of all, for analytics of activity of sales department. These tools had to minimize routine actions for preparation of reports and release resources for deep, multidimensional data analysis. Prior to the beginning of the project in the company reports prepared in tables of Excel, "were cut" on areas of responsibility and sent by e-mail. Thus, the single platform for support of acceptance of the justified management decisions, first of all, in the field of sales and logistics was required for Lebedyansky company.

Microtest was selected by Lebedyansky holding as software provider and consulting implementation services of Cognos 8 BI, considering not only presence of industry expertize at consultants, but also thanks to last successful experience of cooperation: earlier specialists of Microtest company participated in implementing solutions based on Cognos PowerPlay and the portal of the reporting based on Cognos Upfront for analysis department of the central office JSC Lebedyansky.

The management of JSC Lebedyansky set the following tasks for group of implementation:

• The analysis of the existing reporting and optimization of the scheme of its formation;
• Creation of a system of the connected reports, first of all, for the analysis of sales and logistics;
• Ensuring access of users to the system of the analytical reporting via the Web portal;
• Differentiation of access rights of users to data in reports using uniform authentication;
• Development of reporting system (addition with its sets of reports on purchases, raw material stocks and materials, to production indicators, financial statements).

Solution

For the solution of all listed tasks was the Cognos 8 Business Intelligence (BI) system as Cognos 8 BI is the only solution which provides complete functionality of BI in one product with the uniform checked architecture is selected. It gives opportunities of continuous creation of reports, the analysis, scoring, creation of dashboards and event management.

The project on implementation of Cognos 8 BI in JSC Lebedyansky included installation of such functional units as the analysis of sales and a commodity remaining balance that allowed company management to obtain operational consistent information about a merchandising status at the enterprise. The data warehouse on the basis of Oracle DBMS concentrating information from the accounting system of Microsoft Navision was developed by the staff of service IT JSC Lebedyansky prior to the beginning of the project. Specialists Microtest advised a project team of the company on creation of the portal on the basis of Cognos 8 BI, optimization of work of reports, search and elimination of errors.

The achieved result

As a result of the implementing solution Cognos 8 BI in JSC Lebedyansky all chain of preparation of the operational and analytical reporting under sales and a commodity remaining balance for top management at considerable reduction of labor and temporary resources on accomplishment of these transactions was automated. Different employee groups (sales representatives, managers, heads) had an opportunity to use the different preconfigured reports that significantly reduced time for consolidation of data from different business divisions of the company.

Using the received solution as base, JSC Lebedyansky carries out by forces of own specialists development of a system of the analytical reporting to all Supply Chain areas.

According to distribution of role functions, user groups got access to operational and analytical information about activity of the enterprise. Thus, thanks to the solution Cognos 8 BI the necessary transparency of business of JSC Lebedyansky will be provided.