Business Intelligence Dashboard Human Resource Capacity to Increase the Capacity City of Bekasi
DOI:
https://doi.org/10.30983/knowbase.v4i2.8764Keywords:
human resources, city capacity, Bekasi, Data, Dashboard visualitationAbstract
Bekasi City with qualified and evenly distributed human resources will be better able to meet dynamic and complex development needs. Effective data visualization can simplify complex information related to HR capacity, such as education levels, skills distribution, and the number of workers in various sectors, making it easier for policy makers to design strategies including identifying the distribution of filling several positions based on gender and identifying areas of need for educational facilities, children's health, and other infrastructure that supports the growth and development of the younger generation, and developing more effective policies to improve the overall capacity of the city. This research aims to develop a human resource capacity data visualization model as a tool in improving city capacity. This research uses Google Looker Studio as a data visualization platform, data integration is done by Extract, Transform, Load (ETL) method, the data starts from Excel then cleaned, adjusted the format and loaded into Google Sheets. The data used includes key variables that describe the characteristics of human resources in the Bekasi city area, such as education, age group, gender, and demographic distribution. The results show that based on the dashboard visualization, the Bekasi City government can increase 10% representation of the number of women in supervisory and administrator positions in 2 years and the number of only 5% at the S2 or S3 education level requires an increase in education to support the optimization of HR for strategic positions
References
R. Wahyuni, “Knowbase : International Journal of Knowledge in Database Integration of Digital Public Services Mall Application with a Citizen Centric Government Services Approach,” Int. J. Knowl. Database, vol. 04, no. 01, pp. 13–27, 2024.
I Nengah Sudja and A. S. G. Wahyudi, Pengembangan Sumber Daya Manusia, no. November. 2020.
N. Qomariah, MANAJEMEN SUMBER DAYA MANUSIA (Teori, Aplikasi dan Studi Empiris). 2021.
E. T. Ningsih, “Knowbase : International Journal of Knowledge in Database Decision Support System for Choosing The Best Housing Location by The Satisficing Model and AHP Method,” Int. J. Knowl. Database, vol. 02, no. 02, pp. 202–217, 2022.
I. Widiastuti, “Analisis Manajemen Sumber Daya Manusia Strategik Pada Dinas Kebersihan Kota Bekasi,” Komitmen J. Ilm. Manaj., vol. 1, no. 2, pp. 59–67, 2020.
H. Wulandari and T. Raharjo, “Systematic Literature and Expert Review of Agile Methodology Usage in Business Intelligence Projects,” J. Inf. Syst. Eng. Bus. Intell., vol. 9, no. 2, pp. 214–227, 2023, doi: 10.20473/jisebi.9.2.214-227.
J. Ansher and E. P. Rachmawati, “View of Visualisasi Data Operasi SAR BASARNAS Di Indonesia Menggunakan Google Looker Studio.pdf.”
N. T. Florencondia, C. M. Ladignon, and R. M. C. Muldong, “Enhancing Performance Metrics: A Google Looker Studio Approach to Key Performance Indicator (KPI) Management System for Homecorp Offshore Drafting Team,” Eng. Technol. J., vol. 09, no. 05, pp. 4076–4088, 2024, doi: 10.47191/etj/v9i05.25.
A. A. Touil and S. Jabraoui, “Information Quality of Business Intelligence Systems: A Maturity-based Assessment,” J. Inf. Syst. Eng. Bus. Intell., vol. 9, no. 2, pp. 276–287, 2023, doi: 10.20473/jisebi.9.2.276-287.
Guy Ritchie and S. Hariyanto, “Implementation of Business Intelligence In Analyzing Data Using Tableau at PT Global Bintan Permata,” bit-Tech, vol. 6, no. 1, pp. 40–50, 2023, doi: 10.32877/bt.v6i1.875.
I. R. Bahtiar, M. A. Nur, and A. Marzuq, “Peningkatan Kompetensi Pembuatan Dan Visualisasi Data Bagi Tenaga Kependidikan,” J. Pengabdi. Kpd. Masy., vol. 3, no. 1, pp. 22–32, 2022.
S. R. Wicaksono, “Visualisasi Data dan Storytelling Looker.” 2024.
A. Hadi Wijaya and W. Fitri, “Dasboard dan Visualisasi Reservasi Buka Puasa di Hotel XYZ Menggunakan Looker Studio & Google Form,” J. Informatics Busisnes, vol. 01, no. 04, pp. 354–359, 2024.
F. N. Hayati, M. Silfiani, and D. Nurlaily, “Pemanfaatan Google Data Studio Untuk Visualisasi E-Rapor Siswa Sman 2 Balikpapan,” J. Pengabdi. Kpd. Masy. ITK, vol. 2, no. 2, pp. 87–94, 2021.
A. Fitri Ariani, K. Aulia, and L. O. Ahmad Arafat, “Pengembangan Dashboard Interaktif Menggunakan Looker Studio Untuk Visualisasi Dan Prediksi Harga Komoditas Cabe Di Jawa Timur,” JATI (Jurnal Mhs. Tek. Inform., vol. 8, no. 4, pp. 8067–8074, 2024.
R. Al Ghivary, M. Mawar, N. Wulandari, N. Srikandi, and A. N. M. F, “Peran Visualisasi Data Untuk Menunjang Analisa Data Kependudukan Di Indonesia,” Pentahelix, vol. 1, no. 1, p. 57, 2023.
M. J. Islami, “Implementasi Satu Data Indonesia: Tantangan dan Critical Success Factors (CSFs) One Data Indonesia Implementation: Challenges and Critical Success Factors,” J. Komunika J. Komun. dan Inform., vol. 10, no. 1, pp. 13–23, 2021, doi: 10.31504/komunika.v9i1.3750.
S. Pulipati and N. Kelly, Data Storytelling with Google Looker Studio: A hands-on guide to using Looker Studio for building compelling and effective dashboards. 2022.
F. Oktaviani and N. R. Damayanti, “Optimasi Google Loker Studio dalam Visualisasi Data Peserta Didik Sma Pusri Palembang Tahun 2022-2024,” vol. xx, no. x, 2024.
Admin, “Jumlah Penduduk Tahun 2023,” 2023. https://disdukcapil.bekasikota.go.id
H. I. N. Lizana and F. Ridho, “Implementasi dan Evaluasi Visualisasi Data Interaktif pada Publikasi Laporan Bulanan Data Sosial Ekonomi Indonesia,” Semin. Nas. Off. Stat., vol. 2021, no. 1, pp. 947–957, 2021.
H. Henderi and R. L. Wanda, “Preprocessing Data Untuk Sistem Peramalan Tingkat Kedisiplinan Mahasiswa,” ICIT J., vol. 3, no. 2, pp. 296–308, 2017.
E. P. Wicaksono, “Visualisasi Data Opini Publik Menggunakan Looker Studio ( Studi Kasus Pemilihan Umum Presiden Indonesia 2024 ),” no. 62, 2024.
U. F. Kurniawati et al., “Pengolahan Data Berbasis Sistem Informasi Geografis (SIG) di Kecamatan Sukolilo,” SEWAGATI, J. Pengabdi. Kpd. Masy., vol. 4, no. 3, p. 190, 2020.
K. Banyumanik, “ANALISIS POTENSI DESA BERBASIS SISTEM INFORMASI GEOGRAFIS (Studi Kasus: Kelurahan Sumurboto, Kecamatan Banyumanik, Kabupaten Semarang),” J. Geod. Undip, vol. 7, no. 4, pp. 1–7, 2018.
U. Sofiyah, E. K. Lestari, and D. Yunitasari, “BEKASI SMART CITY IMPLEMENTATION: THE EFFECT OF USERS CHARACTERISTICS ON USERS COMMUNICATION BEHAVIOR OF INTEGRATED ONLINE COMPLAINTS (POT),” Reg. J. Pembang. Wil. dan Perenc. Partisipatif, vol. 17, no. 1, p. 104, 2022, doi: 10.20961/region.v17i1.43001.
D. Ayudya and I. Ikaputra, “UNDERSTANDING URBAN DEVELOPMENT THROUGH URBAN MORPHOLOGY,” J. Pembang. Wil. dan Kota, vol. 18, no. 3, pp. 235–245, 2022, doi: 10.14710/pwk.v18i3.36135.
A. N. Aisyah and P. G. Ariastita, “Strategi Penerapan Kota Kompak Berdasarkan Pola Urban Compactness di Kota Bekasi,” J. Tek. ITS, vol. 6, no. 2, 2018.
Z. I. Aditya Wardhana, Uji Validitas dan Reliabilitas pada Data Penelitian Kuantitatif, no. Juni. 2024.
S. Riyanto, E. Marlina, H. Subagyo, H. Triasih, and A. Yaman, “Metode Penilaian Kualitas Data Sebagai Rekomendasi Sistem Repositori Ilmiah Nasional,” Baca J. Dokumentasi Dan Inf., vol. 41, no. 1, p. 11, 2020, doi: 10.14203/j.baca.v41i1.544.
M. Adisyah Putra, B. Sasmito, and F. Hadi, “Evaluasi Perkembangan dan Kesesuaian Kawasan Ruang Terbuka Hijau terhadap RTRW Kota Bekasi (Studi Kasus: Kec. Jatisampura, Kota Bekasi),” J. Geod. Undip, vol. 12, no. 3, pp. 291–300, 2023.
Y. I. Astuty, Marwah Noer, Demi Stevany, Brenda Arham, Brigita Maria R, and Adi Wibowo, “Evaluasi Kesesuaian Kawasan Peruntukan Industri Menggunakan Model Spasial (Studi Kasus : Kabupaten Bekasi),” J. Pendidik. Geogr. Undiksha, vol. 11, no. 2, pp. 123–132, 2023, doi: 10.23887/jjpg.v11i2.61536.
T. Ishak, M. Muhammad, and N. Nurmayana, “Peran Badan Kepegawaian Pengembangan Sumberdaya Manusia (BPSDM) terhadap Kinerja Pegawai Negeri Sipil,” HUMANIS J. Ilmu Adm. Negara, vol. 6, no. 1, pp. 52–69, 2020, doi: 10.52137/humanis.v6i1.13.
T. Yuniarti and M. Armen, “Implementation : The Effect Of Users Characteristics On Users Communication Behavior Of Integrated Online Complaints (POT),” J. PIKOM (Penelitian Komun. dan Pembangunan), vol. 21, no. 2, pp. 101–116, 2020.
F. Insani, B. Barus, and D. P. Lubis, “Zona Pengembangan Usaha Mikro Kecil dan Menengah (UMKM) Pengolah Makanan di Kota Bekasi,” J. Reg. Rural Dev. Plan., vol. 5, no. 1, pp. 61–76, 2021, doi: 10.29244/jp2wd.2021.5.1.61-76.
V. N. Fikriyah, H. Al Hasbi, N. L. Anggani, and U. E. I. Kiat, “Visualisasi Dan Analisis Data Fasilitas Kesehatan Berbasis Web Dengan Arcgis Storymaps,” J. Ilm. Kesehat. Keperawatan, vol. 18, no. 1, p. 7, 2022, doi: 10.26753/jikk.v18i1.757.
C. Pramana, KESEHATAN MASYARAKAT DI ERA SOCIETY 5 . 0, no. August. Kota Bandung: MEDIA SAINS INDONESIA, 2021.
Downloads
Submitted
Accepted
Published
Issue
Section
License
Copyright (c) 2024 R Wisnu Prio Pamungkas, Rakhmi Khalida
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).
