POWER BUSINESS INTELLIGENCE DASHBOARD VISUALIZATION of LOSSES NUMBER of MOTOR VEHICLE in EAST JAVA, INDONESIA
-
Ardath Prahara Setyan(1)
Departemenof Informatic, Sekolah Tinggi Teknologi Pomosda
-
I Putu Agus Eka Pratama(2*)
Departemenof Information Technology, Faculty of Engineering, Udayana University
(*) Corresponding Author
Abstract
East Java Province has a high number of motorized vehicle losses with various modes of crime. There needs to be a system that can process the data to assist the decision-making process for law enforcement officers in investigating the crime of motor vehicle theft and reducing the amount of loss. For this reason, in this research, data processing of motor vehicle theft was carried out using Business Intelligence (BI) and displayed on the Power BI dashboard. The research methodology used is literature study, interviews, data collection, implementation, evaluation, and documentation. The test results show the highest number of vehicle theft cases occurred in 2016 (1,635 cases) with the most modes using fake keys, and with the highest vehicle brand being Honda. The final result of the study shows that the presentation of data and information visually and interactively based on Power BI can help law enforcers to understand data, obtain information, and make decisions and policies to handle motorcycle theft cases.
Downloads
References
Law Commission of Canada, "What Is a Crime?," in What Is a Crime? Defining Criminal Conduct in Contemporary Society, Canada, UBC Press, 2004, p.30.
Bureau of Justice Statistics, "www.bjs.gov," Office of Justice Programs, 2014. [Online]. Available: http://www.bjs.gov/index.cfm?ty=tdtp&tid=3. [Accessed 23-Feb-2023].
C. Vercellis, “Business Intelligence: Data Mining and Optimization for Decision Making,” Chichester, United Kingdom: John Wiley & Sons Ltd, 2009.
Z. N. Husni, I. Mukhlash, “Implementasi Business Intelligence Pada Manajemen Report Bank XYZ,” Jurnal Sains dan Seni ITS, Vol. 3, No.2, 2014, doi: https://doi.org/10.12962/j23373520.v3i2.7923.
Imelda, “Business Intelligence”, Majalah Ilmiah UNIKOM, 2012. [Online]. Available: https://
repository.unikom.ac.id/30377/1/09-miu-11-1-imelda.pdf. [Accessed 23-Feb-2023].
W. D. Suryanto, “Pengembangan Data warehouse dan aplikasi OLAP Data Tracer Study Alumni IPB Berbasis Web Menggunakan Microsoft Bussiness Intelligence”, Repositori IPB Bogor, 2010.
R. Akbar, W. Wulandari, Z. Hasanah, and H. Gravina, “Implementasi Business Intelligence Untuk Menentukan Mahasiswa Penerima Beasiswa”. Jurnal Ilmiah Rekayasa dan Manajemen Sistem Informasi, Vol. 3, No. 1, pp. 65-69, 2017, doi: https://doi.org/10.24014/rmsi.v3i1.3374.
E. Turban, J. E. Aronson, T. P. Liang, and R. Sharda, “Decision support and business intelligence systems,” Pearson Education, 2005.
Ronald, “Quick Intro to Microsoft Office Performance Point Server 2007,” Bandung: MIC ITB, 2008.
K. Gowthami and M. R. Pavan Kumar, “Study on Business Intelligence Tools for Enterprise Dashboard Development”, IRJET, Vol. 4, No. 4, 2017. [Online]. Available: https://www.academia.edu/download/
/IRJET-V4I4721.pdf. [Accessed 23-Feb-2023].
A. Hijriani, E. Aprilliana, R. I. A. Pribadi, D. Sakethi, “Implementasi Business Intelligence Dashboard (BID) dengan Metode ADDIE pada Usaha Mikro Bidang Retail Studi Kasus CV Duta Square Bandar Lampung,” Jurnal Matrix, Vol. 10, No. 1, 2020, doi: https://doi.org/10.31940/matrix.v10i1.1616.
B. Yap, Y.C. Giap, “Penerapan Business Intelligence Pada CV. Tanggamas Chemical Dengan Metode OLAP,” Jurnal ALGOR, Vol. 2, NO.1, 2020. [Online]. Available: https://jurnal.ubd.ac.id/index.php/
algor/article/view/465/264. [Accessed 23-Feb-2023].
D. Nurmalasari, Nurzikriah, "Implementasi Business Intelligence Dashboard pada Data Pasien Puskesmas Kecamatan Rokan," JKT, Vol. 7, No. 2, 2021, doi: https://doi.org/10.35143/jkt.v7i2.4986.
A. Zikri, J. Adrian, A. Soniawan, R. Azim, R. Dinur, and R. Akbar, “Implementasi Business Intelligence untuk Menganalisis Data Persalinan Anak di Klinik Ani Padang dengan Menggunakan Aplikasi Tableau Public,” JOIN, Vol. 2, No. 1, 2017, doi: https://doi.org/10.15575/join.v2i1.70.
N. M. Putri, I. P. R. Paramaditya, I. B. M. Swarbawa, G. L. A. Arsa, and I. B. M. Mahendra, “Implementasi Business Intelligence Untuk Menentukan Tingkat Kasus Covid-19 di Indonesia," JELIKU, Vol. 10, No. 1, 2021, doi: https://doi.org/10.24843/JLK.2021.v10.i01.p17.
Siska, D. S. Putri, “Implementasi Business Intelligence Untuk Menganalisis Perbandingan Data Kasus Covid19 di Jawa Barat Sebelum PSBB dan Sesudah PSBB,” EDUTIK, Vol.7, No. 2, 2021, doi: https://
doi.org/10.21107/edutic.v7i2.9893.
R. Akbar, V. Alfarizi, T. B. Amarta, N. N. Ardian, M. J. Ibrahim, “Implementasi Business Intelligence untuk Mendapatkan Pola Penerbangan Penumpang Pesawat dari atau ke Bandara Internasional Minangkabau,” JEPIN, Vol. 4, No. 1, 2018, doi: https://doi.org/10.26418/jp.v4i1.25580.
F. A. Sariasih, “Implementasi Business Intelligence Dashboard dengan Tableau Public untuk Visualisasi Propinsi Rawan Banjir di Indonesia”, jptam, Vol. 6, No. 2, 2022, doi: https://doi.org/
31004/jptam.v6i2.4715.
R. Akbar, D. Rasyiddah, M. Anrisya, N. F. Julyazti, and S. Syaputri, “Penerapan Aplikasi Power Business Intelligence Dalam Menganalisis Prioritas Pekerjaan di Indonesia,” JEPIN, Vol. 4, No.1, 2018, doi: https://doi.org/10.26418/jp.v4i1.25497.
R. Akbar, W. Wulandari, Z. Hasanah, H. Gravina, “Implementasi Business Intelligence Untuk Menentukan Mahasiswa Penerima Beasiswa,” RMSI, Vol. 3, No. 1, 2017, doi: https://doi.org/
24014/rmsi.v3i1.3374.
Copyright (c) 2023 Ardath Prahara Setyan, I Putu Agus Eka Pratama
This work is licensed under a Creative Commons Attribution 4.0 International License.
The author submitting the manuscript must understand and agree that if accepted for publication, authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution (CC-BY) 4.0 License that allows others to share the work with an acknowledgment of the work’s authorship and initial publication in this journal.
