Utilizing association rule mining for enhancing sales performance in web-based dashboard application

Abstract

Data is increasingly recognized as a valuable asset for generating new insights and information. Given the importance of data, businesses must always look for ways to get more value from data generated from sales transactions. In data mining, association rule mining is a good standard technique and is widely used to find interesting relationships in databases. Association rule is closely related to market basket analysis to find items that often appear together in one transaction. This study proposes the frequent pattern growth (FP-Growth) algorithm in finding association rules on sales transaction data. Our methodology includes dataset preparation for modeling, evaluation of model performance, and subsequent integration into a web-based platform. We conducted a comparative analysis of the FP-Growth algorithm against the Apriori algorithm, finding that FP-Growth outperformed Apriori in efficiency. Using the same dataset and constraint level, both algorithms produce the same number of frequent itemsets. However, in terms of computation time, FP-Growth excels by taking 2.89 seconds while Apriori takes 5.29 seconds. We integrated trained FP-Growth algorithm into a web-based dashboard application using the streamlit framework. This system is anticipated to simplify the process for businesses to identify customer purchasing patterns and improve sales.