"EKKO Grew" automated the analytical reporting under merchandising

On August 18, 2015 it became known of a joint pilot project of ECCO company Russia (EKKO-ROS) and ATK consulting group on automation of the analytical reporting on the basis of QlikView.

Project Tasks

In EKKO-ROS a BI system as a part of which several OLAP cubes and the regular fixed reporting solving a part of the problems necessary for business management, to the managing director more than 200 shops is used.

Shop of EKKO-ROS company, 2014

Therefore the company selected the analytical platform corresponding to requirements of the company for flexible analytics.

"We thoroughly studied five main BI systems used in fashion-retail and paid special attention on QlikView. In QlikView we were attracted, first of all, by speed. And, as the speed of creation of new reports (fast data integration of complex structure, development of analytical applications), and the speed of obtaining information business (an opportunity to quickly receive the necessary ad-hoc to the analyst users independently). Therefore we asked ATK consulting group to implement a pilot project on our data to be convinced of QlikView systems capabilities", - Evgeny Shlyapin, the director of the department of IT of EKKO-ROS told.

Project Progress

For a pilot project selected a problem of control of existence of goods on shelves according to the ERP system of the company, Microsoft Dynamics AX. The choice of area of merchandising for a pilot project is caused by desire to check integration opportunities of QlikView for processing of data bulks and an opportunity to compare the available analytics to the pilot solution for assessment of potential of the new tool.

Within a week the project was completed. In EKKO-ROS tested the solution, were convinced of correctness of the choice of the analytical platform for analytics ad-hoc.

Project Results

Within a pilot project the analytical application allowing to make the analysis of out-of-stock, i.e. lack of goods in shop in different cuts including a brand, a collection, color, the dimensional hill, etc. is created. The developed application allows to manage effectively commodity filling of all shops ECCO and to minimize the half-received income from lack of some models or the sizes in a sales point.

"Main advantage of QlikView – fast obtaining result. After system implementation we will be able to save time on preparation of the reporting and information search, having given more efforts to increase in efficiency of distribution, marketing campaigns and other key processes of the company. On a pilot project of the colleague in a short time implemented the uncommon solution and showed the high level in creation of analytical applications. Together with the partner ATK consulting group we expect to unroll quickly a system in our company", - Evgeny Shlyapin, the director of the department of IT of EKKO-ROS said.