IDENTIFYING CUSTOMER BUYING PATTERNS USING MARKET BASKET ANALYSIS

This research project focuses on the design and development of a web-based Point of Sale (POS) application that incorporates advanced analytical techniques, specifically Market Basket Analysis with the Apriori algorithm and the Association Rule method. The primary objective of this web-based POS system is to empower retailers in managing their sales transactions efficiently and gaining valuable insights into customer purchasing behavior. The web-based POS application is multifaceted, offering features such as sales transaction recording, product inventory management, and customer data tracking. What sets it apart is the integration of the Apriori algorithm and Association Rule method, which enable the system to analyze and understand customer purchasing patterns. It identifies strong product associations and establishes rules that support intelligent decision-making for businesses. The advantages of Market Basket Analysis are substantial. Retailers can identify relevant purchase patterns, such as frequently co-purchased products or cross-selling opportunities. This information can be used to enhance marketing strategies, optimize product placement in stores, and create bundled product offerings, ultimately boosting sales and revenue. By analyzing transaction data and recognizing patterns, retailers can streamline their operations, minimize wastage, and allocate resources more effectively. In summary, this research project showcases the transformative potential of integrating Market Basket Analysis, the Apriori algorithm, and the Association Rule method into web-based POS systems. By doing so, retailers can enhance operational efficiency, boost sales, and improve customer satisfaction, ultimately leading to more successful and competitive businesses in the retail sector.

Market Basket Analysis (MBA) is a crucial technique used in the field of data mining to understand consumer purchasing patterns. The importance of advertisement in an MBA has been widely acknowledged as a key factor in influencing consumer behavior. With the advent of technology, MBA is undergoing a paradigm shift, with new tools and techniques being developed to improve its accuracy and efficiency. This research paper focuses on the various techniques used in MBA, the role of advertisement in MBA, and the impact of technology on the improvement of MBA. The paper discusses the various algorithms and data mining techniques used in MBA and their advantages and disadvantages. Additionally, it analyzes the importance of advertisement in MBA, its impact on consumer behavior, and the role of technology in enhancing MBA. The paper concludes by highlighting the potential of technology in revolutionizing the MBA field, providing more accurate and efficient results, and ultimately improving business outcomes.

Culture Coffee MSME is one of the MSMEs engaged in the culinary field and is experiencing business competition. A marketing strategy is needed with the right decision-making process so that the business can survive and excel. UMKM Culture Coffee uses a point of sales application to accommodate the transaction process and record transactions. Historical customer data can be processed into a basis for decision making for marketing strategies that effectively increase sales. However, the transaction data has not been used optimally. There is a need to analyze historical customer data that can generate information to form marketing strategies. Market Basket Analysis (MBA) is one of the methods in data mining used in knowing products that tend to be purchased together by customers known as Association Rule. Association rules produce products in the form of packages or bundling which are used as marketing strategies. The marketing strategy obtained is supported by data visualization which contains information from the data. Apriori algorithm is used to generate association rules. The result of this research is an association rule on the historical data of MSME Culture Coffee customer purchases. Based on these rules, recommendations for selling menu packages to customers can be given. The purpose of this research is to find customer purchasing patterns which are used as the basis for decision making in determining menu sales. The results showed 2 product packages, namely, nuggets and french fries with sausages and french fries with a support and confidence value of 12.5% and 37.6% with 10.8% and 29% respectively. The results of this study can be used as a basis for the sales and marketing strategy of Culture Coffee MSMEs to increase business revenue.

Analysis of Transaction Database Using Apriori Algorithm. This study examines the use of the Apriori algorithm for analysing transaction databases. The Apriori algorithm is a fundamental technique in data mining that allows for the efficient discovery of frequent patterns and association rules in large datasets. The Apriori algorithm employs a two-step approach. Initially, it identifies frequent items in the database based on a user-defined minimum support threshold. Subsequently, it generates association rules that describe relationships between these frequent items based on metrics such as confidence and lift. This paper provides an in-depth explanation of the Apriori algorithm, emphasizing its strengths and limitations. Additionally, it presents various applications of the Apriori algorithm in real-world scenarios, such as shopping cart analysis, cross-selling and upselling, and customer segmentation. The significance of this study lies in its comprehensive analysis of the Apriori algorithm and its practical relevance in diverse data mining tasks. It serves as a valuable resource for researchers, practitioners, and anyone seeking to understand the fundamentals and applications of association rule mining. Keywords: Datamining, OLTP, Apriori algorithm, Item sets and Market Basket Analysis

