Visualisasi dan Kondisi Keuangan Daerah Kabupaten Bengkalis Tahun 2020-2024 Menggunakan Microsoft Power BI

Saputri, Anniza (2026) Visualisasi dan Kondisi Keuangan Daerah Kabupaten Bengkalis Tahun 2020-2024 Menggunakan Microsoft Power BI. Other thesis, Politeknik Negeri Bengkalis.

[thumbnail of Abstract] Text (Abstract)
1. TA-5304221504-Abstract.pdf - Submitted Version
Available under License Creative Commons Attribution Share Alike.

Download (213kB)
[thumbnail of Bab I Pendahuluan] Text (Bab I Pendahuluan)
2. TA-5304221504-Bab I Pendahuluan.pdf - Submitted Version
Available under License Creative Commons Attribution Share Alike.

Download (282kB)
[thumbnail of Daftar Pustaka] Text (Daftar Pustaka)
3. TA-5304221504-Daftar Pustaka.pdf - Submitted Version
Available under License Creative Commons Attribution Share Alike.

Download (175kB)
[thumbnail of Full Text] Text (Full Text)
4. TA-5304221504-Full Text (1).pdf - Submitted Version
Restricted to Registered users only
Available under License Creative Commons Attribution Share Alike.

Download (4MB) | Request a copy

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.

Item Type: Thesis (Other)
Uncontrolled Keywords: APBD, Financial Condition, Power BI, Regional Finance, Six Dimensions Model
Subjects: 600 – ILMU TEKNIK DAN ILMU TERAPAN > 650 – Manajemen dan Administrasi Bisnis > 657 – Akuntansi > 657.4 – Laporan Keuangan
600 – ILMU TEKNIK DAN ILMU TERAPAN > 650 – Manajemen dan Administrasi Bisnis > 657 – Akuntansi
300 – ILMU SOSIAL > 330 – Ekonomi > 336 – Keuangan Publik (Pajak, Anggaran, Dll)
Divisions: Jurusan Administrasi Niaga > Sarjana Terapan (D-IV) Akuntansi Keuangan publik > SKRIPSI
Depositing User: Akuntansi Keuangan Publik 2022 Kelas C
Date Deposited: 31 Mar 2026 01:25
Last Modified: 31 Mar 2026 01:25
URI: https://eprints.polbeng.ac.id/id/eprint/4894

Actions (login required)

View Item
View Item