In a large industrial group operating in the bakery sector across 17 production plants within 3 different countries, effective performance management is hampered by the fragmentation of data sources as a consequence of the heterogeneity of ERP (Enterprise Resource Planning) and MES (Manufacturing Execution System) systems. Such diversity prevents the consolidation of reliable and timely information, essential to drive decision-making processes both at plant-level and group-level. This thesis presents the design and implementation of a Group-level Business Intelligence (BI) at Morato Group S.p.A., developed to overcome these data integration challenges to enable centralized KPI monitoring across the entire organization. The project is structured according to lean management principles, adopting the Ishikawa diagram to detect the root-causes with the 5-Whys methodology, and developing the BI following a PDCA (Plan-Do-Check-Act) cycle, characteristic of a Continuous Improvement approach. The resulting system integrates data from heterogeneous sources into a unified semantic model, where by means of power queries, it cleans and elaborates data into relevant and spendable information. The latter are translated into reports showcasing KPI tracking, trend analysis, supporting and providing management with consistent and operational insights. This project, then, goes beyond the creation of the BI system: indeed, to feed such tool, standard operating procedures (SOP) have been set to standardize the process of data entry, representing a starting point to unify the ways different production plants operate, moving towards a multinational behavior. Concluding, this work ultimately demonstrates how lean methodologies, usually applied to production processes, can be effectively transposed to digital transformation projects in complex organizational environments, turning fragmented, unreliable data into a consistent and actionable information assets for the entire group.

In a large industrial group operating in the bakery sector across 17 production plants within 3 different countries, effective performance management is hampered by the fragmentation of data sources as a consequence of the heterogeneity of ERP (Enterprise Resource Planning) and MES (Manufacturing Execution System) systems. Such diversity prevents the consolidation of reliable and timely information, essential to drive decision-making processes both at plant-level and group-level. This thesis presents the design and implementation of a Group-level Business Intelligence (BI) at Morato Group S.p.A., developed to overcome these data integration challenges to enable centralized KPI monitoring across the entire organization. The project is structured according to lean management principles, adopting the Ishikawa diagram to detect the root-causes with the 5-Whys methodology, and developing the BI following a PDCA (Plan-Do-Check-Act) cycle, characteristic of a Continuous Improvement approach. The resulting system integrates data from heterogeneous sources into a unified semantic model, where by means of power queries, it cleans and elaborates data into relevant and spendable information. The latter are translated into reports showcasing KPI tracking, trend analysis, supporting and providing management with consistent and operational insights. This project, then, goes beyond the creation of the BI system: indeed, to feed such tool, standard operating procedures (SOP) have been set to standardize the process of data entry, representing a starting point to unify the ways different production plants operate, moving towards a multinational behavior. Concluding, this work ultimately demonstrates how lean methodologies, usually applied to production processes, can be effectively transposed to digital transformation projects in complex organizational environments, turning fragmented, unreliable data into a consistent and actionable information assets for the entire group.

Designing a Group-Level Business Intelligence System: A Continuous Improvement Approach to Data Integration and KPI Monitoring. The Case of Morato Group S.p.A.

ZAUSA, ANDREA
2025/2026

Abstract

In a large industrial group operating in the bakery sector across 17 production plants within 3 different countries, effective performance management is hampered by the fragmentation of data sources as a consequence of the heterogeneity of ERP (Enterprise Resource Planning) and MES (Manufacturing Execution System) systems. Such diversity prevents the consolidation of reliable and timely information, essential to drive decision-making processes both at plant-level and group-level. This thesis presents the design and implementation of a Group-level Business Intelligence (BI) at Morato Group S.p.A., developed to overcome these data integration challenges to enable centralized KPI monitoring across the entire organization. The project is structured according to lean management principles, adopting the Ishikawa diagram to detect the root-causes with the 5-Whys methodology, and developing the BI following a PDCA (Plan-Do-Check-Act) cycle, characteristic of a Continuous Improvement approach. The resulting system integrates data from heterogeneous sources into a unified semantic model, where by means of power queries, it cleans and elaborates data into relevant and spendable information. The latter are translated into reports showcasing KPI tracking, trend analysis, supporting and providing management with consistent and operational insights. This project, then, goes beyond the creation of the BI system: indeed, to feed such tool, standard operating procedures (SOP) have been set to standardize the process of data entry, representing a starting point to unify the ways different production plants operate, moving towards a multinational behavior. Concluding, this work ultimately demonstrates how lean methodologies, usually applied to production processes, can be effectively transposed to digital transformation projects in complex organizational environments, turning fragmented, unreliable data into a consistent and actionable information assets for the entire group.
2025
Designing a Group-Level Business Intelligence System: A Continuous Improvement Approach to Data Integration and KPI Monitoring. The Case of Morato Group S.p.A.
In a large industrial group operating in the bakery sector across 17 production plants within 3 different countries, effective performance management is hampered by the fragmentation of data sources as a consequence of the heterogeneity of ERP (Enterprise Resource Planning) and MES (Manufacturing Execution System) systems. Such diversity prevents the consolidation of reliable and timely information, essential to drive decision-making processes both at plant-level and group-level. This thesis presents the design and implementation of a Group-level Business Intelligence (BI) at Morato Group S.p.A., developed to overcome these data integration challenges to enable centralized KPI monitoring across the entire organization. The project is structured according to lean management principles, adopting the Ishikawa diagram to detect the root-causes with the 5-Whys methodology, and developing the BI following a PDCA (Plan-Do-Check-Act) cycle, characteristic of a Continuous Improvement approach. The resulting system integrates data from heterogeneous sources into a unified semantic model, where by means of power queries, it cleans and elaborates data into relevant and spendable information. The latter are translated into reports showcasing KPI tracking, trend analysis, supporting and providing management with consistent and operational insights. This project, then, goes beyond the creation of the BI system: indeed, to feed such tool, standard operating procedures (SOP) have been set to standardize the process of data entry, representing a starting point to unify the ways different production plants operate, moving towards a multinational behavior. Concluding, this work ultimately demonstrates how lean methodologies, usually applied to production processes, can be effectively transposed to digital transformation projects in complex organizational environments, turning fragmented, unreliable data into a consistent and actionable information assets for the entire group.
Kaizen
Digitalization
Performance
File in questo prodotto:
File Dimensione Formato  
Zausa_Andrea.pdf

Accesso riservato

Dimensione 15.67 MB
Formato Adobe PDF
15.67 MB Adobe PDF

The text of this website © Università degli studi di Padova. Full Text are published under a non-exclusive license. Metadata are under a CC0 License

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/20.500.12608/116894