Download PDF
Qlik > Case Studies > Coparts keeps a tight grip on all of its parts with QlikView
Qlik Logo

Coparts keeps a tight grip on all of its parts with QlikView

Technology Category
  • Analytics & Modeling - Real Time Analytics
Applicable Industries
  • Automotive
  • Retail
Applicable Functions
  • Sales & Marketing
  • Business Operation
Use Cases
  • Supply Chain Visibility
  • Inventory Management
Services
  • Data Science Services
The Challenge
COPARTS Autoteile GmbH, a distributor of automotive parts and business services catering to repair shops in Germany and Europe, was faced with the challenge of managing its complex network between members, partners, and industry. The company needed a detailed overview of all sales, value-added services, and expenditures to provide members greater transparency of COPARTS services and leverage in negotiations with suppliers and service partners. The aim was to combine sales figures in different formats from industry, partners, and members, and compare them with the information on the different value-added services, their ranking, and expenditures of COPARTS in time-line comparisons. Previously, these figures were processed in Excel, which was time-consuming.
About The Customer
COPARTS Autoteile GmbH was founded in 1981 as a merger of different plant representatives in the automobile parts retail business. The primary goal was to exploit synergies in administrative tasks and jointly import automobile parts for Japanese vehicles in the German market. Given increasing customer demands and economic changes in the 90s, COPARTS was faced with new challenges. The cooperative, which previously had operated on an honorary basis, started increasing its personnel to provide business and workshop customers with the necessary tools to meet increased demands. As of today, more than 1,600 partners have been supplied with the corresponding tools. In addition to offering a catalog and technical data, COPARTS offers repair shop supplies and related marketing tools ranging from outdoor advertising to events, internet portals, mailing campaigns and collaboration with leading networks such as ADAC, as well as COPARTS own line of services. In addition, COPARTS offers administrative relief, such as centralized invoicing for COPARTS members.
The Solution
COPARTS deployed QlikView to a handful of employees in a short period of time. By analyzing and projecting sales, inventory and rewards and portraying data from the past in QlikView, COPARTS has a continuous overview of the complex network between members, partners and the industry. With QlikView Server, COPARTS is easily able to aggregate data to have a single common dashboard. The effects of changes can be easily simulated within the three most important bonus columns using “slide controls”. Surpluses can be broken down according to individual brands with the click of a mouse. With the previous Excel solution, this would only have been possible with a great deal of time and effort. Today, COPARTS can quickly see when expenditures or individual value-added services go off track and appropriately adjust them.
Operational Impact
  • Achieved greater transparency of services for members
  • Enabled analyses as basis for negotiations with suppliers
  • Allowed simulation of the effects of changes to bonuses/rebates and enabled quicker responses

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.