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

rewards arvato services optimizes processes for customer relations program with QlikView

Qlik Logo
Customer Company Size
Large Corporate
Region
  • Europe
Country
  • Germany
Product
  • QlikView
Tech Stack
  • SQL
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Productivity Improvements
  • Customer Satisfaction
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
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 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.
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.
  • Today, reasons for returns can also be precisely analyzed. With one click, you can see if consumers did not like bonuses by checking out the effect on the products ordered, or if merely the address information was incorrect.
Quantitative Benefit
  • Savings of ~ two hours per week per user

Case Study missing?

Start adding your own!

Register with your work email and create a new case study profile for your business.

Add New Record

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.