Estatística aplicada à gestão hospitalar: uma solução automatizada de business intelligence para geração de indicadores na rede EBSERH

Abstract

This paper presents the development of a BI application aimed at the automated generation of hospital indicators to support the management of the EBSERH network. The proposed solution seeks to overcome challenges faced by public hospitals in the construction and systematic use of indicators, such as the lack of technical staff and reliance on manual processes. The developed architecture integrates an automated ETL (Extract, Transform, Load) pipeline, implemented in the R programming language through the PaRGHA package, and executed in the Microsoft Azure cloud platform. Data are extracted from the Department of Information and Informatics of the SUS (DATASUS) data platform, transformed according to the Standard Operating Procedures (SOPs) provided by EBSERH, and stored in a DW. The indicators are visualized in an interactive Power BI dashboard, updated monthly, enabling historical and comparative analyses. The application combines statistical foundations with modern technologies, promoting greater efficiency, standardization, and evidence-based decision-making support. The solution is scalable, reproducible, and represents a meaningful contribution to public hospital management.