International Journal of Academic Research in Business and Social Sciences

search-icon

Market Basket Analysis for Sales Transaction in Shopping Stores

Open access

Mohd Noor Azam Nafi, Azni Sharlina Zakaria, Nur Izzati Mohamad Arif, Siti Nurhafizah Mohd Shafie, Nasuhar Ab. Aziz, Omar Kairan

Pages 901-912 Received: 02 Dec, 2022 Revised: 05 Jan, 2023 Published Online: 07 Feb, 2023

http://dx.doi.org/10.46886/IJARBSS/v13-i2/10169
Market Basket Analysis (MBA) system is a widely used technique among marketers, especially for undirected data mining analysis. MBA is also known as product association analysis and the outcome of this analysis is called association rules. The outcome can be used to schedule marketing or advertising strategies and design catalogs for different shop layouts. Discovering the pattern from the customer's buying habits in the shopping stores was collected in their buying transaction. This study aims to compare the item purchased by the respondents between Store A and Store B and to find out the most potential products that customers have bought along with a specific category of products. Convenience non-probability sampling was involved with structured questionnaires of items in store was collected to analyze data. Association analysis was used by analyzing the result from support, confidence, and lift. The findings showed that there are 13 interesting rules of association revealed in this study. Moreover, the result also found that most products that were purchased together are tissues, condiments, instant food, cooking oil, meat, biscuits, dry goods, beverages, and cleaning products.
Abdulsalam, S. O., Adewole, K. S., Akintola, A. G., & Hambali, M. A. (2014). Data mining in market basket transaction: An association rule mining approach. International Journal of Applied Information Systems (IJAIS), 7(10), 15-20.
Andrews, R. L., & Currim, I. S. (2002). Identifying segments with identical choice behaviors across product categories: An intercategory logit mixture model. International Journal of Research in Marketing, 19(1), 65-79.
Annie, L. C. M., & Kumar, A. D. (2012). Market basket analysis for a supermarket based on frequent itemset mining. International Journal of Computer Science Issues (IJCSI), 9(5), 257. https://doi.org/10.1016/S0167-8116(02)00048-4.
Ayu, S. K., Surjandari, I., & Zulkarnain, Z. (2018, July). Mining association rules in seasonal transaction data. In 2018 5th International Conference on Information Science and Control Engineering (ICISCE) (pp. 321-325). IEEE. https://doi.org/10.1016/10.1109 /ICISCE.2018.00074
Cheung, D. W. L., Fu, A. W. C., & Han, J. (1994). Knowledge discovery in databases: A rule-based attribute-oriented approach. In International Symposium on Methodologies for Intelligent Systems (pp. 164-173). Springer, Berlin, Heidelberg. Available at https://link.springer.com/chapter/10.1007/3-540-58495-1_17
Chib, S., Seetharaman, P. B., and Strijnev, A. (2002), "Analysis of multi-category purchase incidence decisions using IRI market basket data", Advances in Econometrics (Advances in Econometrics, Vol. 16), Emerald Group Publishing Limited, Bingley, pp. 57-92. https://doi.org/10.1016/S0731-9053(02)16004-X
Zadeh, H. A., Schiller, S., & Duffy, K. (2016). Teaching Analytics: A Demonstration of Association Discovery with SAS Enterprise Miner. Available at https://web.archive.org /web/20220803134744id_/https://aisel.aisnet.org/cgi/viewcontent.cgi?article=1264&context=amcis2016
INN, T. (2017). No room for large hypermarkets now. [online] The Star Online. Available at: https://www.thestar.com.my/news/nation/2017/04/30/no-room-for-large-hypermarkets-now-tesco-ceo-they-are-no-longer-feasible
Kaur, M., & Kang, S. (2016). Market Basket Analysis: Identify the changing trends of market data using association rule mining. Procedia computer science, 85, 78-85.
Khattak, A. M., Khan, A. M., Lee, S., & Lee, Y. K. (2010). Analyzing association rule mining and clustering on sales day data with xlminer and weka. International Journal of Database Theory and Application, 3(1), 13-22.
Kim, H. K., Kim, J. K., & Chen, Q. Y. (2012). A product network analysis for extending the market basket analysis. Expert Systems with Applications, 39(8), 7403-7410. https://doi.org /10.1016/j.eswa.2012.01.066
Kurniawan, F., Umayah, B., Hammad, J., Nugroho, S. M. S., & Hariadi, M. (2018). Market Basket Analysis to identify customer behaviours by way of transaction data. Knowledge Engineering and Data Science, 1(1), 20. http://doi.org/10.17977/um018v1i12018p20-25
Linoff, G. S., & Berry, M. J. (2011). Data mining techniques: for marketing, sales, and customer relationship management. John Wiley & Sons.
Raorane, A. A., Kulkarni, R. V., & Jitkar, B. D. (2012). Association rule–extracting knowledge using market basket analysis. Research Journal of Recent Sciences ISSN, 2277, 2502.
Setiawan, A., Budhi, G. S., Setiabudi, D. H., & Djunaidy, R. (2017). Data mining applications for sales information system using market basket analysis on stationery company. In 2017 International Conference on Soft Computing, Intelligent System and Information Technology (ICSIIT) (pp. 337-340). IEEE. https://doi.org/10.1109/IC SIIT.2017.39
The Star Online. (2019). Supermarkets and hypermarkets in Malaysia going through consolidation. [online] The Star Online. Available at: https://www.thestar.com.my/ business/business-news/2019/09/17/supermarkets-and-hypermarkets-in-malaysia-going-through-consolidation
Videla-Cavieres, I. F., & Rios, S. A. (2014). Extending market basket analysis with graph mining techniques: A real case. Expert Systems with Applications, 41(4), 1928-1936. https://doi.org/10.1016/j.eswa.2013.08.088