Desarrollo de un prototipo de solución de business intelligence para la consulta externa del Hospital Humanitario

Abstract

The Humanitarian Hospital - Fundación Pablo Jaramillo Crespo is a private, non-profit institution that, together with companies such as Indurama and Marcimex, belongs to the Consenso business group; and orients its health care benefits, as a priority, to low-income people, for which it provides medical services at affordable prices. This document details how a Business Intelligence system was implemented for the outpatient area of the Pablo Jaramillo Humanitarian Hospital, in order to better manage the productivity indicator; which is currently prepared manually and can only be viewed when the month has ended, requesting a report in spreadsheets to start its tabulation. The productivity indicator is specific to the Humanitarian Hospital and is used to refer to the number of patients treated over a period of time, by specialty and doctor. The purpose of the business intelligence system to be developed will be the daily and automatic update of the information necessary to obtain this indicator and present it graphically, on a specialized data analysis tool. In this way, timely monitoring and control of the care that doctors provide to patients can be given. In the theoretical framework, a description of the basic concepts used in this document was made, as well as an investigation of what is currently documented about the use of business intelligence related to the management of health homes. The implementation carried out is detailed and the results and improvements that it represents in the management of the area are validated, the main benefits being the elimination of the time required to obtain the results of the indicator, the rapid analysis of the indicator and the great variety of information obtained. from a single board.