Qlik Sense in GC Megapolis: complex analytics for distributor
ATK
Qlik Sense
Qlik Sense in GC Megapolis
.png)
Company:
Megapolis Group
Industry:
Distribution
Functional areas:
Sales analysis
Financial analysis
Product:
Qlik Sense
Qlik NPrinting
Warehouse analysis
Dashboard for top manager
Supply Chain Analysis
About the client company:
MEGAPOLIS Group is a group of companies that owns and manages assets in the distribution and logistics of FMCG products, such as: tobacco products (including cigarettes, cigars, cigarillos, tobacco), beer and soft drinks, groceries, lighters, power cells, contraceptives, energy, etc. MEGAPOLIS Group's delivery of goods to more than 160,000 retail outlets across Russia is carried out by 3,300 of its own vehicles.
Delivery of goods to more than 160,000 retail outlets across Russia is carried out by more than 3,300 MEGAPOLIS Group's own vehicles.
The company has more than 300 branches from Kaliningrad to Petropavlovsk-Kamchatsky, employing about 15,000 people.
Project Objective:
-
Consolidation and visualization of data from all information systems of the company on a single platform (with differentiation of access rights)
-
Minimization of “human factor” errors when preparing reports
-
Support for making economically sound decisions in a short period of time
-
Reduction of labor costs for processing and presentation of management and analytical reporting
-
Fast analytical solution performance, convenience and ease of use for the end user
Solution:
The most popular reports:
-
Analytics on sales plan fulfillment - by division, customer, channel, nomenclature type, salesperson, etc. (in the context of any level of product or channel hierarchy)
-
Sales dynamics report - effective visits per day per salesperson, number of unique SKUs in an order, average cost of an order and a box in an order, etc.
-
Warehouse analytics - stock turnover, warehouse utilization in units and money on any date, detailed by nomenclature type, manufacturer, brand, etc., cost of storage and transportation processing, warehouse losses, service level, etc.
-
Report on own vehicle fleet - plan-fact of mileage, cost of 1 km of mileage, dynamics of fleet utilization, cost of fleet ownership.
-
Analysis of working capital components - inventories, debt, accounts receivable, accounts payable, cash.
-
Profit and loss statement (P&L) - plan-fact of EBITDA and income and expenses, detailing individual items (insurance expenses, control of cash balances, analysis of reasons for deviations from the limit, etc.).
-
Debt analytics - accounts receivable for all customers with a breakdown by the “age” of the debt, convenient tracking of overdue debts by the amounts of interest, correlation of accounts payable with sales.
-
Travel expenses analytics - savings on hotel and air programs, dynamics of lost profit on air travel and accommodation, analysis of reasons for business trip cancellations, penalties, travel schedule violations.
-
Analysis of financial efficiency of conducted tenders and bidwaires - savings on commercial and non-commercial procurements FY, YTD.
-
EDMS analysis - number of EDMS requests per employee (by types of requests), speed and terms of electronic documents approval, number of blocked requests.
-
Personnel analysis - analysis of the organizational structure, staff turnover, availability/absence of vacant positions, FTE expenditures
Users of Qlik Sense analytics in GC Megapolis:
-
top management (general director, sales director, logistics and procurement director, finance director)
-
sales (~110 users - KAMs, sales managers of divisions and regions, sales planning managers, sales analysts, sales managers)
-
logistics and procurement (~100 users - warehouse logistics management, transportation logistics management, procurement managers, FEA)
-
Finance (~60 users - financial analysts, financial controllers, treasury, accounting, CBO, ACH)
-
Internal Control Department (5 users)
-
HR (~20 users)
Data Sources:
-
SAP BW - sales fact, logistics costs, service level, purchasing, residuals, inventory, mileage and fuel costs for own fleet;
-
SAP BPC - financial data;
-
SAP HR - headcount, staff structure, personnel costs
-
Oracle database - sales plan and forecast (own and wholesalers)
-
Nielsen report on market shares
-
Tables - fact, plan and forecast of operating expenses for sales, plan and forecast of logistics expenses, targets for expenses, accounting and rent of warehouse space, report on completed transportation by contractors
Results in numbers:
automated workstations
340
Results in numbers:
-
The volume of analyzed data - 900 million lines of sales entries and 2.7 billion lines of logistics entries
-
340 automated workstations
-
Reduction of analytics and IT costs (on average, up to 60% of working time was freed up for departmental employees who implemented Qlik Sense for analytics rather than data collection for reports).
-
Clean, reliable and interactive data
-
Appearance of a single source of analytical data for all employees of the company from different departments (from sales and finance to EDMS and HR)
-
Increased speed and validity of business decision making
-
“Self-service” as a new format of work with analytics for business users
Screenshots of the solution:
Testimonial:
"All our analytical ideas have not been realized yet, but the project can already be called large-scale - top managers and key specialists of sales, logistics, purchasing, finance and controlling departments (more than 300 people in total) use Qlik Sense in their daily work. At the next stage we plan to implement Qlik NPrinting reporting system, which will send reports from the systems on a schedule and in accordance with access rights. Then another 500 people across the company will have access to analytical information. In addition, many departments that were initially not included in the business analytics project became interested in the project and requested applications for their areas of responsibility. This was the case, for example, with the HR Department - the analytical application, including analysis of staff turnover by departments and divisions, personnel efficiency, formation and control of the motivation system, analysis and optimization of personnel costs, was included only in the second wave of BI-system functionality development."
Project Manager on the customer side, TC Megapolis JSC.
ANDREI ALEXANDROVICH PISAREV
Presentation
Implementation of a modern BI system, Andrey Pisarev, Megapolis Group of Companies
Press release
ATK Project on QlikView in ATK Project for MEGAPOLIS Group on QLIK SENSE in the Top Three Best IT Projects 2017
Other industry projects
.png)
QlikView at Urenholt
Qlik Sense in GC Megapolis
QlikView in Canon
.png)
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
