Qlik Case Studies rewards arvato services optimizes processes for customer relations program with QlikView

Edit This Case Study Record

	rewards arvato services optimizes processes for customer relations program with QlikView Qlik

rewards arvato services optimizes processes for customer relations program with QlikView

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Professional Service
Applicable Functions	Sales & Marketing Procurement
Use Cases	Supply Chain Visibility Inventory Management
Services	Data Science Services
Challenge	Rewards arvato services, a subsidiary of arvato AG, is a leading supplier worldwide of consultation, sourcing, and logistics for awards and customer loyalty programs. The company serves 30 national and international companies, supplying consumers in 62 countries with around 1,500 different articles. To offer optimum service and operate economically, arvato must continuously evaluate customer, product, and supplier data from some three million data records. Previously, standard reports were prepared within the retail system, with data from two systems and a SQL sales application exported, then imported into table calculation lists, and compiled. However, as the number of customers increased, it became increasingly difficult to compile the information. The old system would run into limits due to the high load from the various analytical requirements. Read More
About Customer	Rewards arvato services GmbH is a subsidiary of arvato AG, an international media and communications service provider of Bertelsmann AG. The company is a leading supplier worldwide of consultation, sourcing, and logistics for awards and customer loyalty programs. They offer a one-stop-shop solution, from the targeted compilation of rewards, to international purchasing and scheduling, to commissioning and shipping. The company serves 30 national and international companies, supplying consumers in 62 countries with around 1,500 different articles. This includes a wide range of items, from blood pressure measuring devices and MP3 players to luxury watches and one-man submarines. All the articles are recorded and administered in a retail module along with the supplier master data and customer orders. Read More
Solution	Arvato sought an alternative solution that could directly combine and evaluate data from different sources without having to first configure them separately in different programs. They wanted a solution that would not only be used by classic BI users such as management or Controlling but also by employees from various departments such as Sales and Purchasing. After considering various BI suppliers, arvato chose QlikView as its new analysis and reporting tool. A total of 25 reports were prepared, along with an affiliate, arvato systems \| Technologies, for Purchasing, Sales and Warehousing, Controlling, and management. The solution allowed for quick and easy analysis of data, improving the overall quality of the process. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Professional Service

Applicable Functions

Sales & Marketing

Procurement

Use Cases

Supply Chain Visibility

Inventory Management

Services

Data Science Services

Challenge

Rewards arvato services, a subsidiary of arvato AG, is a leading supplier worldwide of consultation, sourcing, and logistics for awards and customer loyalty programs. The company serves 30 national and international companies, supplying consumers in 62 countries with around 1,500 different articles. To offer optimum service and operate economically, arvato must continuously evaluate customer, product, and supplier data from some three million data records. Previously, standard reports were prepared within the retail system, with data from two systems and a SQL sales application exported, then imported into table calculation lists, and compiled. However, as the number of customers increased, it became increasingly difficult to compile the information. The old system would run into limits due to the high load from the various analytical requirements.

About Customer

Rewards arvato services GmbH is a subsidiary of arvato AG, an international media and communications service provider of Bertelsmann AG. The company is a leading supplier worldwide of consultation, sourcing, and logistics for awards and customer loyalty programs. They offer a one-stop-shop solution, from the targeted compilation of rewards, to international purchasing and scheduling, to commissioning and shipping. The company serves 30 national and international companies, supplying consumers in 62 countries with around 1,500 different articles. This includes a wide range of items, from blood pressure measuring devices and MP3 players to luxury watches and one-man submarines. All the articles are recorded and administered in a retail module along with the supplier master data and customer orders.

Solution

Arvato sought an alternative solution that could directly combine and evaluate data from different sources without having to first configure them separately in different programs. They wanted a solution that would not only be used by classic BI users such as management or Controlling but also by employees from various departments such as Sales and Purchasing. After considering various BI suppliers, arvato chose QlikView as its new analysis and reporting tool. A total of 25 reports were prepared, along with an affiliate, arvato systems | Technologies, for Purchasing, Sales and Warehousing, Controlling, and management. The solution allowed for quick and easy analysis of data, improving the overall quality of the process.

Impact #1	Each user saves up to two hours every week since the information does not have to be exported into several table calculation sheets and then compiled into a document.
Impact #2	The key account employees are now able to both actively and professionally advise their customers with current evaluations of the desirability of individual bonus offers.
Impact #3	Purchasing used QlikView to view data concerning price trends, deadline maintenance and duration of order processing for use in supplier discussions to markedly improve its negotiating position.

Impact #1

Each user saves up to two hours every week since the information does not have to be exported into several table calculation sheets and then compiled into a document.

Impact #2

The key account employees are now able to both actively and professionally advise their customers with current evaluations of the desirability of individual bonus offers.

Impact #3

Purchasing used QlikView to view data concerning price trends, deadline maintenance and duration of order processing for use in supplier discussions to markedly improve its negotiating position.

Benefit #1	Savings of ~ two hours per week per user

Benefit #1

Savings of ~ two hours per week per user

Download PDF Version

Overview

rewards arvato services optimizes processes for customer relations program with QlikView

Operational Impact

Quantitative Benefit