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

  • Wahyuningsih Wahyuningsih Universitas Mercu Buana Yogyakarta, Indonesia
  • Putri Taqwa Prasetyaningrum Universitas Mercu Buana Yogyakarta, Indonesia
DOI: 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.

Published
2023-05-29
Abstract views: 2692 times
Download PDF: 1357 times
How to Cite
Wahyuningsih, W., & Prasetyaningrum, P. (2023). Enhancing Sales Determination for Coffee Shop Packages through Associated Data Mining: Leveraging the FP-Growth Algorithm. Journal of Information Systems and Informatics, 5(2), 758-770. https://doi.org/10.51519/journalisi.v5i2.500
Issue
Vol 5 No 2 (2023): Journal of Information Systems and Informatics
Section
Articles

Copyright (c) 2023 Journal of Information Systems and Informatics

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

  1. I certify that I have read, understand and agreed to the Journal of Information Systems and Informatics (Journal-ISI) submission guidelines, policies and submission declaration. Submission already using the provided template.
  2. I certify that all authors have approved the publication of this and there is no conflict of interest.
  3. I confirm that the manuscript is the authors' original work and the manuscript has not received prior publication and is not under consideration for publication elsewhere and has not been previously published.
  4. I 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. I confirm that the paper now submitted is not copied or plagiarized version of some other published work.
  6. I declare that I shall not submit the paper for publication in any other Journal or Magazine till the decision is made by journal editors.
  7. If the paper is finally accepted by the journal for publication, I confirm that I will either publish the paper immediately or withdraw it according to withdrawal policies
  8. I Agree that the paper published by this journal, I transfer copyright or assign exclusive rights to the publisher (including commercial rights)

Most read articles by the same author(s)