ETS / ARIMA modelling

Question

Hi -

I'm working on a dummy data-set and trying to get the ETS / Arima model to work.

One of the issues I'm facing is that I have multiple products, and I want to generate an ETS / Arima forecast for multiple products. However, I feel that the built-in ETS / ARIMA tool doesn't have a grouping capability.

How would you go around this?

JamesCharnley · Answer

@ajghatora

If your download from this link: https://community.alteryx.com/t5/Community-Gallery/TS-Model-Factory/ta-p/878750

isn't working then there are instructions at this link you can follow to help!: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/TS-Model-Forecast-Factory/m-p/819876

ajghatora · Answer

Thanks @jamescharnley, when I download this, it opens up as a workflow.

How can I embed the factory macro into my existing workflow to see if it will help?

JamesCharnley · Answer

Hi @ajghatora

There's an additional tool called TS Model Factory that can help here by allowing to group. Find out more info and where to download here: https://help.alteryx.com/20231/designer/ts-model-factory-tool

You can choose ARIMA or ETS, then choose a target field as normal but also a grouping field.

There's a forecast version as well found here https://help.alteryx.com/20231/designer/ts-forecast-factory-tool