A Hybrid Approach Using K-Means and Apriori Algorithms for Marketing Recommendation Systems in the Café Industry

Kezia Elice Yulianto; Indra Maryati

doi:10.34148/teknika.v15i1.1461

Authors

Kezia Elice Yulianto Information Systems, School of Information Technology, Universitas Ciputra, Surabaya, East Java, Indonesia
Indra Maryati Information Systems, School of Information Technology, Universitas Ciputra, Surabaya, East Java, Indonesia

DOI:

https://doi.org/10.34148/teknika.v15i1.1461

Keywords:

Apriori, CRISP-DM, F&B Transaction, K-Means Clustering, Marketing Strategy

Abstract

Many food and beverage (F&B) businesses struggle to survive because of a lack of understanding of their market and customer behavior. Therefore, this study aims to analyze transaction data using K-Means Clustering and Apriori algorithms to identify customer purchasing patterns and provide actionable insights for a café. This research applies the CRISP-DM method, including six primary phases: business understanding, data understanding, data preparation, modeling, evaluation, and deployment. K-Means reveals that products can be grouped into three main clusters, namely the low-demand products, premium products, and best-selling products. Furthermore, the association rule mining successfully indicates six meaningful correlations among products, with the strongest lift value of 5.22 was found between Piccolo Latte and Extra Oatmilk. These findings are transformed into actionable insights, such as recommendations for implementing bundling and up-selling. An interview with the business owner validates that the recommendations are considered applicable to the current business operations. This proves that the integration of K-Means and Apriori algorithms can be used to design effective data-driven marketing strategies for an F&B business.

Downloads

Download data is not yet available.

References

[1] Badan Pusat Statistik Indonesia, “Statistik Penyediaan Makanan dan Minuman 2023,” 2024.

[2] A. G. Henryanto, H. Hanifah, T. S. Kaihatu, R. K. Hardjono, M. Cahyadin, and W. Hartono, “Digital Platform Capability and Strategic Agility: Uncovering Strategies to Strengthen Indonesian F&B SMEs Competitiveness,” Indonesian Journal of Business and Entrepreneurship, vol. 11, no. 3, p. 685, Sep. 2025, doi: 10.17358/ijbe.11.3.685.

[3] M. Isa, A. Praswati, and S. Zulaekah, “Factors Driving Sustainability of Food and Beverage Industries,” Jurnal Ilmiah Bidang Ilmu Ekonomi, vol. 19, no. 2, pp. 162–171, 2024, [Online]. Available: http://journal.umpo.ac.id/index.php/ekuilibrium

[4] G. Yılmaz Benk, B. Badur, and S. Mardikyan, “A New 360° Framework to Predict Customer Lifetime Value for Multi-Category E-Commerce Companies Using a Multi-Output Deep Neural Network and Explainable Artificial Intelligence,” Information (Switzerland), vol. 13, no. 8, Aug. 2022, doi: 10.3390/info13080373.

[5] K. A. Carroll, A. Samek, and L. Zepeda, “Consumer Preference for Food Bundles under Cognitive Load: A Grocery Shopping Experiment,” Foods, vol. 11, no. 7, Apr. 2022, doi: 10.3390/foods11070973.

[6] Jandrianto Patandianan, “Strategi Manajemen Pengelolaan Peluang Bisnis F&B Sebagai Upaya Mengatasi Permasalahan Ekonomi Keluarga dengan Pemanfaatan Teknologi Digital,” Jurnal Ilmiah Dan Karya Mahasiswa, vol. 2, no. 2, pp. 199–216, Mar. 2024, doi: 10.54066/jikma.v2i2.1710.

[7] A. M. Maulidya, S. Selfira, G. Sidabutar, and R. R. Al Hafiz, “Integrating K-Means Clustering and Apriori for Data Mining-Based Digital Marketing Strategy For Increasing UMKM: Study Case Stabat City,” Sinkron : Jurnal dan Penelitian Teknik Informatika, vol. 9, no. 4, pp. 3190–3196, Oct. 2025, doi: 10.33395/sinkron.v9i4.15299.

