Qlik > Case Studies > Pilot Gains a Dynamic View of Sales with QlikView

Pilot Gains a Dynamic View of Sales with QlikView

Qlik Logo
Customer Company Size
Mid-size Company
Region
  • Europe
Country
  • France
Product
  • QlikView
Tech Stack
  • Microsoft Dynamics AX
  • Microsoft SQL Server 2005
  • Microsoft Windows Server 2008 R2
Implementation Scale
  • Enterprise-wide Deployment
Impact Metrics
  • Productivity Improvements
  • Customer Satisfaction
Technology Category
  • Analytics & Modeling - Real Time Analytics
Applicable Industries
  • Consumer Goods
Applicable Functions
  • Sales & Marketing
  • Business Operation
Use Cases
  • Real-Time Location System (RTLS)
  • Supply Chain Visibility
Services
  • System Integration
  • Training
About The Customer
Pilot is a major player in the global writing instruments sector and a world leader in terms of technological innovation. With a presence in the sector for almost a century, Pilot sells its products in more than a 100 countries. Pilot Corporation of Europe has a turnover of more than €100 million and has some 200 partners. It also has its own manufacturing plants throughout the world and stands out for its capacity for innovation in a highly competitive market. Like any commercial enterprise, Pilot’s primary concern is the performance of its sales networks. Two issues stand out: one is intrinsic to the business and relates to a multi-support product offer, the other relates to its complex, international distribution networks.
The Challenge
Pilot, a major player in the global writing instruments sector, faced challenges in managing its complex sales processes. The company had a multi-support product offer and complex, international distribution networks. It was essential for the company to have a complete knowledge of all sales methods and dynamic analysis of sales and profitability by product and by customer. In early 2007, Pilot acquired an enterprise resource planning (ERP) system to integrate all its sales data. However, the system soon showed its limitations: no dynamic graphical retrieval and a lack of connections between data, implementation of new data sources, or new analysis axes. These weaknesses proved costly for Pilot, which is still a small medium-sized enterprise with limited resources and budgets.
The Solution
Pilot chose QlikTech partner Bios Consulting, as its integration partner for the business intelligence solution. Bios Consulting guided Pilot towards QlikView, which was able to provide associative data modelling to ensure that Pilot met its objectives. As a first step Bios Consulting scoped the project so as to be certain that the requirements, constraints and resources were understood and qualified. This stage took place in March 2010, and involved meetings with future users from general management to teams in the field. Deployment took just four months from training key QlikView users to the roll out of a pilot coaching application, testing stage, and then deployment. Taking data directly from the Pilot ERP, QlikView provides a dynamic view of company sales. It is now possible for users to view overall sales by type of product, by country, and by customer.
Operational Impact
  • QlikView helps users to easily change their analysis axes as they go along
  • Complete analyses and access to a situation overview
  • The ability to add external data such as budgets and panels
  • Provides monitoring of sales portfolio in real time and subsequently more fine-tuned forecasts
  • Makes applications available to all, within a specific framework, facilitating a shared identical view of data
Quantitative Benefit
  • Deployment took just four months
  • The company now holds 20 QlikView licenses, with plans to increase this to 35 to 45 in the medium term

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.