Icon

JKISeason4-13_​berti093

Download the Excel from HUB

Beginner-friendly objective

R^2: 0.234

Intermediate-friendly objectives

Authenticateto KNIME Hub
KNIME Hub Authenticator
Name to Factand Forecast
Table Manipulator
Connect toJKI space
Space Connector
Download theExcel
Excel Reader
Just the Allwarehouse locationand regular for sublocation
Row Filter
Partiotionby the first rows
Table Partitioner
Partiotionby the first rows
Table Partitioner
Predict the new data
ARIMA Predictor
Base table
Table Creator
Name to Factand Forecast
Table Manipulator
Type column
Constant Value Column
... collect the results
Loop End
Type column
Constant Value Column
Score theresults numerically
Numeric Scorer
Concatenatethe predictionwith the original data(INTERSECTION)
Concatenate
Get the two seriestogether
Concatenate
Fitted valus to stockouts
Rule Engine
Concat thenew and the olddata
Concatenate
Not enough datato forecast
Constant Value Column
Missing valueto moving average
Missing Value
Stockoutto Fact
Column Renamer
Error messageto column
Constant Value Column
Partiotionby the first rows
Table Partitioner
Error handling
Try (Data Ports)
Catch theerrors
Catch Errors (Data Ports)
Predict the new data
ARIMA Predictor
Catch theerrors
Catch Errors (Data Ports)
Type column
Constant Value Column
Type column
Constant Value Column
Concatenatethe predictionwith the original data(INTERSECTION)
Concatenate
R^2 to variable
Table Row to Variable
Fitted valus to stockouts
Rule Engine
Constant Value Column
Error messageto column
Constant Value Column
Table Row to Variable
Score theresults numerically
Numeric Scorer
Wihout the Allwarehouse location
Row Filter
Learn ARIMA
ARIMA Learner
Location andsub location...
Group Loop Start
Visualization
Get the two seriestogether
Concatenate
Predictregardingthe ARIMA model
ARIMA Predictor
Predictregardingthe ARIMA model
ARIMA Predictor
Partiotionby the first rows
Table Partitioner
Add 4 new data entry tothe end of the table
Prepare the table
Plot it to seeseasonality
Line Plot
Learn ARIMA
ARIMA Learner

Nodes

Extensions

Links