Time Series tool alternate to ARIMA using Holts Winter

[pvara]

Has anyone used Holts Winter forecasting model in Alteryx? I am working with someone that would prefer to use to the Holts Winter method. Can anyone offer any suggestions on how to make this happen?

Thank you

[bbak · Accepted solution]

You could probably make this happen using the R tool

https://help.alteryx.com/2018.2/R.htm 

https://www.rdocumentation.org/packages/stats/versions/3.5.1/topics/HoltWinters 

[TimothyL]

@pvara 

Hi Pvara, 

In essence, Holts Winter is a triple exponential smoothing method (Level, Trend & Seasonal). In Alteryx ETS tool, we are leverage forecast ets package (https://cran.r-project.org/web/packages/forecast/forecast.pdf) page 39. Whenever you manully click the Additive / Mltiplicative option under Seasonal Type, it's a Holts Winter methods.

For example, if you try to build a muliplicative Holt-Winters with muliplicative error, you simply need to check the box accordingly (Muliplicative, Additive & Muliplicative) under the Model Type option in ETS. Hope this clarifies.

I'm going to build more new forecast macros like this post: https://community.alteryx.com/t5/Data-Science-Blog/Expand-Your-Predictive-Palette-XGBoost-in-Alteryx...

Keep you updated.

TL