Memuat
Memuat
Forecast next-month sales from earlier months and last year's season.
0 views
This project forecasts monthly sales of a fictional company from 10 years of data. Last month, two months ago and the same month last year are built as attributes (windowing) for a linear regression, and accuracy is tested on the most recent months held out separately.

Read CSV loads penjualan_bulanan.csv: 120 months (January 2016 to December 2025) with the columns periode, bulan_ke, promo and penjualan_juta.
Multiply makes four copies: one as the main table and three for shifting time by 1, 2 and 12 months.
Inside Subprocess Lag k: Generate Attributes creates the key k = bulan_ke + k, Select Attributes keeps the key and sales, and Rename turns sales into lag_k.
Three Join operators (inner) match bulan_ke with each lag key so every row now holds sales 1, 2 and 12 months earlier. Rows of the first year that lack lag_12 are not used.
Select Attributes removes the key columns, then Set Role makes penjualan_juta the label and periode the id.
Split Data with linear sampling 80:20 keeps time order: the model trains on early months and is tested on the latest months, just like a real forecasting situation.
Linear Regression trains on the first part, Apply Model forecasts the second, and Performance (Regression) computes RMSE, relative error (MAPE) and R2.
Write CSV saves the forecasts and actual values of the test months so they can be charted in Excel.
penjualan_bulanan.csv
120 rows · 4 columns
Monthly sales (IDR million) of a fictional company over 10 years with an upward trend, seasonality (December peak) and a promotion-month flag.
Ready-to-run RapidMiner process (.rmp); CSV dataset with data dictionary; Practice guide and exercises (PDF/MD); Step-by-step video tutorial.
Not necessarily. The project is rated "intermediate", and every step of the process is explained so you can follow how the data becomes a result.
Yes. Swap the dataset in the first step and adjust the attribute roles; the rest of the process stays the same. If you would like us to adapt it for you, message us on WhatsApp.
The project costs US$24. Use the "Buy via WhatsApp" button on this page; the project files are delivered after payment is confirmed.
Found a problem or have a suggestion for this project? Tell us on WhatsApp
Back to RapidMiner portfolio