Enhancing Sales Determination for Coffee Shop Packages through Associated Data Mining: Leveraging the FP-Growth Algorithm

Authors

  • Wahyuningsih Wahyuningsih Mercu Buana University of Yogyakarta, Indonesia
  • Putri Taqwa Prasetyaningrum Mercu Buana University of Yogyakarta, Indonesia
Pages Icon

DOI:

https://doi.org/10.51519/journalisi.v5i2.500

Keywords:

Association rules, associated data mining, ft-growth, decision-making

Abstract

The coffee shop business offers a diverse range of coffee and food options. However, customers often experience delays during transactions due to the extensive selection of menu items and combinations. This inconvenience not only discomforts new customers but also hampers their likelihood of returning, potentially impacting the overall business turnover. To address this issue, this study aims to establish association rules by combining the least and most popular menu items for the upcoming month. These rules will serve as a guideline for creating shopping packages that streamline the decision-making process. The FP-Growth algorithm is employed to analyze sales transaction data from January to March 2023, comprising 2,336 transactions in .csv format. Among the generated association rules, two rules stand out with the highest support and confidence values. The first rule exhibits a support value of 0.3% and a confidence of 70.0%, while the second rule showcases a support value of 0.4% and a confidence of 69.2%. By considering these two rules alongside the existing menu options, coffee shop owners can effectively curate shopping packages that cater to customer preferences. It is anticipated that these packages will elevate the quality of service, attract a greater number of customers, and subsequently enhance the overall business turnover.

Downloads

Download data is not yet available.

References

U. A. Rosyidah and H. Oktavianto, "Search for Patient Complaint Association Patterns Using the Association Rule Mining Technique," INFORMAL Informatics J., vol. 3, no. 1, p. 1, 2019, doi: 10.19184/isj.v3i1.5541.

Amrin Amrin, "Data Mining Using the Apriori Algorithm for Determining Fertilizer Purchase Pattern Association Rules," Paradigm, flight. vol. xix, no. 1, pp. 74–79, 2017, doi: 10.31294/p.v19i1.1836.

K. N. Wijaya, "Analysis of Shopping Cart Frequency Patterns With a Comparison of the Fp-Growth Algorithm (Frequent Pattern Growth) and Eclat in minimarkets," JATISI (Journal of Informal Technology and Information Systems), vol. 7, no. 2, pp. 364–373, 2020, doi: 10.35957/jatisi.v7i2.380.

M. Kadafi, “Application of the FP-Growth Algorithm to Find Borrowing Patterns for Library Books at UIN Raden Fatah Palembang,” Matics, vol. 10, no. 2, p. 52, 2019, doi: 10.18860/mat.v10i2.5628.

T. A. Djabalul Lael and D. A. Pramudito, “Use of Data Mining for The Analysis of Consumer Purchase Patterns with The Fpgrowth Algorithm on Motor Spare Part Sales Transactions Data”, IAIC Transactions on Sustainable Digital Innovation (ITSDI), vol. 4, no. 2, pp. 128–136, Mar. 2023.

M. Subianto, F. AR, and M. Hijriyana P., "The pattern of borrowing books at the Syiah Kuala University library uses the Eclat Algorithm," Berk. Library Science. and Inf., vol. 14, no. 1, p. 35, 2018, doi: 10.22146/bip.32089.

I. G. A. Indrawan, M. Sudarma, and L. Jasa, "Implementation of the FP-Growth Algorithm with Closure Tables for Finding Frequent Itemsets in Shopping Carts," Maj. Ilm. Teknol. Elektro, vol. 17, no. 2, p. 199, 2018, doi: 10.24843/mite.2018.v17i02.p06.

E. Elwani, "Determination of Association Rules in Book Loan Transactions Using the FP-Growth Algorithm," Informatika, vol. 9, no. 1, p. 15, Sep. 2018, doi: 10.36723/juri.v9i1.59.

D. Supriyadi, "Implementation of Association Rule Mining Based on Frequent Pattern Growth Algorithms for Sales Recommendations," JATISI (Journal of Informal Technology and Information Systems), vol. 7, no. 2, pp. 135–148, 2020, doi: 10.35957/jatisi.v7i2.339.

H. Rasyidah, "Analysis of Book Borrowing Patterns in Libraries to Organize Book Layout Using Fp-Growth Algorithm," Techno Xplore J. Ilmu Comput. dan Technol. Inf., vol. 6, no. 1, pp. 27–35, 2021, doi: 10.36805/technoxplore.v6i1.825.

I. Pratama and P. T. Prasetyaningrum, "Mapping Student Profiles to Improve Higher Education Promotion Strategies Using Predictive Apriori," J. Exploratory Inform., vol. 10, no. 2, pp. 159–166, 2021, doi: 10.30864/explora.v10i2.505.

K. Rahayu and P. T. Prasetyaningrum, “Sales Prediction on the Diamond Cell Counter Using Autoregresive Integrated Moving Average (ARIMA) Method,” J. Inf. Syst. Informatics, vol. 5, no. 1, pp. 271–284, 2023, doi:10.51519/journal.v5i1.450.

H. Maulidiya and A. Jananto, "Data Mining Association Using the Apriori Algorithm and FP-Growth as a Basis for Considerations in Determining Basic Food Packages," Proceeding SENDIU 2020, vol. 6, p. 36–42, 2020.

A. R. Wibowo and A. Jananto, "Implementation of the Data Mining Method of the FP-Growth Association Algorithm in Retail Companies," Inspire. J. Technol. inf. and Commun., vol. 10, no. 2, p. 200, 2020, doi: 10.35585/inspir.v10i2.2585.

E. Munanda and S. Monalisa, "Application of the Fp-Growth Algorithm on Sales Transaction Data for Layout Determination," J. Ilm. Engineering and Management. Sist. inf., vol. 7, no. 2, pp. 173–184, 2021.

Downloads

Published

2023-05-29

Issue

Vol. 5 No. 2 (2023): Journal of Information Systems and Informatics

Section

Articles

License

Authors Declaration

  1. The Authors certify that they have read, understood, and agreed to the Journal of Information Systems and Informatics (JournalISI) submission guidelines, policies, and submission declaration. The submission has been prepared using the provided template.
  2. The Authors certify that all authors have approved the publication of this manuscript and that there is no conflict of interest.
  3. The Authors confirm that the manuscript is their original work, has not received prior publication, is not under consideration for publication elsewhere, and has not been previously published.
  4. The Authors confirm that all authors listed on the title page have contributed significantly to the work, have read the manuscript, attest to the validity and legitimacy of the data and its interpretation, and agree to its submission.
  5. The Authors confirm that the manuscript is not copied from or plagiarized from any other published work.
  6. The Authors declare that the manuscript will not be submitted for publication in any other journal or magazine until a decision is made by the journal editors.
  7. If the manuscript is finally accepted for publication, the Authors confirm that they will either proceed with publication immediately or withdraw the manuscript in accordance with the journal’s withdrawal policies.
  8. The Authors agree that, upon publication of the manuscript in this journal, they transfer copyright or assign exclusive rights to the publisher, including commercial rights

How to Cite

[1]
W. Wahyuningsih and P. T. Prasetyaningrum, “Enhancing Sales Determination for Coffee Shop Packages through Associated Data Mining: Leveraging the FP-Growth Algorithm”, journalisi, vol. 5, no. 2, pp. 758–770, May 2023, doi: 10.51519/journalisi.v5i2.500.

Most read articles by the same author(s)