The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Holt-Winters Forecasting for Many Products and Departments
User145718
Member Posts: 7 Contributor I
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!
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!
Tagged:
0
Answers
You could use Filter Examples inside a Loop Values operator.
But this process will create as many models as "sales departments"...
Regards,
Lionel
Thanks for your reply,
Can I use Loop Values inside an another Loop Values operator to create as many models as I like?
Regards,