Icon

04 - Adavanced Analytics - Time Series

This is a very basic Time Series example using the ARIMA algorithm. It is not finetuned nor optimized in any way.

It rather serves as an example to show how easy it is KNIME to set up time series prediction models and play around with the different values of it.

This workflow goes along with my weekly newsletter about data analytics called "The Data Alchemist's Transformation Scroll", click on the link below to find out more or subscribe for free.

The dataset was downloaded from Kaggle, if you click the link below, you'll go directly to the dataset page.

What is this all about?This is a very basic Time Series example using the ARIMA algorithm. It is not finetuned nor optimized in any way. It rather serves as an example to show how easy it is KNIME to set up time series prediction models and play around with the different values of it.This workflow goes along with my weekly newsletter about data analytics called "The Data Alchemist's Transformation Scroll", which you can find here: https://floral-silence-4399.ck.page/profileData Source: The dataset was downloaded from Kaggle, click on this link on Kaggle.com for more info: https://www.kaggle.com/datasets/vivek468/superstore-dataset-final import Superstoredatasetconvert Order Datedeleteunnecessarycolumnssort byOrder Date1 day lagon Profit Margincalc Profit Margin (Profit / Sales)3 day lagon Profit Margin7 day lagon Profit Margin30 day lagon Profit Margin7 day Moving Averageon Profit Margintop: test bottom: training(70 / 30)groupProfit Marginby Order Datedevelop asimple ARIMA modelapply ARIMA modelCSV Reader String to Date&Time Column Filter Sorter Lag Column Math Formula Lag Column Lag Column Lag Column Moving Average Partitioning GroupBy ARIMA Learner ARIMA Predictor What is this all about?This is a very basic Time Series example using the ARIMA algorithm. It is not finetuned nor optimized in any way. It rather serves as an example to show how easy it is KNIME to set up time series prediction models and play around with the different values of it.This workflow goes along with my weekly newsletter about data analytics called "The Data Alchemist's Transformation Scroll", which you can find here: https://floral-silence-4399.ck.page/profileData Source: The dataset was downloaded from Kaggle, click on this link on Kaggle.com for more info: https://www.kaggle.com/datasets/vivek468/superstore-dataset-final import Superstoredatasetconvert Order Datedeleteunnecessarycolumnssort byOrder Date1 day lagon Profit Margincalc Profit Margin (Profit / Sales)3 day lagon Profit Margin7 day lagon Profit Margin30 day lagon Profit Margin7 day Moving Averageon Profit Margintop: test bottom: training(70 / 30)groupProfit Marginby Order Datedevelop asimple ARIMA modelapply ARIMA modelCSV Reader String to Date&Time Column Filter Sorter Lag Column Math Formula Lag Column Lag Column Lag Column Moving Average Partitioning GroupBy ARIMA Learner ARIMA Predictor

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m1pegv
Created at: 2023-09-26
On NodePit since: 2023-09-26
Last update: 2024-04-27
Created with KNIME version: v4.7.2
Tags: time seriespredictionfinance

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!