Sales Analytics Dashboard with ARIMA and SARIMA Time Series Model

• 發表在: 13th IEEE Symposium on Computer Applications and Industrial Electronics, ISCAIE 2023
• 主要作者: 2-s2.0-85165148256
• 格式: Conference paper
• 語言: English
• 出版: Institute of Electrical and Electronics Engineers Inc. 2023
• 在線閱讀: https://www.scopus.com/inward/record.uri?eid=2-s2.0-85165148256&doi=10.1109%2fISCAIE57739.2023.10165270&partnerID=40&md5=182de2ea0f117fc5ac873d4507678506
• DOI: 10.1109/ISCAIE57739.2023.10165270

One of the greatest difficulties that modern companies face is keeping up with technology. The limited options available in Power BI as a dashboard for time series in business forecasting models. Hence, this paper presents the use of ARIMA and SARIMA models to forecast sales for DataCo Global Company's dataset. The results are visualized and compared in a web-based dashboard, which displays forecast graphs, density plots, residual plots, and evaluation metric results for each model. The SARIMA model with parameters of (2,1,1) (0,1,1)12 was found to be the best model based on the smallest error measurement values of AIC and BIC. The dashboard provides an effective overview of the data and presents information in a visual format, making it easier for users to understand the results of the analysis. This approach enables data analysts to quickly assess and test the efficacy of forecasting models and assist executives in making informed decisions. © 2023 IEEE.