Corofar

Goals

Implement a modern and efficient management control and monitoring system for its main operating areas (sales and purchases, logistics and customer service) using interactive analysis on the most important corporate and financial variables and indicators, whilst also measuring operational performance. This system is also employed to identify and define the best operational and supporting policies regarding development strategies and customer service.

Solution

COROFAR a while back had already identified the need to adopt a Data Warehouse environment to allow the automatic acquisition of management system data on the AS/400 already in use, without having to write complex management programs or to transform data. After detailed analysis of existing solutions on the market, Corofar chose Explorer, Dialog Sistemi’s solution that operates in one integrated environment. Available in Italian, with a state-of-the-art Data Warehouse system, it also provides very flexible Business Intelligence solutions to create user-friendly analysis and reports.

Data Warehouse is created by a Windows server and an Oracle database guaranteeing great efficiency for data management. Thanks to a partnership with Dialog Sistemi it is possible to implement OLAP interactive analysis, reports and summarising dashboards with specific indicators for: • Sales and purchases: promotions, campaigns and marketing, customer segmentation and demand analysis, supplier and customer discounts • Logistics/facilities: creating accuracy, lost sales, product rotation • Profit and loss account: profitability analysis, performance operation management and efficiency indicators

Lastly, the training course designed by Dialog Sistemi for COROFAR users guaranteed an efficient use of the system.