This Author published in this journals
All Journal Intelmatics
Jeany Fadhilah Agatha Siahaan
Fakultas Teknologi Industri, Universitas Trisakti

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

Designing Data Warehouse For Forecast and Data Visualization of Sales Nutrition Products Jeany Fadhilah Agatha Siahaan; Dedy Sugiarto; Teddy Siswanto
Intelmatics Vol. 1 No. 2 (2021): Juli - Desember
Publisher : Penerbitan Universitas Trisakti

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.25105/itm.v1i2.5235

Abstract

Sales data can be processed in such a way that it can become information that is used as material for analysis and consideration in making decisions. This study aims to visualize PT XYZ sales data for nutritious intake products and predict sales figures for 2018 and 2019. Data is obtained directly from PT XYZ by submitting a request for data withdrawal. Data on sales of nutritious beverage products for the last 5 years are processed using Pentaho tools with ETL method (extract, transform, load) then predicted sales figures for 2019 using R programming language with ARIMA and Holt-Winters methods after which data will be visualized using Powe BI so that the display of data presentation is more interesting and informative. To find out the compatibility in using the forecasting method, the writer will compare RSME numbers from both methods and use the method with the smallest RSME number.