Predictive Analytics for Sales Forecasting at Ono Cafe Using Linear Regression and Business Intelligence Dashboard

View at publisher Summarise with VIRAT
Authors: Danial Shah Iman Bin Mohamad Noor Khairul Azhillah, Arifah Fasha Rosmani
Cited by: 0
References: 14

Summary

No summary yet. VIRAT can read this paper and write a plain-language summary of its aim, methods, key findings and limitations.

Summarise with VIRAT Free to try with your Science Catalogs account.

Abstract

This study addresses the lack of systematic, datadriven sales forecasting practices among small food and beverage (F&B) enterprises, using Ono Café as the case context. Many SMEs continue to rely on manual judgment and intuition, resulting in inconsistent inventory planning and limited operational foresight. To mitigate these challenges, this study develops a predictive analytics framework using linear regression to forecast monthly sales based on historical data from 2023–2024. The research fills a gap in existing literature by exploring underexplored advanced forecasting tools in small food and beverage (F&B) businesses, despite their proven benefits in larger retail environments. Using RapidMiner, multiple regression models were tested across three data split configurations (70/30, 80/20, 90/10), with the 80/20 split demonstrating the strongest predictive performance (RMSE = 172.679, MAE = 125.279, R2= 0.991). A Power BI dashboard was subsequently deployed to provide managers with actionable insights through interactive visualizations. The findings demonstrate the practical value of integrating predictive modeling and business intelligence to enhance decision-making, operational efficiency, and strategic planning in F&B SMEs.

Fields of Study & Subjects

Forecasting Techniques and Applications Big Data and Business Intelligence Data Mining and Machine Learning Applications

Publication details

Journal / source
International Conference on Cognitive Systems and Computer Interaction (ICoSCI)
Pages
1–5
Publication date
15 January 2026
Language
EN