Q Mart Kuala Terengganu manages several retail product categories, including Food, Beverage, Household, Personal Care, and Bulk. However, its demand-planning process relied mainly on historical records, manual checking, and management experience, which may lead to inaccurate demand estimation, overstock, stock shortages, higher storage costs, and missed sales opportunities. Therefore, this project aimed to identify the current demand-planning process and related problems, implement predictive analytics for product demand forecasting by category, and visualise the results through an interactive Microsoft Power BI dashboard. The project followed the Cross-Industry Standard Process for Data Mining methodology, which consists of Business Understanding, Data Understanding, Data Preparation, Modelling, Evaluation, and Deployment. Historical sales and inventory data from 2023 and 2024 were prepared and analysed using Rapid Miner. Linear Regression, Random Forest, and ARIMA were applied to forecast product demand, while Linear Regression, Random Forest and ARIMA were compared using Root Mean Squared Error, Absolute Error, Relative Error, and Squared Correlation. The results showed that Linear Regression achieved the best overall performance, with an RMSE of 1933.386, an Absolute Error of 1445.875, a Relative Error of 5.53%, a Squared Correlation of 0.986, and a Derived Forecasting Accuracy of 94.47%. The forecast results indicated that Food recorded the highest predicted demand in 2025, while December was identified as the peak-demand month. The developed Power BI dashboard presented category performance, demand forecasts, top forecasted products, detailed monthly forecasts, inventory insights, and sales performance. Expert evaluation by three evaluators confirmed that the dashboard was generally functional, understandable, organised, and useful for supporting inventory decisions. Overall, this project provides Q Mart with a more structured and data-driven approach to demand planning. Future enhancements may include real-time data integration, additional forecasting variables, confidence intervals, safety-stock calculations, reorder alerts, and stock out warnings.
| Item Type: | Student Project |
|---|---|
| Creators: | Creators Email / ID Num. Yatiseman@Zaki, Nur Alia Nadira 2024264364 |
| Contributors: | Contribution Name Email / ID Num. Advisor Abdul Hamid, Nor Hasnul Azirah hasnulazirah@uitm.edu.my. |
| Subjects: | H Social Sciences > HF Commerce H Social Sciences > HF Commerce > Marketing > Management > Product management H Social Sciences > HF Commerce > Marketing > Marketing research. Marketing research companies. Sales forecasting |
| Divisions: | Universiti Teknologi MARA, Terengganu > Kuala Terengganu Campus > Faculty of Computer and Mathematical Sciences |
| Programme: | Bachelor of Information Systems (Hons.) Business Computing |
| Keywords: | Predictive analytics, Demand forecasting, Inventory management |
| Date: | 2026 |
| URI: | https://ir.uitm.edu.my/id/eprint/149648 |
149648.pdf
