O uso do Power BI como estratégia de visualização de dados aplicado à análise de casos de dengue no Brasil

Abstract

This work presents the development and implementation of an interactive dashboard for monito- ring dengue cases in the state of Paraná, using Business Intelligence (BI) and data automation tools. The objective was to create a solution capable of integrating different technologies for data collection, processing, and visualization of epidemiological information, focusing on automatic updates and cloud accessibility. The adopted methodology was based on the CRISP-DM mo- del, encompassing all stages from data understanding to the deployment of the final solution. The system was developed using Python for data processing automation, GitHub Actions for scheduled workflow execution, Azure Blob Storage as the cloud storage service, and Power BI as the main analysis and visualization tool. The result was a cloud-based interactive dashbo- ard, accessible through Power BI Service, capable of presenting up-to-date dengue indicators, including reported, confirmed, and death cases, as well as enabling analyses by municipality, age group, and epidemiological period. The automation process reduced the need for manual interventions, ensuring greater reliability and efficiency in monitoring. The results demonstrated that the integration between cloud BI and data automation is a viable and scalable alternative for monitoring public health indicators. The proposed solution can be adapted to other diseases and epidemiological contexts.