Holt-Winters Forecasting for Many Products and Departments

User145718

Dear all,

I have a term project on forecasting the data that I have. The problem that I'm facing is my data consists of many departments and products and I need to forecast them separately. The tutorial of holt-winters can help me if I have only one product to forecast. But since my data has many sales departments and each of them has many products it's extremely time-consuming for me to forecast them one by one.

How can I forecast a product of each sales department in one model?

My data looks like this:

Month Sales Department Product Sales Quantity

Jan A 1 10
Jan B 1 20
Feb A 2 20
Feb B 2 10
.
.
.

Thanks,
Have a nice one!

lionelderkrikor

Hi@User145718,

Yes, of course, you can.

Regards,

Lionel

lionelderkrikor

Hi@User145718,

You could useFilter Examplesinside aLoop Valuesoperator.
But this process will create as many models as "sales departments"...

Regards,

Lionel

User145718

Hi@lionelderkrikor,

Thanks for your reply,

Can I use Loop Values inside an another Loop Values operator to create as many models as I like?

Regards,