Construcción de una solución business intelligence en los módulos de historias clínicas y odontológicas del proyecto "JUNTOS POR UNA SONRISA"

Abstract

This research focuses on implementing a Business Intelligence (BI) solution for the “TOGETHER FOR A SMILE” project to provide valuable insights for analysis. The implementation process includes identifying requirements through meetings with medical and dental managers, scoping, data processing, and building the BI solution. Once the requirements were identified, data extraction was conducted for analysis, and a data warehouse was developed based on the Hephaestus methodology to feed the BI solution. For this purpose, ETL processes are performed in the JPUS computer system to guarantee the integrity of its data. Finally, the BI solution is made with the Microsoft Power BI tool, which will provide a complete view of the project by presenting dynamic dashboards for the dentistry and medicine modules, making it possible to identify opportunities and areas for improvement through the use of different types of graphics according to the requirements obtained. Successful implementation of a BI solution requires a comprehensive approach that includes theoretical background, identification of appropriate methodologies and tools, execution of technical processes, and implementation of customized solutions for the project's specific needs. The BI solution will help linkage managers make better decisions and increase project efficiency by enabling more detailed medical and dental data analysis.