How to forecast sales for multiple products at the same time

I am trying to do an ETS forecast in Alteryx, however I have been struggling so far. The time series forecast in Alteryx provides me just one (probably total) forecast for the whole data series. What I need is an individual forecast for each of the products. I am enclosing an attachment with sample sales of several products. How would I be able to get a monthly forecast for each of the products until end of 2016?

Thank you very much,

Gorazd

Sample data for forecasting.xlsx

Predictive Analysis

Accepted answers

BridgetT

Hi @Oz,

Your problem is exactly the reason that the new Time Series Forecast tools were created! The TS Model Factory tool allows you to generate models for multiple groups at once. You just need to specify which field contains the string identifying the groups. Then you can use the TS Forecast Factory tool to create your forecasts. If you want an example of how to use the tools, you should check out the TS Factory Sample. But if you still have any more questions about the tools, feel free to ask them here! (I created them.)

Best,

Bridget

All comments

BridgetT

Hi @Oz,

Best,

Bridget

This is just great, thank you so much Bridget

jdicleme

Hi Bridget,

This looks like a great tool. Can you please described what is needed for the ETS model input? In the sample I see a file called sample model no covars. What is in this file?

Thank you,

Jon

APL_dept

Hi Bridget,

Is there a TS Filler Tool for multiple groups as well? Thanks.

- JX

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703