Product Prediction

[ppeng]

Hey KNIME team,

I will be grateful if somebody can guide me through this prediction.
So far I have shown the average sales in different years, segment and category…etc.
Now I am trying to predict the sales for “next year” and for product x how many should we buy/oder in the next big order/ next Quarter.

Sorry for not attaching the workflow due to the file size but this is a screenshot.

I got the data from Kaggle:

DataCo SMART SUPPLY CHAIN FOR BIG DATA ANALYSIS

Thanks in advance!

[AlexanderFillbrunn]

Hi @ppeng,
Unfortunately, I do not think we will be able to assist you with a full solution here. Time series forecasting is an art and takes some fine-tuning to get right. I can recommend this book to get started. Things you need to account for are, among others, trend and seasonality in the data, as well as the selection of features you can use.
Kind regards,
Alexander

[mlauber71]

@ppeng in addition to what @AlexanderFillbrunn has mentioned I have collected these hints about KNIME and time series:

Getting started with time series

@polina_l there is a dedicated book as well as examples on the KNIME Hub you could begin with Codeless Time Series Analysis with KNIME KNIME Hub Space - Codeless Time Series Analysis with KNIME (the examples from the book) Tutorial: Introduction to Time Series Analysis Time Series Analysis with KNIME — an introduction Time Series Analysis Workshop [Time Series Analysis Workshop] Time Series Analysis with the KNIME Analytics Platform [Time Series Analysis with the …