Developing a BI Solution for Public Process Monitoring
DOI:
https://doi.org/10.59490/dgo.2025.966Keywords:
Business Intelligence, Process Monitoring, Public Sector, Data VisualizationAbstract
The development of Business Intelligence (BI) tools is essential for improving the efficiency and quality of services in public and private organizations. However, public institutions, especially at the subnational level, often face challenges due to legacy systems that complicate effective data utilization. This study focuses on a subnational public institution, the Court of Auditors of the State of Pernambuco (TCE-PE), which previously relied on a dashboard with several limitations, including usability issues, data inconsistencies, and maintenance complexities due to its dependence on multiple SQL Server database views. This study presents the development of a new dashboard, designed using an agile methodology, to centralize data transformations within the BI tool. The proposed solution focuses on the Accountability process, aiming to enhance data consistency and improve performance monitoring. The development process was structured into four key phases: Problem Identification, Planning and Requirements Collection, Design and Development, and Validation and Testing, ensuring a systematic and iterative approach to address the institution’s needs. The new system utilizes Qlik Sense, eliminating dependency on SQL Server views and allowing real-time analysis through interactive dashboards. The solution overcomes prior limitations, providing faster, more accurate, and reliable analyses aligned with the institution’s strategic objectives. By improving flexibility, usability, and data reliability, this initiative not only serves as a reference for other subnational institutions in Brazil but can also be adapted as a model for organizations operating in diverse contexts worldwide.
Downloads
References
Ahrend, N. (2014). Opportunities and limitations of bpm initiatives in public administrations across levels and institutions.
Al-Saqqa, S., Sawalha, S., & AbdelNabi, H. (2020). Agile software development: Methodologies and trends. International Journal of Interactive Mobile Technologies, 14(11).
Andrade, A. C., Rocha, C. M. C., & Carpina, H. M. S. (2023). Painel de dados sociais para aprimoramento da administração da justiça: O caso do ministério público do distrito federal e territórios.
Ceccato, F. (2023). A digital transformation process from qlik to power bi in a fashion firm [Master’s thesis, Università Ca’ Foscari Venezia]. [link]
Dascalu, E. D., Marcu, N., & Hurjui, I. (2016). Performance management and monitoring of internal audit for the public sector in romania. Amfiteatru Economic Journal, 18(43), 691–705.
Dingre, S. S. (2023). Internal controls in the etl process. Journal of Artificial Intelligence & Cloud Computing. [link]
Dumas, M., Rosa, L. M., Mendling, J., & Reijers, A. H. (2018). Fundamentals of business process management. Springer.
Fioretto, S., & Masciari, E. (2024). A conceptual framework for predictive process monitoring in public administration. International Conference on Complex, Intelligent, and Software Intensive Systems, 423–431.
Gulledge Jr, T. R., & Sommer, R. A. (2002). Business process management: Public sector implications. Business process management journal, 8(4), 364–376.
Matheus, R., Janssen, M., & Maheshwari, D. (2020). Data science empowering the public: Data-driven dashboards for transparent and accountable decision-making in smart cities. Government Information Quarterly, 37(3), 101284. DOI: https://doi.org/10.1016/j.giq.2018.01.006.
Mix, G. (2016). Best practices for local government business intelligence implementations [Master’s thesis, University of Oregon]. [link]
Mohamed, N. A., & Kulmie, D. A. (2023). Role of effective monitoring and evaluation in promoting good governance in public institutions. Public Administration Research, 12(2), 48.
Munné, R. (2016). Big data in the public sector. New horizons for a data-driven economy: A roadmap for usage and exploitation of big Data in Europe, 195–208.
Negash, S. (2004). Business intelligence. Communications of the Association for Information Systems, 13. DOI: https://doi.org/10.17705/1CAIS.01315.
Qlik. (2025). Qlik sense [Data analytics and business intelligence software]. [link]
Samad, S., & Setyabudhi, A. L. (2023). Design of dashboard administration of the public sector. Engineering and Technology International Journal, 5(01), 71–80.
Sanabia-Lizarraga, K. G., Carballo-Mendívil, B., Arellano-González, A., & Bueno-Solano, A. (2024). Business intelligence for agricultural foreign trade: Design and application of power bi dashboard. Sustainability, 16(21), 9576.
Sprenkamp, K., Zavolokina, L., Angst, M., & Dolata, M. (2023). Data-driven governance in crises: Topic modelling for the identification of refugee needs. Proceedings of the 24th Annual International Conference on Digital Government Research, 1–11.
TCE-PE. (2015). Resolução nº 22/2015: dispõe sobre a constituição do processo eletrônico no sistema e-TCEPE e dá outras providências [Consulta ao Art. 46]. [link]
TCE-PE. (2025a). Atribuições do tce. [link]
TCE-PE. (2025b). Electronic process system. [link]
TCE-PE. (2025c). Public consultation. [link]
Tregear, R., & Jenkins, T. (2007). Government process management: A review of key differences between the public and private sectors and their influence on the achievement of public sector process management. BPTrends, October 2007.
Venkateswarlu, M., & Vasista, T. (2023). Extraction, transformation and loading process in the cloud computing scenario. International Journal of Engineering Applied Sciences and Technology, 8, 232–236.
Vila, R. A., Estevez, E., & Fillottrani, P. R. (2018). The design and use of dashboards for driving decision-making in the public sector. Proceedings of the 11th International Conference on Theory and Practice of Electronic Governance, 382–388.
Widjaja, S., & Mauritsius, T. (2019). The development of performance dashboard visualization with power bi as platform. Int. J. Mech. Eng. Technol, 10(5), 235–249.
Downloads
Published
How to Cite
Conference Proceedings Volume
Section
License
Copyright (c) 2025 Rafael José Moura, Maria Gizele Nascimento, George Valença, Kellyton Brito, Glória Fraga, Sérgio Peixoto, Ermeson Andrade
This work is licensed under a Creative Commons Attribution 4.0 International License.