Market basket analysis (MBA) aims to discover purchasing patterns and item associations from customer transaction data. A major drawback of current techniques for MBA is a lack of quantitative metrics to measure the real value associated with basket items. This paper addresses this gap by deriving a practical game-theoretic measure for MBA based on the Shapley value of cooperative games, which we call Shapley value index for MBA (SIMBA). The SIMBA of an item represents the average revenue it earns, including its influence on the revenue earned from sales of other items. A significant challenge when applying Shapley value-inspired approaches in practical domains is the exponential complexity of Shapley value computation. However, for the MBA domain, we show that SIMBA admits a scalable exact computation method that does not require sampling or other approximations. Specifically, a characteristic function for the MBA game is constructed so that the transaction dataset input corresponds to the game’s Harsanyi dividends. The relationship between Harsanyi dividends and the Shapley value is then exploited to efficiently compute SIMBA. This approach scales linearly in the number of transactions, making SIMBA a feasible approach for quantitative MBA. SIMBA can be used to screen conventional MBA techniques, such as association rules, to identify significant rules based on the items’ cross-selling capacity. This combination of existing MBA methods and SIMBA will generate rules based not only on frequency of co-occurrence, but also on the significance of the items. We demonstrate the working of the algorithm by analyzing openly available transaction data from an online retail store. To the best of our knowledge, this is the first time Shapley value is used in this way to solve market basket analyses of a practical size.

Market basket analysis may be a technique identify the association between couple’s products purchased jointly and identify cases. Scene an occurrence is when two or more things happening. Market basket analysis makes rules if-then, scenario for instance, if an item purchased a and b will likely. bought items rule is probability in nature or, in other words, they are available from the incident. In observation the frequency is that the proportion of a basket of things which will be employed interesting. Rule, price, product placement and various varieties of cross-selling strategy. In order to create it easier to grasp, think in terms of market research handbasket in a very supermarket. Market basket analysis taking data on the transactions containing an inventory of all items that bought by customers in a very purchase. The technique is ascertaining the relations which product bought on other products. This relationship then wont to construct the containing the if-then items purchased. Market basket analysis also called a rule association or analysis affinity, learning may be a technique data processing can be used in numerous fields, as education, marketing, informatics and science. The aim is to include retailer’s awareness of buyers’ actions in order for the retailers with knowledge about the actions of purchasers, which will allow the tailor to make the right choices. All of the numerous market basket algorithms available to try to do. Algorithms, whose current work is on statics and which did not catch data changes in time, but algorithms not only intended to mine static information, but also provided new ways of calculating modifications on paper-listed association processing rules, and provide new algorithms that could stimulate market engagement and encourage up-selling.

10 years ago in India, any retail focused on making the products available in the stores and help customers buy the same when they walked in. Today, with the availability of the Internet, smart phones, and tablets, the patterns of customer buying have changed. There are numerous apps and websites available to help customers find the right product, recommendations, offers and discounts at the click of a button anywhere, anytime. The boundaries of retail channels are eroding - a customer could be standing in a retail store and accessing information and offers available on a website. In the current scenario, shoppers are not just shopping online, but are merging their online and offline shopping practices. There are multiple channels available to customers and they, at a time, access one channel while in the middle of another channel, like accessing a mobile app from a store. Brick and mortar (B&M) retailers also face a continuous challenge from e-commerce retailers, who work with lower overhead costs and provide the best deals to customers on every purchase. Considering the paucity of literature and lack of adequate research on omni-channel in the Indian context, and emergence of implementing a true omni - channel strategy as a tool for the full integration of the offline and the online customer shopping experience, this study was undertaken to analyze the factors which influenced the purchase intent of the customer in omni-channel buying. Both qualitative and quantitative research was carried out to arrive at the variables, and hypotheses and statistical packages such as Excel and SPSS were employed to test the hypotheses. From this study, it emerged that in an omni - channel approach to consumer purchase intent by an Indian consumer, for it to be impactful, it must be supported by systems that make the order status visible to customers. There is likely to be a better buyer response if the product codes of the product across channels are the same. Further location-based promotions positively impacted purchase intent. Companies would , therefore, benefit by adopting digital strategies that augment consistent product codes across channels, real time tracking of orders, and location based promotions based upon this research.

The halal retailing standard was first introduced by the Department of Malaysian Standards in 2010, known as MS 2400-3:2010. This standard was developed to protect Muslim consumers with the assurance of halal products. However, this management system needs to be more prescriptive on how the retail layout should be organized. In addition, this management also overrides the consideration of customer purchase behaviors or preferences. This research aims to design the layout of retail outlets by considering customer buying behavior and halal retailing standards. This study used the association rule-market basket analysis (AR-MBA) to determine the pattern of customer shopping behavior. One Islamic retail in Indonesia was used as a case study, where one-month sales transaction data was analyzed using AR-MBA. In addition, the activity relationship chart (ARC) was used to qualitatively analyze the placement of a product department by considering halal retailing standards. The results of AR-MBA obtained 21 associations among product departments, which were then used as a basis for proposed layouts while still considering the product characteristics and halal retailing standards. This research output provided a proposed product layout for retail outlets by considering quantitative factors (AR-MBA output) and qualitative factors (MS standard).

Market basket analysis is based upon the identification and analysis of purchasing patterns of the customers. The problem with market basket analysis is the varying needs of the customers with respect to seasons and time and so we need to perform it time and again. Another problem that arises while doing market basket analysis is with Apriori algorithm in which we need to find candidate sets and frequent item-sets time and again. In this paper, we are suggesting the use of artificial neural network technique to overcome these problems. We have used single layer feed-forward partially connected neural network technique for this purpose.

