Pemetaan Pola Produktivitas Tanaman Pangan Menggunakan Data Warehouse dan K-Means Clustering


  • Fernando Adi Saputra Universitas Pembangunan Jaya, Tanggerang Selatan, Indonesia
  • Cahyono Budy Santoso * Mail Universitas Pembangunan Jaya, Tanggerang Selatan, Indonesia
  • (*) Corresponding Author
Keywords: Data Warehouse; Business Intelligence; Knowledge Discovery in Database; K-Means Clustering; Food Crop Productivity

Abstract

The productivity of food crops between regions shows significant differences despite having large areas of planted and harvested areas. These inequalities reflect production patterns that are not yet well structured, which makes it difficult to analyze and make data-driven decisions. This research aims to evaluate the productivity of food crops using K-Means, based on planted area and harvest area and productivity, with the aim of overcoming irregular production patterns between regions and producing grouping patterns that are more systematic and easy to analyze. The method used is KDD (Knowledge Discovery in Database). Data obtained from the official https://jabar.bps.go.id/id and https://opendata.jabarprov.go.id/, website for the 2019-2022 period. The application of data warehouses with star schema yields a Tabel of productivity facts, and dimensions of years, crops and regions. Metric evaluation using the Davies-Bouldin Index showed good cluster quality information. This research resulted in the application of data warehouse, clustering using the K-Means algorithm with a Davies-Bouldin Index score of 0.419 with optimal k = 3, the amount of data in cluster 0 is 368 data, cluster 1 is 52 data, and cluster 2 is 12 data. To simplify interpretation and support data-driven decision making, business intelligence tools are used to display clustering results. The results of this research help provide strategic recommendations in increasing agricultural productivity of food crops in West Java through region-specific interventions.

Downloads

Download data is not yet available.

References

Agung, A., Daniswara, A., & Nuryana, I. K. D. (2023). Data Preprocessing Pola Pada Penilaian Mahasiswa Program Profesi Guru. 05, 97–100. https://doi.org/10.26740/jinacs.v5n01.p97-100

Aldi, M. A., Fatah, Z., Informasi, T., Ibrahimy, U., Timur, S. J., Informasi, S., Ibrahimy, U., & Timur, S. J. (2025). Implementasi K-Means Cluster Ing Dalam Pengelompokan Data Kunjungan. 2(1), 13–19. https://doi.org/10.69714/3hhfj353

Armayani, C., Fauzi, A., & Sembiring, H. (2021). Implementasi Data Mining Pengelompokan Jumlah Data Produktivitas Ubinan Tanaman Pangan Berdasarkan Jenis Ubinan Dengan Metode Clustering Dikab Langkat (Studi Kasus : Badan Pusat Statistik Langkat). Jurnal Informatika Kaputama (JIK), 5(1), 185–196. https://doi.org/10.59697/jik.v5i1.318

Barat, B. P. S. P. J. (2024). Potensi Pertanian Provinsi Jawa Barat: Menilik Kekuatan Komoditas Padi, Kopi, dan Domba. https://share.google/mjR9ZM9dosbFuT772

Fauzi, R. A., Rohana, T., Nurlaelasari, E., & Wahiddin, D. (2025). Journal of Computer Networks , Architecture and High Performance Computing Bitcoin Price Prediction Using Long Short Term Memory Journal of Computer Networks , Architecture and High Performance Computing. 7(3), 659–671. https://doi.org/10.47709/cnahpc.v7i3.5945

Ghita, F., & Trisminingsih, R. (2021). Pengujian Data Warehouse SOLAP untuk Komoditas Pertanian Indonesia. Jurnal Ilmu Komputer Dan Agri-Informatika, 8(1), 42–56. https://doi.org/10.29244/jika.8.1.42-56

Hafizah, A. S., Zulham, & Eka, M. (2024). Analisis Menggunakan Algoritma Fp-Growth Untuk Mencari. 18, 1386–1400. https://doi.org/10.46576/wdw.v18i4.5204

Heru Stiawan, M Najibuloh Muzzaki, Sucipto, Anita Sari Wardani, Rina Firliana, M Iqbal Khalid, Adhi Wicak Milbar Gamas, & Shandy Arshad Busro. (2022). Model Visualisasi Informasi Dashboard Pada Pemetaan Tanaman Obat Dan Langka Kabupaten Kediri Menggunakan Microsoft Power Bi. Jurnal Informatika Teknologi Dan Sains, 4(4), 366–371. https://doi.org/10.51401/jinteks.v4i4.2056

