Hello,
i have data that looks like below with over 2 years of data for 100s of products. i want to forecast the sales for future months. what is the best way of doing this in alteryx?
Date | Product | Market Sales |
01/02/2020 | a | 1000 |
01/03/2020 | a | 1200 |
01/04/2020 | a | 1300 |
01/02/2020 | b | 50 |
01/03/2020 | b | 55 |
01/04/2020 | b | 43 |
You may want to take a training video on Time Series modeling in Alteryx using the ARIMA and ETS tools in the Time Series category: https://community.alteryx.com/t5/Videos/Time-Series-Analysis/td-p/114070
Once you become familiar with the concepts for a single model, you can apply the skills that you have acquired in the training above to then be applied to the Model Factory and Forecast Factory tools: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Time-Series-Factory-Tools-vs-Batch-...
They can be downloaded from the predictive district here: https://gallery.alteryx.com/#!districts/56327e37aa690a17f0760bdc
You'd want to use the time series forecasting tools.
See this link for an example:
https://community.alteryx.com/t5/Data-Science/Champagne-Analytics-A-Time-Series-Tutorial/ba-p/419776
Tool mastery here:
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-TS-Plot/ta-p/40487
is the below what i need to use? TS forecast factory.
Here is the help documentation on setup and use of the model factory and forecast factory
Model Factory: https://help.alteryx.com/current/designer/ts-model-factory-tool
Forecast Factory: https://help.alteryx.com/current/designer/ts-forecast-factory-tool