Perbaikan Sistem Monitoring Sertifikasi Pekerja Berbasis Dashboard Interaktif dengan Metode PDCA
DOI:
https://doi.org/10.35718/jinseng.v3i2.8481998Keywords:
PDCA, Monitoring, Sertifikasi, Power BI , DashboardAbstract
Worker certification is an important aspect in supporting company operations, especially in the oil and gas industry which has high work risks and requires workers with competencies that meet established standards. PT Pertamina Hulu Indonesia Regional 3 Zone 9 needs to ensure that worker certification validity periods are properly monitored so that recertification can be planned on time. The problem identified in this study is that certification monitoring is still carried out manually using Microsoft Excel, which requires data to be checked one by one and increases the risk of overlooking certifications that are approaching their expiration dates. This study aims to apply the Plan-Do-Check-Act (PDCA) method to improve the monitoring system and to design an interactive dashboard to support the control of worker certification data. The data used in this study consisted of historical training and certification records from 2023 to 2025. Data processing was conducted through cleaning, standardization, Master Data preparation, and the addition of supporting columns such as expired date, total day, month, remaining days, status reminder, priority, cost cluster, and training category. The processed data were then developed into dashboards using Microsoft Excel and Power BI. The results show that the designed dashboard can present certification information in a more concise, structured, and understandable format. Microsoft Excel was considered more suitable for daily operational monitoring because it is easy for the Human Capital Business Partner (HCBP) function to use, while Power BI was more effective for reporting needs due to its stronger visual display. The application of PDCA and the design of an interactive dashboard can support a more directed worker certification monitoring process.
Keywords: PDCA, dashboard, monitoring, certification, Power BI
References
Annas Fatia, I. dan Latifah, N. 2025. Pengembangan Dashboard Business Intelligence untuk Analisis Profil dan Kinerja Karyawan, Jurnal Bisantara Informatika, 9(2), hlm. 35–43.
Hutagaol, A.S., Samantha, V., Salsabila, T.M. dan Wasino. 2024. Perancangan Dashboard Monitoring Untuk Monthly Report Pemesanan Hotel dengan Microsoft Power BI, Jutisi: Jurnal Ilmiah Teknik Informatika dan Sistem Informasi, 13(3), hlm. 2078–2089.
Irawan, B.H., Ariyanto, N.P., Novianti, N.A., Widiastuti, H., Restu, F. dan Arifin, N.L. 2022. Penggunaan Power BI untuk pengolahan data non-conformance material, Jurnal Teknologi dan Riset Terapan (JATRA), 4(2), hlm. 52–57.
Jabar, A.A., Wijaya, R.F. dan Wahyuni, S. 2025. Dashboard visualisasi data kecerdasan bisnis untuk mendukung pengambilan keputusan bisnis pada PT BMPT, Djtechno: Jurnal Teknologi Informasi, 6(1), hlm. 75–89.
Jufri, M.A., Alam, S. dan Aris, V. 2024. Implementation of Power BI as Key Performance Indicators Analysis in Monitoring Business Operational Control at PT. Mandiri Harapan Jaya, Innovative: Journal of Social Science Research, 4(4), hlm. 2563–2572.
Khairat, S.S., Dukkipati, A., Lauria, H.A., Bice, T., Travers, D. dan Carson, S.S. 2018. The impact of visualization dashboards on quality of care and clinician satisfaction: Integrative literature review, JMIR Human Factors, 5(2), e22.
Kristofher, Somantri, A. dan Sukendar, A. 2022. Perancangan dashboard monitoring kinerja pegawai (studi kasus: Perusahaan Dagang XXX), Jurnal Pasundan Informatika, 1(2), hlm. 9–16.
Malvin, E. 2024. Perancangan dashboard untuk visualisasi data penjualan PT.KZP, Jurnal Ilmu Komputer dan Sistem Informasi, 12(1).
Naughton, E., Moran, R., Kharub, M., Sa, J.C. dan McDermott, O. 2024. A structured model for continuous improvement methodology deployment and sustainment: A case study, Heliyon, 10(21), e40034.
Nazrica, S.A., Putra, H. dan Khaliq, A. 2024. Analisis data training karyawan menggunakan Power BI Software as a Service di Main Dealer Honda Sumatera Utara, Journal Global Technology Computer, 4(1), hlm. 68–74.
Nurrohmah, R.I. dan Cahyani, R.R. 2023. Peran Human Capital Business Partner & General Service PT Angkasa Pura 1 Kantor Cabang Adi Soemarmo terhadap efektivitas kinerja perusahaan, Jurnal Ekonomi Bisnis dan Kewirausahaan, 12(1), hlm. 47–58.
Rahmawati, Y., Rosita, S. dan Arsita, S. 2021. Penyuluhan penggunaan Microsoft Excel dalam menghitung ukuran pemusatan dan penyebaran data statistik, Jurnal Pengabdian kepada Masyarakat Dewantara, 4(1), hlm. 8–19.
Risnita et al. 2022. Kapita selekta manajemen pendidikan Islam. Jambi: Dotplus Publisher.
Saputro, D.R.S. et al. 2025. Data science untuk pemula: Teori, penerapan, dan implementasi. Yogyakarta: PT Star Digital Publishing.
Septanto, H. dan Hidayatullah, A. 2022. Perancangan sistem informasi monitoring proyek berbasis web untuk mendukung implementasi paperless office, Jurnal Tera, 2(2), hlm. 34–43.
Setiawati, Y. dan Gultom, L.K. 2025. Dampak sertifikasi kompetensi terhadap efektivitas kerja SDM MICE, Jurnal Lentera Bisnis, 14(2), hlm. 1648–1655.
Sihombing, W.W., Aryadita, H. dan Rusdianto, D.S. 2019. Perancangan dashboard untuk monitoring dan evaluasi (studi kasus: FILKOM UB), Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer, 3(1), hlm. 434–441.
Thayeb, E. dan Santosa, B. 2021. Pengaruh sertifikasi kompetensi, intensitas pelatihan dan pengalaman mengajar terhadap profesionalitas instruktur balai latihan kerja, Jurnal Taman Vokasi, 9(2), hlm. 167–177.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2026 Putri Nabila, Christopher Davito Prabandewa Hertadi
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
