Sales Analytics Dashboard with ARIMA and SARIMA Time Series Model

Sales Analytics Dashboard with ARIMA and SARIMA Time Series Model

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 Compan...

Full description

Bibliographic Details
Published in:13th IEEE Symposium on Computer Applications and Industrial Electronics, ISCAIE 2023
Main Author: 2-s2.0-85165148256
Format: Conference paper
Language:English
Published: Institute of Electrical and Electronics Engineers Inc. 2023
Online Access:https://www.scopus.com/inward/record.uri?eid=2-s2.0-85165148256&doi=10.1109%2fISCAIE57739.2023.10165270&partnerID=40&md5=182de2ea0f117fc5ac873d4507678506
id Mohamad A.F.; Jasin A.M.; Asmat A.; Canda R.; Ismail J.; Soom A.B.M.
spelling Mohamad A.F.; Jasin A.M.; Asmat A.; Canda R.; Ismail J.; Soom A.B.M.
2-s2.0-85165148256
Sales Analytics Dashboard with ARIMA and SARIMA Time Series Model
2023
13th IEEE Symposium on Computer Applications and Industrial Electronics, ISCAIE 2023


10.1109/ISCAIE57739.2023.10165270
https://www.scopus.com/inward/record.uri?eid=2-s2.0-85165148256&doi=10.1109%2fISCAIE57739.2023.10165270&partnerID=40&md5=182de2ea0f117fc5ac873d4507678506
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.
Institute of Electrical and Electronics Engineers Inc.

English
Conference paper
author 2-s2.0-85165148256
spellingShingle 2-s2.0-85165148256
Sales Analytics Dashboard with ARIMA and SARIMA Time Series Model
author_facet 2-s2.0-85165148256
author_sort 2-s2.0-85165148256
title Sales Analytics Dashboard with ARIMA and SARIMA Time Series Model
title_short Sales Analytics Dashboard with ARIMA and SARIMA Time Series Model
title_full Sales Analytics Dashboard with ARIMA and SARIMA Time Series Model
title_fullStr Sales Analytics Dashboard with ARIMA and SARIMA Time Series Model
title_full_unstemmed Sales Analytics Dashboard with ARIMA and SARIMA Time Series Model
title_sort Sales Analytics Dashboard with ARIMA and SARIMA Time Series Model
publishDate 2023
container_title 13th IEEE Symposium on Computer Applications and Industrial Electronics, ISCAIE 2023
container_volume
container_issue
doi_str_mv 10.1109/ISCAIE57739.2023.10165270
url https://www.scopus.com/inward/record.uri?eid=2-s2.0-85165148256&doi=10.1109%2fISCAIE57739.2023.10165270&partnerID=40&md5=182de2ea0f117fc5ac873d4507678506
description 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.
publisher Institute of Electrical and Electronics Engineers Inc.
issn
language English
format Conference paper
accesstype
record_format scopus
collection Scopus
_version_ 1828987866815922176

Similar Items