Forecast future sales

[Usamah22]

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

[BrandonB]

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

[echuong1]

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 

[Usamah22]

is the below what i need to use? TS forecast factory.

[BrandonB]

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