"The alcoholic Siberian Group" implemented technologies of the business analysis

On June 23, 2016 it became known of implementation of the platform of the reporting and analytics of Oracle BI in infrastructure of "Alcoholic Siberian Group"^[1].

Project Tasks

The main business processes of the company are automated using different configurations of 1C, products of own development and niche products in the field of mobile trade, management of secondary sales, market monitoring. For ensuring data analysis in 2013 the decision on creation of uniform storage and implementation of a BI system where all data necessary for work of service of marketing and sales will contain and to form analytical reports was made.

Office of "Alcoholic Siberian Group", (2013)

Project Progress

In 2014 the solution was implemented on the Oracle BI platform.

This solution closed all our requirements. We understood that in the long term it would be interesting to us to integrate into our system and other modules connected with management of budgeting, planning and so on. For further integration with new processes and scalings of the reporting we stopped on the Oracle BI system. Alexey Podteterin, head of department of organizational development of ASG

Key factor of success, according to Alexey Podteterin, not the choice of the platform, but structuring data streams, their correctness, reliability, settings of the reporting meeting needs of internal clients.

At this stage of the project at the company difficulties began.

We had no monitors of stability of system operation. Therefore our reaction to the arising incidents was overdue that, naturally caused discontent of users. There were situations when because of change of parameters of the initial systems risks of distortion of data in BI were high. Besides, the needs for a data set for the reporting as a rule exceeded rates of development for 40-50%. Alexey Podteterin

The company made the decision to change approach for high-quality ensuring support and development.

In an IT command of the company invited the specialist whose task included setup of a system and integration from the added platforms. At the same time made the decision on involvement of the external contractor and as such contractor in the middle of 2014 the project included DBI company.

By the end of 2014 implemented the round-the-clock support of an analytical system with automatic registration of the arising incidents in a system of accounting of requests and their operational correction. In the course of rendering services of support specialists of DBI company carried out individual preference of parameters of a system that helped to reduce the number of the arising incidents and to increase the general stability of service.

In 2015 works on development of a system began: the project team which part were the representative of business – the analyst defining the needs for formation of new reports, the employee of IT service of the customer, which problem – to decide how this task, and the contractor – the DBI company employing necessary number of specialists can be implemented is formed.

Project Results

The project solves several tasks:

• submission of reports by all regional employees is automated. Indicators of their activity form in a system in real time. Each employee has information on what he sells what plans at it what growth points, at work with what clients are available and on what drivers of growth it is necessary to concentrate.
• along with BI the schedule system and managements of marketing efforts is integrated. On setup more than ten indicators calculated on the basis of systems given sets were required less than a month. All data are provided to a uniform denominator, the uniform structure of indicators, communications and creation of analytical reports is created.

The most valuable resource is time. We, on the one hand, significantly reduced the number of failures and idle times of a system, and with another – undertook an essential part a routine of work on maintenance of services. Thus time of staff of ASG was released that allowed them to concentrate on development of a system and its closer integration in business of the company. In our opinion, it is a good example of symbiosis internal and the IT external resources. Konstantin Zhernevsky, head of department BI&DWH DBI companies