Case study: Business intelligence for monitoring and analysis of Saica Natur
Project based on the development of a Business Intelligence (BI) for the monitoring and analysis of the work reports made by the various Logistics Operators for Saica Natur.
Data Warehouse: MySQL.
ETL processes: Pentaho Data Integration (PDI).
Visualisation and analysis (BI): Jasper BI.
Monitor expenditure, improve quality of service and optimise routing. CGL is one of Saica Natur's Logistic Operators and offers you this system in the (SaaS: software as a service).
By means of a automated ETL processes information is extracted from the operational (transactional) database, transformed and loaded into the CGL-enabled Data Warehouse (multidimensional database) to support analytics. By means of web tools of Business IntelligenceIn this way, users, both of Saica Natur and of the Logistics Operators it has as suppliers, can visualise and analyse the information by means of dashboards, predefined reports or ad-hoc queries.
A series of production, service quality and efficiency indicators were pre-calculated. Logistics Operators only have access to their working parts, with a global level and a more restricted centre level (implicit filtering of data by entity and level). Through ad-hoc views, advanced users are given autonomy to build their own reports. For this purpose, manuals were prepared and training was provided in the use of Jasper.