Bibliographic citations
Tinco, E., (2022). Implementación de una solución de business intelligence para la toma de decisiones en el servicio de consulta externa de un hospital [Universidad Nacional Agraria La Molina]. https://hdl.handle.net/20.500.12996/5284
Tinco, E., Implementación de una solución de business intelligence para la toma de decisiones en el servicio de consulta externa de un hospital []. PE: Universidad Nacional Agraria La Molina; 2022. https://hdl.handle.net/20.500.12996/5284
@misc{renati/1116572,
title = "Implementación de una solución de business intelligence para la toma de decisiones en el servicio de consulta externa de un hospital",
author = "Tinco Curi, Elizabeth Irene",
publisher = "Universidad Nacional Agraria La Molina",
year = "2022"
}
Actually, the health sector dispose a large amount of information, the massive amount of data that is generated is complex, the hospitals and other organisations of the sector need an environment that supports the daily practices of doctors, the administration and the rest of the health care satff. The information used for the generation of reports comes from transactional systems (Hospital management system), which contains information regarding the patient and their care. The manufacturing process of the report is carried out in a manual-operative way causing delays and inconsistencies of information. The purpose of this report is to implement a Business Intelligence solution in order to obtain unique, clean, reliable and updated information to facilitate decision-making in the outpatient service of a hospital. For this purpose, the Ralph Kimball methodology was used, which fits to the needs of the company, essentially due to its schematization at the level of specific areas, development time and complexity. For the analysis process and the data depuration, as well as for extraction, transformation and loading of datamart update processes for the external consultation service, the SQL Server Enterprise 2016 tool was used. The result of the implementation of the Business Intelligence solution allowed generating reports and load data in less time, which leads to obtain reliable and concise information. The user may use the information through reports designed according to their needs. Finally, it was evidenced that the use of Business Intelligence tools had positive impacts on the area involved, facilitating the organization of information through data visualization and analysis tools such as: Excel, reporting services and power BI, which allowed taking correct decisions for the benefit of users.
This item is licensed under a Creative Commons License