), a leader in Business Discovery – user-driven Business Intelligence (BI), today announced that Pilot, a leading player in the development and marketing of writing instruments, has deployed QlikView to provide dynamic analysis of sales and profitability by product and customer. QlikView has delivered a simple, reliable solution for analyzing Pilot’s product offer and complex distributor network, and has since been deployed across all departments.
Limitations of a Standard ERP Architecture
Pilot markets its products in more than one hundred countries, and like any business, must closely follow the performance of its sales channels. Equipped with a long-time ERP system that integrates all its sales data, the company’s most pressing priority was to break down the value of sales and define rules of management according to accurate analysis results. To meet this need, Pilot’s IT team created a decision model based on a multidimensional cube structure.
This system, which retrieved data and analyzed it in Excel, soon showed its limitations: no dynamic graphical retrieval and a lack of connections between data, implementation of new data sources, or new analysis filters. These weaknesses proved costly for Pilot, prompting its finance department to look for a global solution that could deliver tangible results quickly.
Benefits of Dynamic Analysis
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 in real time. Pilot users can now create analyses mid-month and view sales with the control panel gauges instead of waiting for month-end reports.
"QlikView allows you to change the axis of analysis and therefore process an idea in transit. The criteria for analysis are automatically propagated from one tab to another,” said Patrick Forveille, Corporate Services Manager in Pilot Corporation of Europe. "Its user-friendly visualization is both simple and quick to implement. It is now used daily in every department across the business.”