Designing Data Warehouse For Forecast and Data Visualization of Sales Nutrition Products

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.