Analysis of Supermarket Product Purchase Transactions With the Association Data Mining Method

Norbertus Tri Suswanto Saptadi; Phie Chyan; Jeremias Mathias Leda

doi:10.29207/resti.v7i3.4844

Norbertus Tri Suswanto Saptadi Universitas Atma Jaya Makassar
Phie Chyan Universitas Atma Jaya Makassar
Jeremias Mathias Leda Universitas Atma Jaya Makassar

DOI: https://doi.org/10.29207/resti.v7i3.4844

Keywords: transaction data, association rules, data mining, supermarket management, decisions

Abstract

The development of business world is entering the era of big data. In meeting supermarkets' sales and purchase targets, the management needs to improve themselves in managing the goods available in the store. The research aims to determine the pattern of purchases that occur in a transaction, find out related and related products in supermarkets, and improve supermarket services to customers. The method applied uses the association rules approach to data mining. Several purchasing data from customers have been able to be analyzed by displaying a diagram as a visualization of the number of specified association rules. The processing results show a relationship above 90%: sugar and coffee with a confidence of 94.4%, shirts and trousers with a confidence of 93.4%, and sugar, milk, and coffee with a confidence of 92.0%. Decisions that can be taken by supermarket management in providing places and goods need to consider and follow product relationships and proximity based on the highest confidence value to provide services to customers effectively and efficiently.

Downloads

Download data is not yet available.

References

N. Bessis and C. Dobre, Big Data and Internet of Things : A Roadmap for Smart Environments.

K. Nagorny, P. Lima-monteiro, J. Barata, and A. W. Colombo, “Big Data Analysis in Smart Manufacturing : A Review,” pp. 31–58, 2017, doi: 10.4236/ijcns.2017.103003.

V. Pitoy, A. Tumbel, and M. Tielung, “Competitive Strategy Analysis in Document Solution Business Competition (Case Study at Pt. Astragraphia, Tbk Manado),” Effic. Sci. Period. J., vol. 16, no. 3, pp. 302–312, 2016.

N. F. Naini, Sugeng Santoso, T. S. Andriani, U. G. Claudia, and Nurfadillah, “The Effect of Product Quality, Service Quality, Customer Satisfaction on Customer Loyalty,” J. Consum. Sci., vol. 7, no. 1, pp. 34–50, 2022, doi: 10.29244/jcs.7.1.34-50.

C. Ortega-Rodríguez, A. Licerán-Gutiérrez, and A. L. Moreno-Albarracín, “Transparency as a key element in accountability in non-profit organizations: A systematic literature review,” Sustain., vol. 12, no. 14, 2020, doi: 10.3390/su12145834.

T. Suhaeni, “The Effect of Innovation Strategy on Competitive Advantage in Creative Industries (Case Study of MSMEs in Handicrafts in Bandung City),” J. Bus. Invest. Res., vol. 4, no. 1, p. 57, 2018, doi: 10.35697/jrbi.v4i1.992.

Y. Hernawati, N. P. Mulyadi, T. R. Lestari, and D. Faidz, “Evaluation of Finished Goods Stock Control System in Pt.Indocare Citra Pasifik Group Warehouse,” vol. 6, pp. 20–27, 2020.

Tiris Sudrartono, “The Effect of Pre Order Online Sales to Company Profits on PT. Aventama Hervent Solusindo Bandung,” J. Sos. Sci., vol. 1, no. 3, pp. 88–92, 2020, doi: 10.46799/jsss.v1i3.30.

C. A. Puspadev, “Raw Material Inventory Control System Using the Economic Order Quantity Method at Pizzahut Setiabudi,” Informatics Sci. J., vol. 9, no. 01, pp. 43–47, 2021, doi: 10.33884/jif.v9i01.3725.

D. N. Rorim Panday, “Inventory Management Evaluation And Inventory Forecast Using EOQ,” Syntax Lit., vol. 6, no. 1, p. 6, 2021.

L. Sholeha, S. Djaja, and J. Widodo, “The Influence of Service Quality on Customer Satisfaction at Ahass Sumber Jaya Maha Sakti, Rogojampi District, Banyuwangi Regency,” Econ. Educ. J. Sci. J. Educ. Econ. Soc. Sci., vol. 12, no. 1, p. 15, 2018, doi: 10.19184/jpe.v12i1.6465.

Taupik Ismail, “The Effect of Service Quality on Customer Satisfaction at the Indihome Gegerkalong Office in Bandung City,” MEA Sci. J. (Management, Econ. Accounting), vol. 5, no. 1, pp. 1124–1135, 2021.

W. Reinartz, N. Wiegand, and M. Imschloss, “The impact of digital transformation on the retailing value chain,” Int. J. Res. Mark., vol. 36, no. 3, pp. 350–366, 2019, doi: 10.1016/j.ijresmar.2018.12.002.

S. Agarwal, Data mining: Data mining concepts and techniques. 2014.

Parteek Bhatia, Data mining and data warehousing, vol. 47. 2019.

R. Turner, “How Does Governance Influence Decision Making on Projects and in Project-Based Organizations?,” Proj. Manag. J., vol. 51, no. 6, pp. 670–684, 2020, doi: 10.1177/8756972820939769.

M. Supriyamenon and P. Rajarajeswari, “A review on association rule mining techniques with respect to their privacy preserving capabilities,” Int. J. Appl. Eng. Res., vol. 12, no. 24, pp. 15484–15488, 2017.

T. Husain and N. Hidayati, “The Optimize of Association Rule Method for the Best Book Placement Patterns in Library: a Monthly Trial,” Teknokom, vol. 4, no. 2, pp. 53–59, 2021, doi: 10.31943/teknokom.v4i2.63.

X. Chen, B. Kassas, and Z. Gao, “Impulsive purchasing in grocery shopping: Do the shopping companions matter?,” J. Retail. Consum. Serv., vol. 60, no. February, p. 102495, 2021, doi: 10.1016/j.jretconser.2021.102495.

S. C. Hui and G. Jha, “Data mining for customer service support,” Inf. Manag., vol. 38, no. 1, pp. 1–13, 2000, doi: 10.1016/S0378-7206(00)00051-3.

A. Chailes, A. Hermawan, and D. Kurnaedi, “Application of the Data Mining Method to Determine Purchasing Patterns Using the Apriori and Fp-Growth Algorithms at Mukara Stores,” J. Algor, vol. 1, no. 2, pp. 1–8, 2020.

T. Desara and T. Hidayat, “Enrichment: Journal of Management is Licensed under a Creative Commons Attribution-NonCommercial 4.0 International License (CC BY-NC 4.0) Enrichment: Journal of Management Enhancing Repurchase Intention in Retail: the Role of Customer Satisfaction, Servic,” Enrich. J. Manag., vol. 12, no. 1, pp. 325–329, 2021.

H. Al Islami, T. Informatika, J. Raya, P. No, and T. Selatan, “Application of the Datamining Association Method Market Basket Analysis Using the Apriori Algorithm to Perform Pattern Analysis of Consumer Spending,” J. Artif. Intellegence Innov. Appl., vol. 1, no. 1, pp. 23–31, 2020, [Online]. Available: http://jurnal.fmipa.unmul.ac.id/index.php/exponensial/article/view/69.

J. P. van Wouwe, “A novel association rule mining approach using TID intermediate itemset Enhanced Reader.pdf.” .

M. Rajagukguk, “Implementation of Association Rule Mining to Determine Food Combination Patterns with the Apriori Algorithm,” J. Fasilkom, vol. 10, no. 3, pp. 248–254, 2020, doi: 10.37859/jf.v10i3.2308.