Integrated Platform for Energy Consumption Management and Efficiency in Public Buildings in the State of Goiás

Resumo

This paper presents the development of a digital platform for managing and assessing energy performance in public buildings, with a pilot application in the state of Goiás, Brazil. The system, implemented in Python using the Flet framework, integrates three interconnected SQLite databases covering electricity billing, certified equipment performance data from Brazil’s National Energy Labeling Program (PBE-INMETRO) and on-site audit records. It enables the automated import and structured extraction of key billing information such as consumption, demand, tariff group and cost from PDF and Excel files, as well as the detailed registration of installed equipment at the room level. All entries are cross-referenced with standardized efficiency data to ensure consistency and accuracy. The platform provides interactive dashboards for consumption analysis, supports both macro-level and micro-level diagnostics and facilitates transparent monitoring of energy use patterns over time. A pilot case study was carried out at the Secretaria-Geral de Governo de Goiás (Goiás State Government’s General Secretariat – SGG), where the tool replaced manual paper-based data collection with direct digital registration, significantly improving data acquisition efficiency. The results highlight the platform’s potential to inform public policy, guide targeted energy efficiency interventions and serve as a replicable and open-access solution for other public institutions. Its structured architecture also establishes a foundation for the analysis of large data repositories through advanced data analytics techniques, enabling large-scale pattern recognition, trend forecasting and enhanced decision-making capabilities. Future developments include advanced dashboard features for year-to-year comparisons, group-based consumption analysis and the integration of performance indicators to evaluate energy efficiency and end-use consumption shares by equipment category.