Download PDF
Qlik > Case Studies > rewards arvato services optimizes processes for customer relations program with QlikView
Qlik Logo

rewards arvato services optimizes processes for customer relations program with QlikView

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
The 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 The 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.
The 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.
Operational Impact
  • 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.
  • 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.
  • 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.
Quantitative Benefit
  • Savings of ~ two hours per week per user

Related Case Studies.

Contact us

Let's talk!

* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.