Development of an Interactive Application in R Shiny for the Visualization of Hospital Service Indicators at the Alfonso Villagómez Román Pediatric Hospital

• Johanna Enith Aguilar-Reyes Escuela Superior Politécnica de Chimborazo, Ecuador. https://orcid.org/0000-0002-1230-2503
• Edwin Fernando Mejía-Peñafiel Escuela Superior Politécnica de Chimborazo, Ecuador. https://orcid.org/0000-0001-6888-4621
• Tania Paulina Morocho-Barrionuevo Escuela Superior Politécnica de Chimborazo, Ecuador. https://orcid.org/0000-0002-1019-6049
• Liliana Alejandra Funes-Samaniego Escuela Superior Politécnica de Chimborazo, Ecuador. https://orcid.org/0000-0002-5364-0699

DOI: https://doi.org/10.46925//rdluz.43.19

Keywords: Interactive application, R Shiny, data visualization, user interface, computing

Abstract

The article addresses the need for an interactive platform to represent service indicators at the Alfonso Villagómez Román Pediatric Hospital in Ecuador. A web application was developed in R Shiny to improve the visualization of these indicators. The objectives included the creation of the application, design of data warehouses, loading of relevant information and integration into administrative management. The justification lies in the importance of efficient management of hospital indicators and the technological potential in health. These indicators are crucial for evaluating the quality of healthcare and supporting informed decisions. The methodology ranges from planning to evaluation, with R Shiny for its ability to create interactive visualizations. The results include a successful web application, organized data warehouses and an integration of the hospital's administrative management. In conclusion, this work achieved its objective by creating a valuable tool for management and decision-making in the hospital environment, thus contributing to more efficient administration and optimization of resources.

References

Agresti, A., & Franklin, C. A. (2017). Statistics: The Art and Science of Learning from Data. Pearson.

Allman, E., & Carver, M. (2016). Markdown Guide. Retrieved from https://www.markdownguide.org/

American Hospital Association (2015). Estándares hospitalarios de cuidado: Una guía para la entrega de atención. Edición 5.0. Recuperado de: https://www.aha.org/system/files/2018-11/hsc2015_all.pdf

Cairo, A. (2016). The Truthful Art: Data, Charts, and Maps for Communication. New Riders.

Chang, W., & Borges Ribeiro, B. (2020). Mastering Shiny: Build Interactive Web Apps with R. O'Reilly Media.

Chang, W., Cheng, J., Allaire, J., Xie, Y., & McPherson, J. (2021) Shiny: Web Application Framework for R. R package version 1.7.

Donabedian, A. (2005). Evaluating the Quality of Medical Care. The Milbank Quarterly, 83(4), 691-729.

Few, S. (2012). Show Me the Numbers: Designing Tables and Graphs to Enlighten. Analytics Press.

Hastie, T., Tibshirani, R., & Friedman, J. (2009). The Elements of Statistical Learning: Data Mining, Inference, and Prediction. Springer.

Health Research & Educational Trust (2015). Definiciones de los indicadores hospitalarios. Recuperado de https://www.hret.org/data/hospital-indicators-definitions.pdf

Healy, K., & Moody, J. (2014). Data visualization in sociology. Annual Review of Sociology, 40, 105–128. https://doi.org/10.1146/annurev-soc-071312-145551

Heer, J., & Shneiderman, B. (2012). Interactive Dynamics for Visual Analysis. Queue, 10 (2), 1-39.

Hogg, R. V., McKean, J. W., & Craig, A. T. (2018). Introduction to Mathematical Statistics. Pearson.

Hospital Benchmarking (2018). Understanding Bed Turnover: Definitions & Benchmarks. Recuperado de: https://www.hospitalbenchmarking.com/post/understanding-bed-turnover-definitions-benchmarks

Matloff, N. (2011). The Art of R Programming: A Tour of Statistical Software Design. No Starch Press.

Ministerio de Salud de Chile (2019). Manual de Indicadores de Gestión Hospitalaria. División de Gestión de Redes Asistenciales. Recuperado de: https://diprece.minsal.cl/wp-content/uploads/2019/11/MANUAL-INDICADORES-DE-GESTION-HOSPITALARIA-2019.pdf

Montgomery, D. C., Jennings, C. L., & Kulahci, M. (2015). Introduction to Time Series Analysis and Forecasting. John Wiley & Sons.

Morrison, E. E., & D'Antonio, D. (2019). Introduction to the Financial Management of Healthcare Organizations. CRC Press.

Myers, G. J., Sandler, C., Badgett, T., Thomas, T. M., & Sandler, D. G. (2011). The Art of Software Testing. John Wiley & Sons.

Nigatu, H. B., & Zelalem, D. (2020). Time spent in hospital and its predictors among adult inpatients in public hospitals in Northern Ethiopia: prospective observational study. PloS One, 15 (3), e0229621.

Norman, D. A.(2013). The Design of Everyday Things. Basic Books.

Norman, D. A., & Nielsen, J. (2010). The Definition of User Experience (UX). Nielsen Norman Group.

Organización Mundial de la Salud. (2017). Alta hospitalaria segura: Documento técnico. Recuperado de: https://www.who.int/patientsafety/topics/high5s/h5s-brochure_es.pdf

Parmenter, D. (2015).Key Performance Indicators (KPI): Developing, Implementing, and Using Winning KPIs. John Wiley & Sons.

RStudio. (2021).Shiny: Web Application Framework for R. https://shiny.rstudio.com/

Silva, F. (2019). Web Application Development with R Using Shiny. Apress.

Szklo, M., & Nieto, F. J.(2019). Epidemiology: Beyond the Basics. Jones & Bartlett Learning.

Tukey, J. W.(1977). Exploratory Data Analysis. Addison-Wesley.

Ware, C. (2013). Information Visualization: Perception for Design. Elsevier.

Ware, C. (2012). Information Visualization: Perception for Design. Morgan Kaufmann.

Wickham, H. (2019). Advanced R. CRC Press.

Wickham, H., & Grolemund, G. (2017). R for Data Science: Import, Tidy, Transform, Visualize, and Model Data. O'Reilly Media. (2017).

Winston Chang et al. (2021). Shiny: Web Application Framework for R. R package version 1.7.1.

Xie, Y., Cheng, J., & Tan, X. (2018). Creating Interactive Web Data Visualization with R, RStudio, and Shiny. CRC Press.