Knowledge discovery process from databases has gained importance recently. Finding and using the valuable and meaningful data which is hidden in large databases can have strategic importance for the organizations to gain competitive advantage. In this context, data mining methods are used to analyze customer purchasing data which is called “market basket analysis”. This analysis provides insight into the combination of products within a customer’s ‘basket’. In this study, a market basket analysis is conducted to identify a customer purchasing behaviour with Formal Concept Analysis (FCA). The FCA technique is one of the data mining methods using formal contexts and concept lattices. So, this method provides to create association rules based on lattices reflecting the relationships among the attributes in a database.

Retail businesses constantly seek data-driven insights to optimize sales strategies and enhance customer experience. Market Basket Analysis (MBA), a key data mining technique, uncovers hidden patterns in consumer purchasing behavior by identifying associations between products. This study employs the Apriori algorithm, a widely used approach for frequent itemset mining, to analyze transactional data and extract meaningful correlations. By leveraging real-world retail datasets, this research highlights how retailers can optimize product placement, crossselling, and promotional strategies. The findings demonstrate the effectiveness of Apriori in improving decision-making by providing actionable insights into consumer buying patterns. Additionally, the study discusses computational efficiency challenges and potential enhancements to the algorithm for large-scale data processing. The results offer valuable implications for retailers, enabling data-driven inventory management, pricing strategies, and personalized recommendations to enhance customer satisfaction and profitability.

The Market Basket Analysis is a method to analyze consumer spending patterns. The method use data that is retrieved from the transaction database, then processed to obtain information. Normally, the data transaction is obtained from supermarket or any retail business. The transaction database does not serve management any information because it only contains raw data. Therefore, market basket analysis is conducted to analyze consumer's patterns. In this study, the algorithm used is a hash-based algorithm. The algorithm reduces the number of candidate item-sets at the beginning. The results of this study found 2 frequent items that is being bought together, namely bread and butter with support value of 96. Then eggs, bread and butter with support value of 97. Based on the results of the implementation of hash-based algorithm and association rules, we can conclude that managers or any stakeholder is suggested to use promotion on the products above. Those items that are being frequently bought together need to be placed in the same shelf or near each other to accommodate consumer for convenient purposes.

Indonesia is an equatorial country that has abundant natural wealth from the seabed to the top of the mountains, the beauty of the country of Indonesia also lies in the mountains that it has in various provinces, for example in the province of West Nusa Tenggara known for its beautiful mountain, namely Rinjani. The increase in outdoor activities has attracted many people to open outdoor shops in the West Nusa Tenggara region. Sales transaction data in outdoor stores can be processed into information that can be profitable for the store itself. Using a market basket analysis method to see the association (rules) between a number of sales attributes. The purpose of this study is to determine the pattern of relationships in the transactions that occur. The data used is the transaction data of outdoor goods. The analysis used is the Association Rules with the Apriori algorithm and the frequent pattern growth (FP-growth) algorithm. The results of this study are formed 10 rules in the Apriori algorithm and 4 rules in the FP-Growth algorithm. The relationship pattern or association rule that is formed is in the item "if a consumer buys a portable stove, it is possible that portable gas will also be purchased" at the strength level of the rules with a minimum support of 0.296 and confidence 0.774 at Apriori and 0.296 and 0.750 at FP-Growth.

Over the past few years, a considerable number of studies have been made on market basket analysis. Market basket analysis is a useful method for discovering customer purchasing patterns by extracting association from stores? transaction databases. In many business of today, customer transactions can be made in many different geographical locations round the clock, especially after e-business have become prevalent. The traditional methods that consider only the association rules of an individual location or all locations as a whole are not suitable for such a multi-location environment. We design a novel and efficient algorithm for mining spatio-temporal association rules which have multi-level time and location granularities, in spatio-temporal databases. Experimental results have shown that our methods are efficient and we can find spatio-temporal association rules satisfactorily.

In a business, it takes effort to maximize profits. Among them by doing promotions. Minimarket Ulfamart has not done innovation in the form of promotion of frugal packages to customers. The precision of promotion can be learned from the database of a retail company primarily shopping patterns on products commonly purchased simultaneously. Information about inaccurate customer spending patterns results in inaccurate and efficient promotional policies. One of the most common attempts to acquire and explore customer spending patterns is to use data mining known as Knowledge Discovery in Database (KDD). One of the data mining techniques is the Association Rule which is a procedure in Market Basket Analysis. Market basketball is defined as an itemset purchased simultaneously by the customer in a transaction. Market basket analysis is a powerful tool for cross-selling strategies. A pattern is determined by two parameters, namely support (value of support) and confidence (value of certainty). The Frequent Pattern Growth (FP-Growth) algorithm is used to help find some association rules from the database by applying a Tree Tree structure or called FP-Tree. Implementation using RapidMiner to help find accurate patterns to get a combination of items that can be used as a frugal package.