Vigilância da Qualidade da Água para Consumo Humano (VIGIAGUA): painel bi com dados de 33 municípios do estado do Rio Grande do Sul

Abstract

Information and Communication Technology makes it possible to present information that supports decision-making such as epidemiological, demographic behavior and social determinants of health. Health surveillance plays an important role in protecting public health. The role of Environmental Health Surveillance (VAS) is to provide knowledge and detection of changes in the determining and conditioning factors of the environment that interfere with human health. Among the programs in which VAS operates is the Water Quality Surveillance Program for Human Consumption (VIGIAGUA), which regularly collects water samples for monitoring. And with the aim of improving monitoring and bringing transparency to the results of samples collected by surveillance. The objective of this work is to create a BI panel with regional data from water samples collected by surveillance and linked to the Water Quality Surveillance Program for human consumption (VIGIAGUA) of the 33 municipalities belonging to the 4th CRS of the State of Rio Grande do Sul from 2019 to 2023. The creation of the BI Panel was carried out using Power BI, Google Colab and GPT chat version 3.5 software with the support of current legislation for analyzing the sample results. The results are comprised of 1 analyzer code created in the Python language, and a BI panel with eight pages of data: a home page, an information page, a page with the historical series and five pages with years and their individual results. The VIGIAGUA panel provides a comprehensive and detailed view of the water quality situation for human consumption in this region and can serve as a model for other panels on water quality or other topics of interest in public health to be constructed.