Komul, M. P. (2025). Pemanfaatan Data Warehouse dalam Mengatasi Tantangan Pengelolaan Informasi di Manajemen Klinik. 26(1), 78–86. https://doi.org/10.37817/tekinfo.v26i1.4684

Kurniawan Hidayat, M., & Fitriana, R. (2022). Penerapan Sistem Intelijensia Bisnis Dan K-Means Clustering Untuk Memantau Produksi Tanaman Obat. Jurnal Teknologi Industri Pertanian, 32(2), 204–219. https://doi.org/10.24961/j.tek.ind.pert.2022.32.2.204

Marvaro, E., & Sefina Samosir, R. (2021). Penerapan Business Intelligence dan Visualisasi Informasi di CV. Mitra Makmur Dengan Menggunakan Dashboard Tabelau. KALBISCIENTIA Jurnal Sains Dan Teknologi, 8(2), 37–46. https://doi.org/10.53008/kalbiscientia.v8i2.197

Mauliadi, R. (2022). Jurnal Informatika Ekonomi Bisnis Data Mining Menggunakan Algoritma K-Means Clustering dalam Analisis Tingkat Potongan Harga terhadap Harga Jual Sepeda Motor Honda. 4, 7–9. https://doi.org/10.37034/infeb.v4i4.156

Nafi, K., Sholehah, R., & Rahim, N. (2024). Unveiling Insights : A Knowledge Discovery Approach to Comparing Topic Modeling Techniques in Digital Health Research. 8(1), 111–125. https://doi.org/10.29407/intensif.v8i1.22058

Pratiwi, H., Purno, A., Teknik, F., Widyatama, U., Kidul, C., & Bandung, K. (2022). Implementasi Algoritma K-Means Untuk Mengklaster. 6(1), 39–48. https://doi.org/10.35145/joisie.v6i1.2252

Prayitno, G. P. (2020). Ketahanan Pangan Kabupaten/Kota Provinsi Jawa Barat. Agribusiness Journal, 14(1). https://doi.org/10.15408/aj.v14i1.16320

Purba, S. F., Yulianti, A., Raphael, Y., & Khotimah, H. (2023). Determinan Kesejahteraan Petani Tanaman Pangan di Provinsi Jawa Barat. Jurnal Ilmu Pertanian Indonesia, 29(1), 59–67. https://doi.org/10.18343/jipi.29.1.59

Saputra, A. K., Laksitowening, K. A., Herdiani, A., & Telkom, U. (2025). Performance Analysis Of Extract , Transform , And Load Methods For Business Intelligence In E-Learning Systems Using Pentaho. 6(1). https://doi.org/10.52436/1.jutif.2025.6.1.4173

Virantika, E., Kusnawi, K., & Ipmawati, J. (2022). Evaluasi Hasil Pengujian Tingkat Clusterisasi Penerapan Metode K-Means Dalam Menentukan Tingkat Penyebaran Covid-19 di Indonesia. Jurnal Media Informatika Budidarma, 6(3), 1657. https://doi.org/10.30865/mib.v6i3.4325

Wijayanto, S., & Yoka Fathoni, M. (2021). Pengelompokkan Produktivitas Tanaman Padi di Jawa Tengah Menggunakan Metode Clustering K-Means. Jupiter, 13(2), 212–219. https://doi.org/10.5281/3918.jupiter.2021.10

Yufita, A., Kurniawan, R., Wijaya, A. Y., & Suprapti, T. (2025). Optimalisasi Klasterisasi Tenaga Kesehatan Menggunakan K-Means dan Davies Bouldin Indexs. https://doi.org/10.20961/ijai.v9i2.96645


Bila bermanfaat silahkan share artikel ini

Berikan Komentar Anda terhadap artikel Pemetaan Pola Produktivitas Tanaman Pangan Menggunakan Data Warehouse dan K-Means Clustering

Dimensions Badge
Article History
Published: 2026-03-31
Abstract View: 35 times
PDF Download: 41 times
Issue
Section
Articles