Business Intelligence Dashboard for Financial Performance Analysis of Public Service Agency Using Microsoft Power BI

Main Article Content

Damayanti Larasati
Nanny Dewi Tanzil
Adhi Alfian
Lindawati Wardani

Abstract

This research discusses the use of business intelligence dashboard for financial performance analysis at the BRIN Technology Service Center Public Service Agency, focusing on the decrease of BLU cash balance. The factors that affect the ups and downs of the BLU cash balance are the total revenue realization and the total revenue expenditure realization in the current year. Business Intelligence (BI) is one of the tools that allows organizations to access and analyze data and information to improve and optimize decisions and performance. In Indonesia, there has not been much research related to the implementation of business intelligence dashboards for financial performance analysis in public service agencies. The research aims to create a business intelligence dashboard that can provide insight to leaders in making decisions to increase BLU cash balances. This research uses a qualitative descriptive method, and the system development method uses a business intelligence roadmap approach. The result of this research is that with the help of the BI dashboard, executives can gain insight to increase Blu's cash balance, improvements in receivables management are needed and they need to be more selective in choosing partners who use technology services.

Article Details

Section
Articles
Author Biographies

Damayanti Larasati, Universitas Padjadjaran

  • Mahasiswa S2 Program Studi Magister Akuntansi - FEB UNPAD
  • Analis Pengelolaan Keuangan APBN Ahli Muda - BRIN

Nanny Dewi Tanzil, Universitas Padjadjaran

  • Ketua Program Studi Magister Akuntansi - FEB UNPAD;
  • Dosen Program Studi Magister Akuntansi - FEB UNPAD;
  • Ketua Tim Pembimbing.

Adhi Alfian, Universitas Padjadjaran

  • Dosen Program Studi Magister Akuntansi - FEB UNPAD;
  • Tim Pembimbing.

Lindawati Wardani, Badan Riset dan Inovasi Nasional

  • Sekretaris Deputi Bidang Pemanfaatan Riset dan Inovasi - BRIN
  • Tim Pembimbing

References

Fathoni, F., & Jayadi, R. (2022). Fundraising Decision Support System on Indonesia’s Oil Palm Public Service Agency Using Kimball-Ross Four-Step Dimensional Process and Metabase Dashboard. Journal of Theoretical and Applied Information Technology, 31(14). www.jatit.org
Fauzi, F., Dencik, A. B., & Asiati, D. I. (2021). Metodologi Penelitian untuk Manajemen dan Akuntansi: Aplikasi SPSS dan EViews untuk Teknik Analisis Data. Jakarta: Salemba Empat.
Hani Zulkifli Abai, N., Yahaya, J., Deraman, A., Razak Hamdan, A., Mansor, Z., & Yah Jusoh, Y. (2019). Integrating Business Intelligence and Analytics in Managing Public Sector Performance: An Empirical Study. International Journal on Advanced Science, Engineering and Information Technology, 9(1), 172–180. https://doi.org/10.18517/ijaseit.9.1.6694
Huang, Z. xiong, Savita, K. S., & Zhong-jie, J. (2022). The Business Intelligence impact on the financial performance of start-ups. Information Processing and Management, 59(1). https://doi.org/10.1016/j.ipm.2021.102761
Kasten, J. E. (2020). Trust, organizational decision-making, and data analytics: An exploratory study. International Journal of Business Intelligence Research, 11(1), 22–37. https://doi.org/10.4018/IJBIR.2020010102
Menteri Keuangan Republik Indonesia. (2022). Keputusan Menteri Keuangan Republik Indonesia Nomor 362/KMK.05/2022 Tentang Penetapan Pusat Pelayanan Teknologi Pada Badan Riset dan Inovasi Nasional Sebagai Instansi Pemerintah Yang Menerapkan Pola Pengelolaan Keuangan Badan Layanan Umum.
Moss, L. T., & Atre, S. (2003). Business intelligence roadmap : the complete project lifecycle for decision-support applications. Addison-Wesley.
Noval, M. (2020). Sistem Business Intelligence untuk Evaluasi Kinerja Widyaiswara Kementerian Agama. Jurnal Rekayasa Sistem Dan Teknologi Informasi, 4(5), 864–873.
Patricia, W., & Pamungkas, B. (2020). Analisis Pengelolaan Piutang Penerimaan Negara Bukan Pajak (PNBP). In Jurnal Ilmu Manajemen dan Bisnis (Vol. 11).
Presiden Republik Indonesia. (2004). Undang-Undang Republik Indonesia Nomor 1 Tahun 2004 Tentang Perbendaharaan Negara. https://peraturan.bpk.go.id/Home/Details/40446/uu-no-1-tahun-2004
Pusyantek BRIN. (2023). Selamat datang di website Pusat Pelayanan Teknologi BRIN (Pusyantek-BRIN). https://pusyantek.brin.go.id/
Silvia Febriola, & Bai Saroh, A. R. S. (2023). Analisis Sistem Pengendalian Internal Piutang Dalam Meningkatkan Efektivitas Penagihan Piutang Pada Badan Layanan Umum Pusat Penelitian dan Pengembangan Teknologi Minyak dan Gas Bumi. Jurnal Ekonomi Trisakti, 3(1), 1299–1308. https://doi.org/10.25105/jet.v3i1.16141
Widjaja, S., & Mauritsius, T. (2019). The Development of Performance Dashboard Visualization with Power BI as Platform. International Journal of Mechanical Engineering and Technology (IJMET), 10(5), 235–249. http://iaeme.com/Home/issue/IJMET?Volume=10&Issue=5http://iaeme.com
Wikamulia, N., & Isa, S. M. (2023). Predictive business intelligence dashboard for food and beverage business. Bulletin of Electrical Engineering and Informatics, 12(5), 3016–3026. https://doi.org/10.11591/eei.v12i5.5162