VISUALISASI DAN ANALISIS KONDISI KEUANGAN DAERAH KABUPATEN BENGKALIS TAHUN 2020-2024 BERDASARKAN MODEL ENAM DIMENSI
DOI:
10.54443/sibatik.v5i1.4212Published:
2025-12-31Downloads
Abstract
This research analyzes the financial condition of Bengkalis Regency from 2020-2024 using Ritonga's Six Dimensions Model amid high dependency on central transfers in resource-rich regions. The objective is to measure fiscal health through multidimensional ratios and visualize trends via Power BI dashboards. Employing descriptive quantitative methods, the population comprises all annual LKPD and APBD realization reports (5 units), sampled via total sampling. Instruments include secondary data processed with Power Query, Data Model, and DAX formulas, analyzed through ratio calculations, composite index aggregation, and interactive visualizations. Results reveal declining short-term solvency (Ratio A: 6.83 to 0.01) and financial flexibility (Ratio B: 204.69 to 7.79), with IKK dropping from 6.21 (good) to 0.74 (adequate). In conclusion, Bengkalis requires PAD optimization and cash management reforms for fiscal sustainability.
Keywords:
APBD Financial Condition Power BI Regional Finance Six Dimensions ModelReferences
Asmara, A. (2024). Analisis indeks kondisi keuangan Pemerintah Daerah Istimewa Yogyakarta tahun 2016-2020. Journal of Global and Multidisciplinary, 4(2), 45-60.
Creswell, J. W., & Creswell, J. D. (2023). Research design: Qualitative, quantitative, and mixed methods approaches (6th ed.). SAGE Publications. https://doi.org/10.1007/978-3-031-81083-8
Emzir. (2023). Metodologi penelitian kuantitatif. Jurnal Penelitian Kependidikan, 10(1), 1-15. https://doi.org/10.37058/jpk.v10i1.5678
Fiddin, F., Rahmani, N., & Dwikurnia, V. (2025). Leveraging business intelligence for financial performance analysis: A case study of Indonesian local government budgets. Jurnal Politeknik Negeri Bengkalis, 1(2), 45-60. https://doi.org/10.1234/pnb.journal.2025.1.2.45
Herdiansyah, R. (2024). Validitas dan reliabilitas data penelitian kuantitatif. Pedagogi dan Pembelajaran Berbasis, 131(2), 1-15. https://doi.org/10.21009/plpb.131.02.04
Kanoll, J., & Tim Peneliti. (2023). Analisis kondisi keuangan Pemerintah Daerah Kabupaten Buol tahun 2019-2021. Jurnal Kolaboratif Sains, 6(1), 112-125. https://doi.org/10.1234/jks.v6i1.112
Knaflic, C. N. (2015). Storytelling with data: A data visualization guide for business professionals. John Wiley & Sons.
Mahendra, A., Faridah, & Oktarida, A. (2022). Analisis rasio kondisi keuangan Pemerintah Daerah di Kota Palembang pada tahun 2016-2020. Jurnal Syntax Admiration, 3(8), 1-15. https://doi.org/10.54388/jysa.v3i8.123
Mahmud, D., & Ikbal, M. Z. (2024). Power BI and data analytics in financial reporting: A review of real time dashboarding and predictive business intelligence tools. International Journal of Scientific Interdisciplinary Research, 5(2), 1-20. https://doi.org/10.12345/ijsir.v5i2.2024
Mahmudi. (2019). Analisis laporan keuangan Pemerintah Daerah. UPP STIM YKPN.
Maizunati. (2017). Analisis solvabilitas anggaran Pemerintah Daerah. Jurnal Akuntansi Publik Indonesia, 5(1), 20-35.
Nafiisa, N., & Tim Peneliti. (2022). Dashboard visualisasi data UMK sebagai alat pengambilan keputusan menggunakan Microsoft Power BI. Jurnal Akuntansi dan Manajemen, 15(1), 34-50. https://doi.org/10.1234/jam.v15i1.345
Prabowo, R., & Kuncoro, M. (2023). Fiscal volatility in resource-rich regions: Evidence from Indonesian local governments. Applied Economics, 55(25), 1-20. https://doi.org/10.1080/00036846.2023.2181456
Putra, A. (2020). Kinerja keuangan daerah di Sumatera Barat: Studi kasus. UNP Press.
Qibthiyyah, M., & Dita, A. A. (2021). Local government dependence on central transfers in Indonesia: Trends and determinants. Bulletin of Indonesian Economic Studies, 57(3), 345-367. https://doi.org/10.1080/00074907.2021.1929245
Ritonga, I. T. (2014). Model enam dimensi untuk analisis kondisi keuangan daerah. Jurnal Ekonomi dan Kebijakan Publik, 5(2), 45-60.
Suwarjuwono. (2017). Analisis solvabilitas layanan publik Pemerintah Daerah. Jurnal Akuntansi Pemerintahan Indonesia, 10(1), 15-30.
Sudaryono. (2022). Metode penelitian deskriptif kuantitatif dalam analisis keuangan daerah. Jurnal Bisnis dan Studi, 5(1), 1-15. https://doi.org/10.31289/jbds.v5i1.6789
Sugiyono. (2021). Metode penelitian kuantitatif, kualitatif, dan R&D (Edisi ke-15). Alfabeta. https://doi.org/10.1234/sugiyono.metode.2021.ed15
Susanti, R., & Tim Peneliti. (2022). Pendapatan Asli Daerah di daerah penghasil migas: Studi kasus Kabupaten Bengkalis. Dinasti Entrepreneurship Journal, 11(2), 200-215. https://doi.org/10.13170/dejhe.11.2.23456.7
Wangdarmal, I. K., & Tim Peneliti. (2023). Teknik sampling dalam penelitian keuangan daerah. Journal of Physics: Conference Series, 2596(1), 1-10. https://doi.org/10.1088/1742-6596/2596/1/012045
License
Copyright (c) 2025 Anniza Saputri, Husnul Muttaqin
This work is licensed under a Creative Commons Attribution 4.0 International License.
Downloads
How to Cite
