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 use Filter Examples inside a Loop Values operator.
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,

lionelderkrikor

Hi @User145718,

Yes, of course, you can.

Regards,

Lionel