Tander increased number of licenses of QlikView

Tasks and modules

• Development of the concept of system operation of the analysis of key indicators of activity of shop of retail network;
• Sale of the mechanism of automatic mailing of email of notifications;
• Visualization of KPI on mobile devices;
• Cartographic expansion (analytics of QlikView on Yandex.Maps, OpenStreetMap);
• Writing of technical documentation;
• User support;
• Training of employees of the client in application development at the Qlikview platform.

Project works

• A panel for the analysis of key indicators, the interface to start work with a system
• A panel of the analysis of the selected indicators of sales on the card
• A panel of contrastive analysis of two arbitrary accesses by any criteria
• Implementation of the Monitor of Department of Sales interface, the including analysis of sales (dynamics, LFL), margins, losses, the level of service, base of objects, competitors, personnel in cuts
• Implementation of the "Summary Report on Shop" interface, the including analysis of sales, margins, efficiency, dynamics of sales on the main groups of goods and key indicators, including in comparison with the competitor
• Setup of mechanisms of mailing of the reporting for e-mail: notifications about events on e-mail, a possibility of function call of sending e-mail to the address specified in the report with an automatic investment of a screenshot of the report
• Writing of cartographic extension on the Yandex card with the specified functional requirements

Data sources

• MS SQL Server

System

Industry solution of BusinessQlik for Retail (for retail) based on QlikView

Project Development

On August 12, 2015 the QLIK company and retail grocery chain "Magnit" signed the agreement on the basis of which Magnit considerably will increase the number of licenses of the QlikView "Magnet" platform^[1].

Project objective - to deepen use of a business intelligence, covering all directions of business and providing to employees effective tools for development of network.

Transport of network, 2014

"The project on implementation of QlikView in our company started in 2012. During this time we managed to achieve good results: we began with creation of an infopanela for heads of the block of sales, and now a BI system is used by almost all leadership team – from top managers to managers of separate departments, – Pombukhchan Khachatur Eduardovich, the chairman of the board of directors of retail network "Magnit" told. – We see, use of this platform is how effective and convenient – it led us to the decision on increase in number of licenses".

For August 12, 2015 top management of network uses summary infopanel. The operational directorate uses role panels for heads of all main levels in such directions as sales, personnel, transactions of shops, their range and economy. Besides, managers of this division using QlikView can analyze information on competitive environment and manage commodity development. In directorate on development on the QlikView platform management of plans of opening of objects, efficiency analysis of new objects and modeling of opening of outlets are implemented. The commercial directorate carries out the comprehensive analysis of categories, producers, and department of logistics – management of transactions RTs (command center by processes) and control of level of service of deliveries. QlikView and for work with personnel is used: using a product the assessment of effectiveness of employees, the atmosphere in collective and labor protection level is carried out.

"We selected Qlik by a number of parameters. The first is an associative model which allows to cut quickly non-working combinations of data, to execute fast intuitive data filtering. Besides we were attracted by rich visualization and flexibly configured interface – they allow to identify quickly deviations, to work on the preconfigured scenarios of the analysis, – Sergey Fedorchenko, the director of economic department of retail network "Magnit" reported. – High speed of system operation allows to work online and to carry out the analysis with a speed of a thought, close to speed. Having tested solutions of several producers, we were convinced that in a case with Qlik we really receive what to us is promised, and the platform allows us to create the working BI solutions in days and weeks instead of months. Last argument of steel for us cumulative price of the solution and cost of ownership. In our plans – to include in the circuit of decision support created on Qlik, all departments of the company".

"Experience of retail network "Magnit" is very interesting and indicative, – Alexey Artemenko, the area director of Qlik across Russia and the CIS emphasized. – The company shows that can achieve using QlikView, and developing the platform by own forces. We are glad that QlikView not only met expectations, but also exceeded them and also that the management of Magnit network considers our solution perspective and is not satisfied with what has already been achieved. We in turn work on improvement of the platform, we release the new solutions answering to the most modern IT trends. It allows us to hope that our effective cooperation with Magnit network will continue and in the future".

Notes