In order to enable the location processes, aimed at developing the assortment proposal of the network and supporting the collaboration processes with the drug and para-pharmacy industry, a Data warehouse platform was activated focused on the return sales data of pharmacies participating in the project. The technology platform chosen is the Oracle Enterprise 12C database on ODA (Oracle Database Appliance) machine, completely managed through the application of Commercial Reactivity of Dialog Sistemi’s E3 Suite, which – in addition to providing application and reporting tools – offers system support and complete infrastructure outsourcing management. The Data Warehouse manages:
Users are divided into two categories:
pharmacies: receive monthly commercial reporting, with the performance of turnover and profit margin, compared with the geographical area benchmark; this allows to quickly identify the category gaps and product opportunities.
In order to achieve these goals, the solution of “Commercial Profitability” of E3 Suite was adopted, which allowed:
Thanks to the E3 Performance Management Platform Software, the following business results were achieved: