Data-Driven Fiscal Health Monitoring: Utilizing Data Analytics and Visualization as an Early Warning System for Local Governments to Achieve Financial Accountability

Fachroh Fiddin (), Teguh Widodo and Reni Farwitawati
Additional contact information
Fachroh Fiddin: Bengkalis State Polytechnic, Public Financial Accounting Departement
Teguh Widodo: Bengkalis State Polytechnic, International Business Administration Departemen
Reni Farwitawati: Lancang Kuning University, Accounting Departemen

A chapter in Proceedings of the International Conference on Applied Science and Technology on Social Science 2025 (iCAST-SS 2025), 2025, pp 360-370 from Springer

Abstract: Abstract This study addresses the critical issue of local government fiscal accountability in Indonesia, exemplified by Riau Province's significant budget deficit. It aims to design and implement a data-driven fiscal health monitoring dashboard as an early warning system (EWS) to enhance transparency and informed decision-making. Employing a mixed-methods sequential explanatory design and the CRISP-DM framework, this research develops a comprehensive dashboard using Microsoft Power BI. Financial data (budget realization and balance sheets) from all Indonesian local governments (2015–2023) were extracted from the Ministry of Finance's portal. Data Analysis Expressions (DAX) were used to calculate financial health indicators based on Ritonga's (2014) six-dimension model of local government financial condition. The study successfully developed an interactive dashboard that synthesizes complex financial data into accessible visualizations. Application to Riau Province reveals its overall fiscal health is categorized as “Adequate” compared to other Sumatran provinces. The analysis provides granular insights across all six dimensions—short-term and long-term solvency, budget solvency, financial flexibility, financial independence, and service solvency highlighting specific areas of strength and vulnerability, such as significant fluctuations in short-term solvency and service capacity. This research fills a critical gap by moving beyond static ratio analysis to implement a dynamic, integrated, and practical analytics-based EWS. It contributes to both practice and literature by demonstrating the application of advanced business intelligence tools in public sector financial monitoring, offering a replicable model for improving fiscal transparency and accountability.

Keywords: Data Analytics; Data Visualization; Early Warning System; Fiscal Health Monitoring; Financial Condition; Local Government; Power BI (search for similar items in EconPapers)
Date: 2025
References: Add references at CitEc
Citations:

There are no downloads for this item, see the EconPapers FAQ for hints about obtaining it.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:spr:advbcp:978-94-6463-938-4_42

Ordering information: This item can be ordered from
http://www.springer.com/9789464639384

DOI: 10.2991/978-94-6463-938-4_42

Access Statistics for this chapter

More chapters in Advances in Economics, Business and Management Research from Springer
Bibliographic data for series maintained by Sonal Shukla () and Springer Nature Abstracting and Indexing ().