The data has emerged as a key tool for businesses in the food and beverage sector to understand customer purchasing behaviour and optimize their marketing efforts. Noreh and Ngopi currently make menu recommendations and cross selling primarily based on staff experience and manual observation, which restricts the value of sales transaction data for business decision making. So, this study aimed to find the existing business processes and challenges of menu recommendation and cross selling strategies, apply Market Basket Analysis method to find interesting menu associations and create an interactive dashboard to present the analysis results. The study used the Cross-Industry Standard Process for Data Mining (CRISP-DM) framework which consists of the phases of Business Understanding, Data Understanding, Data Preparation, Modelling, Evaluation, and Deployment. Three experiments were conducted using minimum support and confidence of 0.01 (1%) and 0.2 (20%) for experiment 1, 0.02 (2%) and 0.4 (40%) for experiment 2 and 0.04 (4%) and 0.5 (50%) for experiment 3. Resulting to a maximum support, confidence and lift of 0.057 (0.57%), 0.53 (0.53%) and 2.72. Both algorithms were found to be able to identify useful patterns of customer menu selection. On the other hand, although there were some differences, FP-Growth was still faster in all cases. In conclusion, the study shows that Market Basket Analysis is a useful data-driven approach to assist in menu recommendation and cross-selling in Noreh and Ngopi by using meaningful association analysis and Power BI dashboard. Going forwards, larger and longer transaction data sets and including customer demographic data can be used to enhance the accuracy of recommendations and analytical power.
| Item Type: | Student Project |
|---|---|
| Creators: | Creators Email / ID Num. Amir, Anisah Maisarah 2023436584 |
| Contributors: | Contribution Name Email / ID Num. Advisor Abdul Hamid, Nor Hasnul Azirah hasnulazirah@uitm.edu.my |
| Subjects: | H Social Sciences > HF Commerce > Marketing > Marketing research. Marketing research companies. Sales forecasting H Social Sciences > HF Commerce > Consumer behavior. Consumers' preferences. Consumer research. Including consumer profiling H Social Sciences > HF Commerce > Customer services. Customer relations |
| Divisions: | Universiti Teknologi MARA, Terengganu > Kuala Terengganu Campus > Faculty of Computer and Mathematical Sciences |
| Programme: | Bachelor of Information Systems (Hons.) Business Computing |
| Keywords: | Market basket analysis, Menu recommendation, Cross-selling |
| Date: | 2026 |
| URI: | https://ir.uitm.edu.my/id/eprint/149499 |
149499.pdf
