BUSINESS INTELLIGENCE PROTOTYPE FOR OUTPATIENT OF THE HUMANITARIAN HOSPITAL

Authors

  • Karina Orellana Bravo Universidad de Cuenca

DOI:

https://doi.org/10.26871/killkanatecnica.v6i2.941

Abstract

This article explains the implementation of a Business Intelligence system to manage the productivity indicator of the outpatient area of ​​the Pablo Jaramillo Humanitarian Hospital, which is part of a corporate group of companies.

The productivity indicator refers to the number of patients seen in consultation in a period of time, by specialty and doctor.

Currently the indicator is generated manually and only when the month ends and for this a flat report is requested that has to be tabulated in spreadsheets. To solve this problem, a Business Intelligence system was created that daily and automatically updates the information required to feed this indicator and is presented in a specialized tool for BI with information cut off the previous day.

The implementation was carried out using its own methodology and the official tools of the group were used.

After implementation, the results and benefits they represent for the hospital are validated, both in terms of delivery time and in resources used prior to and after implementation.

The main benefits are: the elimination of the time required to obtain the indicator results, the rapid analysis of the indicators and the great variety of information obtained from a single dashboard.

Downloads

Download data is not yet available.

References

Mora, G. (2018). Siglo XXI economía de la información: gestión del conocimiento y Business Intelligence, el camino a seguir hacia la competitividad. SIGNOS - Investigación en sistemas de gestión, 10(2), 161–174. https://doi.org/10.15332/s2145-1389.2018.0002.09

Dedić, N., & Stanier, C. (2017). Measuring the success of changes to Business Intelligence solutions to improve Business Intelligence reporting. Journal of Management Analytics, 4(2), 130–144. https://doi.org/10.1080/23270012.2017.1299048

Rodríguez, J. M. R. (2014). Cómo hacer inteligente su negocio. Grupo Editorial Patria.

Montejo, Y. C., & Sousa, H. P. (2021). Gestión documental, Gestión de información y Gestión del conocimiento: nociones e interrelaciones. Bibliotecas. Anales de investigación, 222-227.

Datos, información, conocimiento. (s. f.). Sinergia. Recuperado 6 de febrero de 2022, de https://www.sinnexus.com/business_intelligence/piramide_negocio.aspx

Kimball, R. y Ross, M. (2019). El kit de herramientas del almacén de datos: la guía definitiva para el modelado dimensional, ed. Wiley.

Rodríguez, A., & Bernal, E. (2019). Gestión de la información cuantitativa en las universidades, Pistas para su abordaje en la era de la sobreinformación. Bogotá DC: Universidad Nacional de Colombia.

Hernández Mejía, S. (2019). Comparativo de metodologías y herramientas para el desarrollo de un data warehouse.

Mettler, T., & Vimarlund, V. (2009). Understanding business intelligence in the context of healthcare. Health Informatics Journal, 15(3), 254–264. https://doi.org/10.1177/1460458209337446

Arnaudo, M. F., Lago, F. P., & Bandoni, J. A. (2020). Toma de decisiones en el sistema de salud: aportes interdisciplinarios desde la Economía de la Salud y la Ingeniería de Sistemas de Procesos. Ensayos de Economía, 30(56), 136–150. https://doi.org/10.15446/ede.v30n56.78681

Palacios-Tapia, J. A., Medina, E. H., Ochoa-Crespo, J. D., & Torres-Palacios, M. M. (2020). Business Intelligence aplicado al sector Salud. Revista Arbitrada Interdisciplinaria Koinonía, 5(3), 622. https://doi.org/10.35381/r.k.v5i3.914

Bernabeu, D. (2008, 4 agosto). II HEFESTO: Metodologia para la Construcción de un Data Warehouse | Dataprix TI. dataprix.com. Recuperado 6 de febrero de 2022, de https://www.dataprix.com/es/data-warehousing-y-metodologia-hefesto/ii-hefesto-metodologia-construccion-un-data-warehouse

V6.N2. art. 1

Published

2022-05-05
ESTADISTICAS
  • Abstract 183
  • PDF (Español (España)) 200

How to Cite

1.
Orellana Bravo K. BUSINESS INTELLIGENCE PROTOTYPE FOR OUTPATIENT OF THE HUMANITARIAN HOSPITAL. tecnica [Internet]. 2022 May 5 [cited 2024 Jul. 3];6(2):1-12. Available from: https://killkana.ucacue.edu.ec/index.php/killkana_tecnico/article/view/941