The Use of Business Intelligence Software to Monitor Key Performance Indicators (KPIs) for the Evaluation of a Computerized Maintenance Management System (CMMS)

Paola Picozzi,Umberto Nocco,Andrea Pezzillo,Adriana De Cosmo,Veronica Cimolin
DOI: https://doi.org/10.3390/electronics13122286
IF: 2.9
2024-06-12
Electronics
Abstract:The increasing use of electromedical equipment in hospital care services necessitates effective management of complex devices often unsupported by existing control systems. This paper focuses on developing a pool of evaluation indices for the Clinical Engineering Department (CED) of the ASST Grande Ospedale Metropolitano Niguarda in Milano (Italy), aiming to enhance awareness of the economic value, assess operational units, and optimize maintenance processes. Leveraging business intelligence, this study identifies 18 key performance indicators (KPIs) across logistics, technical, and equipment management categories. An interactive dashboard, implemented using Power BI, facilitates dynamic analysis and visualization of these KPIs, providing insights into the maintenance efficiency and obsolescence of medical devices. It offers a comprehensive framework for ongoing monitoring and decision-making. The results showcase the potential of the developed KPIs and dashboard to enhance operational insights and guide improvements in the healthcare facility's maintenance processes.
engineering, electrical & electronic,computer science, information systems,physics, applied
What problem does this paper attempt to address?
The problem that this paper attempts to solve is: in the hospital environment, with the increasing number and complexity of electronic medical devices, the existing control systems are often unable to effectively support the management of these devices. Therefore, this article aims to develop an evaluation index system for the Clinical Engineering Department (CED) of ASST Grande Ospedale Metropolitano Niguarda in Milan to enhance the understanding of economic value, evaluate operational units, and optimize maintenance processes. Specifically, the main objectives of this study include: 1. **Develop an evaluation index system**: Identify and define 18 key performance indicators (KPI) covering logistics, technology, and equipment management categories in order to analyze the equipment status in the entire facility more comprehensively. 2. **Verify the feasibility of KPI**: Ensure that these KPI can be calculated from the data in the existing management software systems (such as CMMS). 3. **Implement a visualization tool**: Develop an interactive dashboard through Power BI to dynamically analyze and visualize these KPI, thereby providing in - depth insights into maintenance efficiency and equipment obsolescence. 4. **Optimize the decision - making process**: Provide a framework for continuous monitoring and decision - making to guide the improvement of the maintenance processes in medical institutions. Through these measures, this study hopes to use business intelligence technology to improve operational insights, thereby guiding and improving the maintenance management processes in medical institutions.