Firman Noor Hasan, Achmad Sufyan Aziz, Yos Nofendri
{"title":"Utilization of Data Mining on MSMEs using FP-Growth Algorithm for Menu Recommendations","authors":"Firman Noor Hasan, Achmad Sufyan Aziz, Yos Nofendri","doi":"10.30812/matrik.v22i2.2166","DOIUrl":null,"url":null,"abstract":"Existing transaction data is only recorded and stored as a sales transaction memorandum, so it has not been utilized optimally. The data is only stored and used as transaction history. The availability of a lot of data and having a pattern of sales transactions that are similar to MSME Cafe Over Limit will be utilized by using data mining science. This research uses the association rules method. Implementation of fp-growth to get item combinations. The purpose of this research is to make it easier for MSMEs to determine menu recommendations for customers. The fp-growth algorithm is used to process as many as 2038 transaction data with a minimum support value of 10%, while for a minimum confidence value of 50%. So that there are 3 rules, namely \"if you order Mariam chocolate cheese milk then the customer will order Kopsus Overlimit\", from this rule it will form a support value of 10.79%, using a confidence value of 54.19% and a lift ratio of 0.93. Furthermore \"if you order Kopsus Overlimit then you will order tofu at grandma's house\", from the rule it will produce a support value of 34.69%, with a specified confidence value of 59.76%, so the lift ratio value is 1.15. The last rule \"if you order tofu at grandma's house, the customer orders Kopsus Overlimit\", from the rule that occurs, the support value is 34.69%, with a confidence value of 66.7% and a lift ratio of 1.15. The results of the study found the two best rules, namely \"if the customer orders over-limit Kopsus, he will order tofu at grandma's house\" and \"if he orders tofu at grandma's house, the customer orders over-limit Kopsus\". Based on the results of the rules formed, it can be concluded that only two rules can be categorized as valid and can be used as a reference in food and beverage menu recommendations at MSME Cafe Over Limit. So the results of this study can be useful to be applied to MSMEs, especially in terms of menu recommendations.","PeriodicalId":364657,"journal":{"name":"MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer","volume":"15 12","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2023-03-31","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"MATRIK : Jurnal Manajemen, Teknik Informatika dan Rekayasa Komputer","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.30812/matrik.v22i2.2166","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 1
Abstract
Existing transaction data is only recorded and stored as a sales transaction memorandum, so it has not been utilized optimally. The data is only stored and used as transaction history. The availability of a lot of data and having a pattern of sales transactions that are similar to MSME Cafe Over Limit will be utilized by using data mining science. This research uses the association rules method. Implementation of fp-growth to get item combinations. The purpose of this research is to make it easier for MSMEs to determine menu recommendations for customers. The fp-growth algorithm is used to process as many as 2038 transaction data with a minimum support value of 10%, while for a minimum confidence value of 50%. So that there are 3 rules, namely "if you order Mariam chocolate cheese milk then the customer will order Kopsus Overlimit", from this rule it will form a support value of 10.79%, using a confidence value of 54.19% and a lift ratio of 0.93. Furthermore "if you order Kopsus Overlimit then you will order tofu at grandma's house", from the rule it will produce a support value of 34.69%, with a specified confidence value of 59.76%, so the lift ratio value is 1.15. The last rule "if you order tofu at grandma's house, the customer orders Kopsus Overlimit", from the rule that occurs, the support value is 34.69%, with a confidence value of 66.7% and a lift ratio of 1.15. The results of the study found the two best rules, namely "if the customer orders over-limit Kopsus, he will order tofu at grandma's house" and "if he orders tofu at grandma's house, the customer orders over-limit Kopsus". Based on the results of the rules formed, it can be concluded that only two rules can be categorized as valid and can be used as a reference in food and beverage menu recommendations at MSME Cafe Over Limit. So the results of this study can be useful to be applied to MSMEs, especially in terms of menu recommendations.
现有的交易数据仅作为销售交易备忘录记录和存储,因此没有得到最佳利用。数据仅作为事务历史记录存储和使用。大量数据的可用性和类似于MSME Cafe Over Limit的销售交易模式将通过使用数据挖掘科学加以利用。本研究采用关联规则方法。执行fp增长以获得道具组合。本研究的目的是使中小微企业更容易为客户确定菜单建议。fp-growth算法在最小支持值为10%,最小置信度为50%的情况下,可处理多达2038个事务数据。因此,有3条规则,即“如果您订购Mariam巧克力奶酪牛奶,那么客户将订购Kopsus Overlimit”,从这条规则中,它将形成10.79%的支持值,使用置信值54.19%和提升比0.93。更进一步,“如果你点了Kopsus Overlimit,那么你就会点奶奶家的豆腐”,从规则中产生的支持值为34.69%,指定置信度为59.76%,因此提升比值为1.15。最后一条规则“如果你在奶奶家点豆腐,顾客点Kopsus Overlimit”,从发生的规则来看,支持值为34.69%,置信度为66.7%,举升比为1.15。研究结果发现了两个最佳规则,即“如果顾客点超限Kopsus,他会在奶奶家点豆腐”和“如果他在奶奶家点豆腐,他会点超限Kopsus”。根据形成的规则的结果,可以得出只有两条规则可以被归类为有效规则,可以作为MSME Cafe Over Limit餐饮菜单推荐的参考。因此,本研究的结果可以应用于中小微企业,特别是在菜单推荐方面。