Memuat
Memuat
Measure how much advertising, price, discounts and season move sales.
1 views
This project predicts weekly sales of 20 stores from advertising spend, price, discounts, competitors and season using linear regression. The model is tested with cross validation and its coefficients are translated into practical effects, such as extra units sold per IDR 1 million of advertising.

Read CSV loads penjualan_toko.csv (1,200 rows: 20 stores x 60 weeks). Set penjualan_unit as a numeric label and id_observasi as the id.
Select Attributes with invert selection removes toko and minggu_ke because they are only identifiers, not explanatory variables.
Linear regression only accepts numeric attributes. Nominal to Numerical with dummy coding turns season (holiday, dry, rainy) into 0/1 columns.
Cross Validation with 10 folds. The Training part contains Linear Regression (feature selection none, eliminate collinear features on, use bias on).
Apply Model predicts the test fold; Performance (Regression) computes RMSE, absolute error, relative error and squared correlation (R2).
Performance to Data and Write CSV save the performance measures and each row prediction. The final model goes to a result port; open its Description tab to see the regression equation.
Each coefficient is the change in units sold for a one-unit increase of the attribute, holding others constant. Compare the standardised coefficients to see the strongest factor.
penjualan_toko.csv
1,200 rows · 9 columns
Weekly sales of 20 fictional stores over 60 weeks with advertising spend, average price, discount, number of nearby competitors and season.
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 "beginner", 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$17. 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