下载PDF
Qlik > 实例探究 > 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

技术
  • 分析与建模 - 实时分析
适用行业
  • 汽车
  • 零售
适用功能
  • 销售与市场营销
  • 商业运营
用例
  • 供应链可见性(SCV)
  • 库存管理
服务
  • 数据科学服务
挑战
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.
关于客户
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.
解决方案
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.
运营影响
  • 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

相关案例.

联系我们

欢迎与我们交流!

* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

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