QlikView in GC “Magnat”: Increase in sales based on analytics
ATK
Qlik NPrinting
QlikView in GC “Magnat”
.png)
Company:
Magnat
Industry:
Distribution
Functional areas:
Sales analysis
Financial analysis
Product:
QlikView
About the client company:
The Magnat Group of Companies was founded in 1991 and is currently the official distributor of Procter&Gamble, Mars, Pepsi Wrigley and others. In addition to distribution of goods “Magnat” provides a wide range of logistics services. The Group has more than 20 representative offices in the Middle and Lower Volga region and in the Urals. The company employs over 2.5 thousand people and has a monthly turnover of over 1.5 billion rubles.
Project Objective:
-
Analyzing large amounts of data
-
Consolidation of heterogeneous data sources
-
Reduction of analytical system support costs
-
Creation of a single corporate service for analyzing information
-
Reducing the reporting load on accounting systems
-
Automation of key reports
-
Reduction of labor costs for information collection for employees of the commercial department
Solution:
Magnat has developed more than 15 analytical applications and QlikView reports, the data of which are used by more than 150 employees, including sales representatives. In addition, the system is actively used by 14 top managers of the company, as well as middle managers.
The QlikView project was recognized by Procter&Gamble, the main partner of GC Magnate, as one of the best analytical solutions among distributors in 2015.
As a result of the implementation of the QlikView analytical system, key users can promptly solve the tasks of:
-
Sales Department. Uses BI-system to track marketing campaigns and segmentation of the customer base based on history on work with counterparties.
-
Supply Chain Management. GC employees are now able to quickly (in a few clicks) obtain data on supply chain management, compare seasonality periods among themselves, and delve into the details of operations - down to the specific goods sold to a retail outlet.
-
IT Department. Increased the speed of development of new analytical reports and reduced labor costs for system revision and maintenance.
Data Sources:
-
Various versions of 1C - from 7.7 to 8.2
-
Structured Excel files
-
Mobile sales system.
Results in numbers:
automated workstations
80
users of analytical reports
150
Results in numbers:
Implementation of the QlikView analytical system in the Magnat Group of Companies has led to:
-
to increase the speed of analyzing sales and product balances. The time for generating typical reports of the sales department was reduced (no more than 10 minutes for 1 report).
-
5% increase in sales in the traditional trade channel compared to last year
-
15% increase in productivity of sales representatives compared to last year.
-
80 automated workstations and 150+ users of analytical reports
Testimonial:
"Analysis of the work in the last 2 months showed a drop in one of the product categories in a particular branch, as a result of which we launched a local promotion and exceeded the sales plan by 2%, while initially forecasted lagging behind the plan by 20%. This is a good example of the direct impact of the analytics system on sales” ‘There are so many plans and ideas thanks to QlikView that there is only one question: in what order to realize all the plans"
Customer project manager (business analyst), Magnat Group of Companies
IVAN VLADIMIROVICH SHARMIN
Other industry projects
.png)
QlikView at Urenholt
.png)
Qlik Sense in GC Megapolis
QlikView in Canon
QlikView in GC “Magnat”
+7 (495) 134-32-92
consult@atkcg.ru
Russia, 121467, Moscow,
Istrinskaya str. 4, Office 1
Company News
subscribe to our newsletter
