Pengembangan Sistem Dashboard Investasi sebagai Alat Monitoring dan Evaluasi di PT Riset Perkebunan Nusantara

Abstract

Penelitian ini dilakukan di PT Riset Perkebunan Nusantara untuk mengatasi kendala monitoring investasi yang masih dilakukan secara manual menggunakan beberapa file Microsoft Excel terpisah. Tujuan penelitian adalah mengembangkan dashboard investasi interaktif berbasis Microsoft Excel menggunakan Pivot Table, Pivot Chart, dan Slicer sebagai alat monitoring dan evaluasi investasi. Penelitian menggunakan metode Design Science Research (DSR) yang meliputi identifikasi masalah, perancangan, pengembangan, demonstrasi, dan evaluasi. Hasil penelitian menunjukkan bahwa dashboard yang dikembangkan mampu mengintegrasikan data RKAP dan realisasi, menyajikan informasi investasi secara cepat dan mudah dipahami, serta mendukung analisis melalui fitur visualisasi dan filter interaktif. Hasil evaluasi user melalui User Acceptance Testing (UAT) menunjukkan bahwa implementasi dashboard ini terbukti mampu meningkatkan efisiensi operasional dengan memangkas waktu pembuatan laporan dan meminimalisasi risiko kesalahan (human error). Secara keseluruhan, dashboard telah sesuai dengan kebutuhan monitoring investasi dan membantu manajemen dalam memperoleh informasi untuk pengambilan keputusan.

This research was conducted at PT Riset Perkebunan Nusantara to overcome the constraints of investment monitoring, which is still performed manually using several separate Microsoft Excel files. The objective of this research is to develop an interactive investment dashboard based on Microsoft Excel utilizing Pivot Table, Pivot Chart, and Slicer as tools for investment monitoring and evaluation. This research employed the Design Science Research (DSR) method, which includes problem identification, design, development, demonstration, and evaluation. The results show that the developed dashboard is capable of integrating RKAP and realization data, presenting investment information quickly and comprehensively, as well as supporting analysis through interactive visualizations and filter features. User evaluation results through User Acceptance Testing (UAT) indicate that the implementation of this dashboard is proven to increase operational efficiency by reducing report generation time and minimizing the risk of human error. Overall, the dashboard meets the requirements for investment monitoring and assists the management in obtaining information for decision-making.