Data piling up is meaningless if nobody reads it. We help turn it into numbers you can use to make decisions.
This page is for Sales Prediction with Linear Regression for Ad Budgets and Pricing built with RapidMiner. 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.
What You Receive
- A ready-to-run RapidMiner process (.rmp), with operator settings you can open and modify
- A cleaned dataset: duplicates, messy formats, and missing values are tidied first
- Analysis results as CSV/Excel tables, for example rmse (cross validation)
- A managerial interpretation report in language non-technical readers understand, with recommended actions
- A session explaining the results and a short guide to re-running the process
Operators Used
Read CSV, Select Attributes, Nominal to Numerical, Cross Validation, Linear Regression, Apply Model, Performance (Regression), Performance to Data, Write CSV.
Example Results from the Portfolio Project
- RMSE (cross validation): 41,7 unit
- R² (squared correlation): 0,864
- Mean absolute error: 33,6 unit
- Extra units per IDR 1 million advertising: 7,83
- Strongest factor: Biaya iklan
How the Process Works
- Question mapping — we first make sure which decision you want to take from this data
- Data audit — we check the completeness and quality of the data before analysis
- Processing and modeling — the process runs in RapidMiner, and assumptions and parameters are documented openly
- Joint review — results are discussed and the direction of the analysis can be adjusted
- Handover — the process file, the cleaned dataset, and the interpretation report
Typically Used For
- Marketing and Sales Management students
- Store managers planning advertising and promotion budgets



