Jurnal Teknologi Informasi : Jurnal Keilmuan dan Aplikasi Bidang Teknik Informatika
Vol. 17 No. 2 (2023): Jurnal Teknologi Informasi : Jurnal Keilmuan dan Aplikasi Bidang Teknik Inform

FORECASTING SALES DATA ON E-COMMERCE USING SINGLE EXPONENTIAL SMOOTHING METHODS

Ida Jubaidah (Universitas Trisakti)
Dian Pratiwi (Universitas Trisakti)
Teddy Siswanto (Universitas Trisakti)



Article Info

Publish Date
05 Aug 2023

Abstract

Forecasting is predicting the occurrence of something in the future by referring to historical data that occurred in the past that can be used to conduct business analysis. Fairez Shop is an MSME engaged in selling clothing which in its operations generates tens of thousands of data that has never been used for business purposes. Fairez shop also requires a forecasting analysis to predict sales of its products in order to manage supply and help make decisions related to future business. From the problems described above, this research will forecast sales data at the Fairez Shop. The ETL process for designing the OLAP database in this study uses Pentaho Data Integration and the forecasting method used is single exponential smoothing and standard error mean absolute percentage error with R Studio tools, then forecasting results are visualized using Power BI tools. From the trial results, the standard error was obtained in January 2023 of 36.99655%, in February 2023 of 2.817564% and in March 2023 of 2.884921%. With a standard error percentage value below 50%, it can be concluded that this forecasting is feasible and applicable.

Copyrights © 2023






Journal Info

Abbrev

JTI

Publisher

Subject

Computer Science & IT Decision Sciences, Operations Research & Management Electrical & Electronics Engineering Engineering Library & Information Science

Description

Jurnal Teknologi Informasi (JTI) diterbitkan adalah Jurnal Jurusan Teknik Informatika Universitas Palangka Raya dengan ISSN 1907-896X, E-ISSN 2656-0321. Jurnal Teknologi Informasi (JTI) merupakan Jurnal Keilmuan dan Aplikasi Bidang Teknik Informatika yang menyajikan hasil penelitian yang fokus pada ...