Development of Data Visualization Dashboard to Increase Transparency of Regional Revenue and Expenditure Budget (APBD) of Regency/City in Indonesia
International Journal on Advanced Science, Engineering and Information Technology · 28.06.2026 · 16 (3) · 1060-1067
DOI: 10.18517/ijaseit.16.3.21335 ↗Kurz gefasst
Fachartikel in der Zeitschrift International Journal on Advanced Science, Engineering and Information Technology, online erschienen am 28.06.2026. Verfasst von Farhan Nanda Prihamudi und 2 weiteren Autor:innen. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).
Abstract (Originalsprache)
Limited public understanding of how regional revenue and expenditure budget (APBD) funds are allocated often results in low levels of citizen participation and weak oversight of regional financial governance. This study proposes a technological solution that integrates automated data collection, data transformation, and interactive visualization to enhance fiscal transparency. Web scraping is used as an efficient data-mining technique to systematically extract APBD information from the Ministry of Finance’s dynamic DJPK portal. The collected data undergo an Extract, Transform, Load (ETL) workflow using Python and PostgreSQL to ensure structured, validated, and analysis-ready datasets. The cleaned data are visualized in Power BI through multi-level interactive dashboards at the national, provincial, and district/city scales, enabling users to explore budget allocations, spending realization, efficiency levels, and comparative trends across regions and years. This visualization framework improves the interpretability of complex fiscal data and encourages citizen engagement by providing clear, accessible, and data-driven insights. The proposed pipeline also introduces automation mechanisms to reduce manual operation and improve data consistency. The results demonstrate that open data technologies, combined with automation and user-centered visualization, can serve as a replicable model for strengthening transparency and accountability in public-sector financial management. Future research may incorporate predictive analytics, integrate socio-economic indicators for richer contextualization, and expand dissemination strategies to support broader public participation and proactive budgeting.
Zitieren
APA
Prihamudi, F. N., Ni'mah, R., & Permata, R. P. (2026). Development of Data Visualization Dashboard to Increase Transparency of Regional Revenue and Expenditure Budget (APBD) of Regency/City in Indonesia. International Journal on Advanced Science, Engineering and Information Technology, 16(3), 1060-1067. https://doi.org/10.18517/ijaseit.16.3.21335
Vancouver
Prihamudi FN, Ni'mah R, Permata RP. Development of Data Visualization Dashboard to Increase Transparency of Regional Revenue and Expenditure Budget (APBD) of Regency/City in Indonesia. International Journal on Advanced Science, Engineering and Information Technology. 2026;16(3):1060-1067. doi:10.18517/ijaseit.16.3.21335
BibTeX
@article{Prihamudi2026,
author = {Prihamudi, Farhan Nanda and Ni'mah, Rifdatun and Permata, Regita Putri},
title = {Development of Data Visualization Dashboard to Increase Transparency of Regional Revenue and Expenditure Budget (APBD) of Regency/City in Indonesia},
journal = {International Journal on Advanced Science, Engineering and Information Technology},
year = {2026},
volume = {16},
number = {3},
pages = {1060--1067},
doi = {10.18517/ijaseit.16.3.21335}
}
EUVIMED