Run Time Series Forecast for multiple Brands in a single go !!!

[Mahabirpanigrahi]

Hello Alteryx Wizards,

Help - Run Time Series Forecast for multiple Brands in a single go !!!

My data 3 columns - Brands , period, Volume.  In Brand Column, i have 12 different brands, period 36 months of data,. I want forecast next 12 months for each Brand. 

Currently, I am filtering each Brand one by one and run the forecast. And Union at the end and export to excel. This is bit lengthy. As these 12 brands for 1 category, I need to run for the same for multiple categories.:(

So just checking are any way we can run the forecast for all the brands in a single go ? Any tips ?

Regards

Mahabir.

[MichaelLaRose]

HI @Mahabirpanigrahi 

You can streamline your work with a batch macro.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/t...

Just batch by your brand and run the forecast in the macro. 

Best,

Michael

[Jonathan-Sherman · Accepted solution]

Hi @Mahabirpanigrahi,

Take a look at the TS Factory macros available on the Alteryx Gallery, which allow a group by function!

TS Model Factory: https://gallery.alteryx.com/#!app/TS-Model-Factory/5772af65aa690a1348cc6abf

TS Forecast Factory: https://gallery.alteryx.com/#!app/TS-Forecast-Factory/5772b060aa690a1348cc6b73

This should make your life much easier and remove a lot of your filters!

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

[Mahabirpanigrahi]

Thank you. Do you happen to have some examples ?

[Mahabirpanigrahi · Accepted solution]

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Time-Series-Factory-Tools-vs-Batch-...

I found this example and it works. The way u suggested! 

Regards

Mahabir.

[Jesus_gnzl95]

Hi, @Jonathan-Sherman , Do you know how can I compare ARIMA and ETL model using this tools? for example I have two TS Model factory one with ARIMA model and the other one with ETS model. I tried use TS compare but it doesn't  work 

[sheidari]

would also love to know how you can compare the TS Model factory tool for ETS and ARIMA. The TS Compare tool doesn't seem to work with them.