Painéis de gestão estratégica para monitoramento de despesas dos entes públicos de uma prefeitura

Abstract

This article addresses the creation of dashboards for financial management in public organizations. It emphasizes the importance of frequent monitoring of expenses and the need to identify spending patterns in federative entities to enable a more optimized future distribution. Using Business Intelligence (BI), specifically the Qlik Sense tool, accessible visualization models were created to facilitate decision-making. The results show the easy use of the tool and the effectiveness of the implementation in Campo Grande-MS, highlighting the efficiency of the ETL process and the creation of dashboards to interpret the data. It suggests future improvements and expansion of data usage in subsequent phases of the expenditure cycle.