EUVIMEDEUVIMED entdecken
Open Access · CC BY 4.0

Development of Data Visualization Dashboard to Increase Transparency of Regional Revenue and Expenditure Budget (APBD) of Regency/City in Indonesia

Farhan Nanda Prihamudi, Rifdatun Ni'mah, Regita Putri Permata

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).

AbstractBibliografische AngabenZitierenVerwandte Studien

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}
}
Kostenlos starten →