Business Intelligence Based on Kimball Nine-Steps Methodology for Monitoring the Feasibility of Goods in Market
DOI:
https://doi.org/10.25008/ijadis.v4i2.1301Keywords:
Business Intelligence, Data Warehouse, decision-making, Kimball Nine-Step Methodology, Pentaho BIAbstract
Consumer protection is of great concern to the Government of Indonesia through the supervision of goods on the market by the Department of Industry and Trade in each province. The Bali Provincial Office of Industry and Trade has transactional data from various data sources but has not been able to optimize it to support monitoring of goods circulating in the market. This research designs and implements a Data Warehouse-based Business Intelligence system using the Kimball Nine-Steps Methodology and Pentaho BI tools, to facilitate the storage and processing of goods data on the market, and monitor their feasibility. The results of this research show that the system can assist the Bali Province Industry and Trade Office in monitoring the feasibility of goods circulating in the market through the selection process for determining query priorities and query modes, as well as supporting decision-making processes and determining business strategies.
Downloads
References
Badan Pemeriksa Keuangan (BPK) Republik Indonesia. Undang-Undang nomor 8 Tahun 1999 tentang Perlindungan Konsumen. JDIH BPK RI Database Peraturan. 2000. Retrieved: https://peraturan.bpk.go.id/Home/Details/45288/uu-no-8-tahun-1999
Kementerian Perdagangan Republik Indonesia. Homepage. Retrieved: https://www.kemendag.go.id/id
N. Marsela, and B. Hermanto, "Implementasi Business Intelligence untuk Penilaian Mutu Pelayanan di Rumah Sakit Umum Daerah Tulang Bawang Barat," Jurnal Pepadun, Vol.3, No.2, 2022. pp.179-193. https://doi.org/10.23960/pepadun.v3i2.114
A.W. Iswara, et al., "Implementation of Business Intelligence for Quality Support of RSUD Ir. Soekarno Sukoharjo with Data Warehouse," ITSMART: Jurnal Ilmiah Teknologi dan Informasi, Vol.9, No.1, 2020.
Syarli, et al., "Perancangan Business Intelligence System pada Gudang Farmasi Dinas Kesehatan Kabupaten Mamasa," Jurnal Keteknikan dan Sains (JUTEKS) LPPM UNHAS, Vol.1, No.1, 2018.
G.M.M. Castro, et al., "Business Intelligence Tools for a Digital Services Company in Peru," International Journal of Business Intelligence Research (IJBIR), Vol.14, No.1, 2022. https://doi.org/10.4018/IJBIR.318330
A. Suhendar, and T. Hikmatunnisa, "Penerapan Business Intelligence pada Peluang Jenis Usaha Baru Usaha Mikro Kecil Menengah dengan Menggunakan Teknologi On Line Analytical Processing," Jurnal Sistem Informasi (JSIL), Vol.9, No.2, 2022.
https://doi.org/10.30656/jsii.v9i2.5183
R. Akbar, e al., "Implementasi Business Intelligence untuk Mendapatkan Pola Penerbangan Penumpang Pesawat dari atau ke Bandara Internasional Minangkabau," Jurnal Edukasi dan Penelitian Informatika (JEPIN), Vol.4, No.1, 2018.
https://doi.org/10.26418/jp.v4i1.25580
A. Zikri, et al., "Implementasi Business Intelligence untuk Menganalisis Data Persalinan Anak di Klinik Ani Padang dengan Menggunakan Aplikasi Tableau Public," Jurnal Online Informatika (JOIN), Vol.2, No.1, 2017. https://doi.org/10.15575/join.v2i1.70
R. Akbar, et al., "Implementasi Business Intelligence untuk Menentukan Mahasiswa Penerima Beasiswa," Jurnal Ilmiah Rekayasa dan Manajemen Sistem Informasi, Vol.3, No.1, 2017.
Pratama, I.P.A.E., "Handbook Data Warehouse," Penerbit Informatika. 2018.
M. Furqon, and M.F. Nugraha, "Perancangan Data Warehouse Sistem Pendaftaran Mahasiswa Menggunakan Online Analytical Procesing (OLAP) di Universitas Ma'soem," INTERNAL (Information System Journal), Vol.4, No.1, 2021. pp.35-40.
https://doi.org/10.32627/internal.v4i1.283
Syarli, et al., "Perancangan Business Intelligence System pada Gudang Farmasi Dinas Kesehatan Kabupaten Mamasa," Jurnal Keteknikan dan Sains (JUTEKS), Vol.1, No.1, 2018.
W.S. Fana, et al, "Data Warehouse Design with ETL Method (Extract, Transform, and Load) for Company Information Centre," International Journal of Artificial Intelligence Research (IJAIR), Vol.5, No.2, 2021. pp.132-137.
https://doi.org/10.29099/ijair.v5i2.215
Q. Umam, et al., "Analisis Dan Perancangan Data Warehouse Menggunakan Pendekatan Mixed-Driven (Studi Pada Dinas Komunikasi dan Informatika Kabupaten Sidoarjo)," Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer, Vol.3, No.2, 2019.
J. Purwanto, and Renny, "Perancangan Data Warehouse Rumah Sakit Berbasis On-Line Analytical Processing (OLAP)," Jurnal Teknologi Informasi dan Ilmu Komputer (JTIIK), Vol.8, No.5, 2021. pp.1077-1088. https://doi.org/10.25126/jtiik.2021854232
M.F. Zulkarnaina, et al, "Perancangan dan Implementasi Data Warehouse Penjualan (Studi Kasus: Northwind Sample Database)," Jurnal Elektronik Ilmu Komputer Udayana, Vol.10, No.1. 2021. https://doi.org/10.24843/JLK.2021.v10.i01.p20
A. Muhammad, et al., "Perancangan Business Intelligence dengan Konsep Data Warehouse OLAP Untuk Mengetahui Kemampuan Mahasiswa pada Jurusan Teknik Informatika Mercu Buana Jakarta," Jurnal Ilmu Teknik dan Komputer, Vol.4, No.2, 2020.
S. Esser, and D. Fahland, "Multi-Dimensional Event Data in Graph Databases," Journal on Data Semantics, Vol.10, 2021. pp.109-141. https://doi.org/10.1007/s13740-021-00122-1
E.K. Suni, "Analisis dan Perancangan Data Warehouse Untuk Mendukung Keputusan Redaksi Televisi Menggunakan Metode Nine-Step Kimball," Jurnal Teknik Informatika, Vol.11, No.2, 2018. https://doi.org/10.15408/jti.v11i2.8560
G. Wijaya, "Perancangan Data Warehouse Nilai Mahasiswa Dengan Kimball Nine-Step Methodology," Jurnal Informatika, Vol.4, No.1, 2017.
M. Akbar, and Y. Rahmanto, "Desain Data Warehouse Penjualan Menggunakan Nine Step Methodology Untuk Business Intellgence pada PT Bangun Mitra Makmur," Jurnal Informatika dan Rekayasa Perangkat Lunak, Vol.1, No.2, 2020. https://doi.org/10.33365/jatika.v1i2.331
I.P.W. Prasetia, and I.N.H. Kurniawan, "Implementasi ETL (Extract, Transform, Load) pada Data Warehouse Penjualan Menggunakan Tools Pentaho," TIERS Information Technology Journal, Vol.2, No.1, 2021. pp.39-47. https://doi.org/10.38043/tiers.v2i1.2844
A.R. Iskandar, et al., "Extract, Transform, Load sebagai upaya Pembangunan Data Warehouse," Journal of Informatics and Communication Technology (JICT), Vol.1, No.1, 2019. https://doi.org/10.52661/j_ict.v1i1.21
N.W.S. Saraswati, and N.M.L. Martarini, "Extract Transform Loading Data Absensi STMIK STIKOM Indonesia Menggunakan Pentaho," Jurnal MATRIK, Vol.19, No.2, 2020. pp.273-281. https://doi.org/10.30812/matrik.v19i2.564
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2023 I Putu Agus Eka Pratama, I Made Sunia Raharja
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.