Business intelligence na gestão do serviço de atenção domiciliar de Belo Horizonte: o desenvolvimento de dashboards interativos

Abstract

Home Care (HC) constitutes a fundamental strategy of the Brazilian Unified Health System (SUS) to expand access, promote deinstitutionalization, and ensure continuity of care, particularly in the context of population aging and the increasing prevalence of chronic conditions. However, the management of Home Care Services (HCS) faces challenges related to fragmentation, data quality, and the underutilization of information recorded in health information systems, which limits performance monitoring and the strategic use of information in decision-making processes. In this context, Business Intelligence (BI) emerges as an approach capable of transforming operational data into relevant analytical information for management purposes. This study aimed to develop a BI solution to support the management of the Home Care Services of Belo Horizonte (SAD-BH) through the construction of an interactive dashboard based on data extracted from the e-SUS Home Care system (e-SUS AD). This is a methodological, descriptive study with a quantitative approach, focused on the development of an applied technological product, conducted in four phases: identification and analysis of informational requirements, data collection and processing, development of an interactive dashboard, and usability evaluation of the tool. Informational requirements were defined based on federal and state regulations of the “Melhor em Casa” Program, ensuring regulatory compliance and managerial relevance. The dashboard was developed using the Looker Studio platform, integrating strategic, care-related, and production indicators, with interactive features, dynamic filters, and conditional formatting. The developed product enables organized, timely, and secure access to service information, contributing to the qualification of management processes. Usability evaluation, conducted using the System Usability Scale, yielded a mean score of 89.5 points, classified as excellent, in an assisted assessment context. Additionally, evaluators unanimously recognized the strategic usefulness of the tool for managerial decision-making. It is concluded that the developed BI solution has the potential to enhance the analytical capacity of SAD-BH management, provided that it is accompanied by strategies aimed at improving the quality of data records within the health information system.