Qlik Case Studies Coparts keeps a tight grip on all of its parts with QlikView
Edit This Case Study Record
Qlik Logo

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

Qlik
Analytics & Modeling - Real Time Analytics
Automotive
Retail
Sales & Marketing
Business Operation
Supply Chain Visibility
Inventory Management
Data Science Services
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.
Read More
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.
Read More
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.
Read More
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
Download PDF Version
test test