Download PDF
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
Related Case Studies.
Case Study
Integral Plant Maintenance
Mercedes-Benz and his partner GAZ chose Siemens to be its maintenance partner at a new engine plant in Yaroslavl, Russia. The new plant offers a capacity to manufacture diesel engines for the Russian market, for locally produced Sprinter Classic. In addition to engines for the local market, the Yaroslavl plant will also produce spare parts. Mercedes-Benz Russia and his partner needed a service partner in order to ensure the operation of these lines in a maintenance partnership arrangement. The challenges included coordinating the entire maintenance management operation, in particular inspections, corrective and predictive maintenance activities, and the optimizing spare parts management. Siemens developed a customized maintenance solution that includes all electronic and mechanical maintenance activities (Integral Plant Maintenance).
Case Study
Improving Production Line Efficiency with Ethernet Micro RTU Controller
Moxa was asked to provide a connectivity solution for one of the world's leading cosmetics companies. This multinational corporation, with retail presence in 130 countries, 23 global braches, and over 66,000 employees, sought to improve the efficiency of their production process by migrating from manual monitoring to an automatic productivity monitoring system. The production line was being monitored by ABB Real-TPI, a factory information system that offers data collection and analysis to improve plant efficiency. Due to software limitations, the customer needed an OPC server and a corresponding I/O solution to collect data from additional sensor devices for the Real-TPI system. The goal is to enable the factory information system to more thoroughly collect data from every corner of the production line. This will improve its ability to measure Overall Equipment Effectiveness (OEE) and translate into increased production efficiencies. System Requirements • Instant status updates while still consuming minimal bandwidth to relieve strain on limited factory networks • Interoperable with ABB Real-TPI • Small form factor appropriate for deployment where space is scarce • Remote software management and configuration to simplify operations