[8] J. Macqueen, “Some Methods for Classification and Analysis of Multivariate Observations,” in Proceedings of the Fifth Berkeley Symposium on Mathematical Statistics and Probability, Jan. 1967.

[9] F. A. Maresti, W. I. Rahayu, M. B. B. C. Lustin, and T. H. Pakpahan, “Implementasi K-Means Untuk Melakukan Segmentasi Produk Berdasarkan Data Transaksi Retail,” Jurnal Ilmiah Sains dan Teknologi, vol. 9, no. 1, Feb. 2025.

[10] S. Marselina, J. Haerul Jaman, and D. Ely Kurniawan, “Sales Analysis Using Apriori Algorithm in Data Mining Application on Food and Beverage (F&B) Transactions,” Journal of Applied Informatics and Computing (JAIC), vol. 7, no. 2, pp. 2548–6861, Jul. 2023, [Online]. Available: http://jurnal.polibatam.ac.id/index.php/JAIC

[11] A. Ivana and I. Maryati, “Implementation of Apriori Algorithm in Identifying Purchase Relationships at Bluder Cokro Pakuwon Mall,” Journal of Applied Informatics and Computing (JAIC), vol. 9, no. 2, p. 556, 2025, [Online]. Available: http://jurnal.polibatam.ac.id/index.php/JAIC

[12] R. Wirth and J. Hipp, “CRISP-DM: Towards a Standard Process Model for Data Mining.”

[13] H. Ar-Rasyid, A. Fitriansyah, J. Sari, and I. Ramadhan, “Sistem Rekomendasi Penjualan Cross-Selling Potensial Dengan Pendekatan Data Mining,” Jurnal Rekayasa Informasi Swadharma (JRIS), Jan. 2025.

[14] Amiruddin and R. Ishak, “Optimalisasi Seleksi Atribut K-Means Menggunakan Correlation Matrix pada Clustering Penyakit Pasien,” Jambura Journal of Electrical and Electronics Engineering, Jul. 2025.

[15] H. Supriyanto, M. Al Hafidz, A. C. Puspitaningrum, R. A. P. Firmansyah, and R. Zuhdi, “Klasterisasi Data Obat Farmasi Berdasarkan Jumlah Persediaan Dengan Menggunakan Metode K-Means,” Teknika, vol. 13, no. 3, pp. 361–369, Sep. 2024, doi: 10.34148/teknika.v13i3.987.

[16] R. Ishak, Nurmawanti, and Amiruddin, “Optimasi K-Means pada Clustering Penyakit Ibu Hamil Menggunakan Random Forest Optimization of K-Means in Disease Clustering of Pregnant Women Using Random Forest,” Jambura Journal of Electrical and Electronics Engineering, p. 41, Jan. 2024, doi: https://doi.org/10.37905/jjeee.v7i1.28374.

[17] L. E. Dendy and R. Tanamal, “Association Rule Mining for Truck Body Damage Pattern Analysis Using Apriori and CRISP-DM,” 2026. [Online]. Available: http://jurnal.polibatam.ac.id/index.php/JAIC

[18] T. Rahmawati, Y. Wilandari, and P. Kartikasari, “Analisis Perbandingan Silhouette Coefficient Dan Metode Elbow Pada Pengelompokkan Provinsi Di Indonesia Berdasarkan Indikator IPM Dengan K-Medoids,” Jurnal Gaussian, vol. 13, no. 1, pp. 13–24, Aug. 2024, doi: 10.14710/j.gauss.13.1.13-24.

[19] I. Wayan Supriana and L. Arida Ayu Rahning Putri, “Implementasi Algoritma Apriori sebagai Association Rule Learning untuk Mengidentifikasi Pola Item Dataset Penjualan,” Jurnal Buana Informatika, Apr. 2025.

[20] H. Indra, S. Saragi, and L. Putriana, “Analysis of the Effect of Up Selling and Cross Selling Sales Methods on the Brand Image of KFX UB Jaya I Pharmacy and its Impact on Purchasing Decisions,” International Journal of Science and Society, vol. 6, no. 1, p. 2024, 2024, [Online]. Available: http://ijsoc.goacademica.com