This study focuses on the application of Business Intelligence (BI) and predictive analytics to enhance the sales performance of a local food and beverage (F&B) business, Mee Udang Sepang, where sales recording is still manual and traditional reporting practices are used. Such practices make it challenging for a business to keep track of sales, customer demand, predict future sales, and make timely decisions about stock, employees, menu and promotions. Thus the objective of the study is to identify the business requirements, build sales prediction models and build an interactive dashboard to assist in decision making. The study uses the Cross-Industry Standard Process for Data Mining (CRISP-DM) as a structured framework, which starts from Business Understanding and ends with Deployment. Data on historical sales were gathered from the point-of-sale receipts and organized in Microsoft Excel. Data was then cleaned, transformed and prepared using various variables including total sales, quantity sold, sales per item, item popularity, payment method, customer activity, and information related to date. Using RapidMiner, two predictive models were built to predict the daily sales and the item sales performance, respectively: Linear Regression and Random Forest Regression. Mean Absolute Error (MAE), Root Mean Squared Error (RMSE) and R2 were used to evaluate the models. Random Forest achieved better results, recording an RMSE of 31.626, MAE of 24.129 and R2 of 0.925 for daily sales, and an RMSE of 0.373, MAE of 0.111 and R2 of 0.996 for item sales. Results presented in an interactive MS Power BI dashboard. In general, the study demonstrates that the use of BI and predictive analytics can enhance sales visibility, sales forecasting and operational planning, as well as data-driven decision making.
| Item Type: | Student Project |
|---|---|
| Creators: | Creators Email / ID Num. Mozainy, Muhammad Farhan Najwan 2023276674 |
| Contributors: | Contribution Name Email / ID Num. Advisor Mohamad Ghazali, Farah Muna farahmuna@uitm.edu.my. |
| Subjects: | H Social Sciences > HF Commerce H Social Sciences > HF Commerce > Customer services. Customer relations H Social Sciences > HF Commerce > Business societies > Selling |
| Divisions: | Universiti Teknologi MARA, Terengganu > Kuala Terengganu Campus > Faculty of Computer and Mathematical Sciences |
| Programme: | Bachelor of Information System (Hons.) Business Computing |
| Keywords: | Sales performance, Predictive analytics, Business intelligence |
| Date: | 2026 |
| URI: | https://ir.uitm.edu.my/id/eprint/149522 |
149522.pdf
