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

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.

Time Series

Accepted answers

Jonathan-Sherman

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

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

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

Regards

Mahabir.

All comments

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/ta-p/488165

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

Best,

Michael

Jonathan-Sherman

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

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

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703