QlikView at Urenholt: effective sales and supply management
ATK
Qlik Sense
QlikView at Urenholt
.png)
Company:
Urenholt
Industry:
Distribution
Functional areas:
Sales analysis
Financial analysis
Product:
QlikView
Marketing Analysis
Supply chain analysis
About the client company:
Uhrenholt A/S is a leading international food company with a turnover of 550 million euros. It supplies dairy and meat products, frozen vegetables and seafood to production facilities, retail chains, restaurants, hotels and catering companies.
Uhrenholt Ltd. is a part of Uhrenholt A/S holding. Today it is one of the largest distributors of food products on the Russian market.
Project Objective:
-
Increased speed of analytical reports creation
-
Optimization of ERP system load
-
Improved quality of sales forecasting
-
Increased efficiency of business operations
-
Increased efficiency of logistics processes
Solution:
The ATK Distribution Analytics solution is used at Urenholt for the following tasks:
-
Analyzing procurement and logistics
-
Analyzing sales, key account management and customer service
-
Analysis of marketing campaigns
-
Financial analysis
-
Analyzing the efficiency of IT cost allocation
The most requested reports :
-
Analysis of goods movement and stock index (stock in days of sales) in the context of 3'000+ product lines
-
KPI on delivery service performance (percentage of successful deliveries (without returning goods to the warehouse), planned and actual loading, unloading and order picking rates)
-
Customer ranking by sales volume and margin (including storage and transportation costs.
-
Analytical application for loyalty support (prompt identification of decrease or increase in purchases for each customer by product group to prevent customer churn).
QlikView system helps to increase the efficiency of commercial and logistic activities of Urenholt LLC, as well as to manage financial flows.
Data Sources:
-
Microsoft Dynamics AX ERP system
-
Corporate portal Microsoft SharePoint
-
Excel files.
Results in numbers:
and more users of analytical reports
75
Results in numbers:
-
More than 75 users of QlikView analytical reports in the departments of purchasing, sales, warehouse and transportation logistics, finance and controlling.
-
The Purchasing Department analyzes data and plans product balances in the warehouse in the context of more than 3,000 product items in QlikView.
-
As a result of the system implementation, the time of analytical reporting preparation has significantly reduced - if earlier the time of report preparation was measured in days, now it is hours or even minutes, which reduces costs and increases the efficiency of analytics in the company
-
The flexibility of the analytical solution allows each report to be customized, so dozens of employees use the platform every day.
Testimonial:
“We have already made the QlikView platform the analytical center of the company, where almost every employee can quickly get any necessary data to make not just a quick decision on a task, but also a quality one, which is most valuable to us”
Head of Information Technology Department, Urenholt LLC.
ALEXEI DUDNIKOV
Other industry projects
QlikView at Urenholt
.png)
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
