Options

Holt-Winters Forecasting for Many Products and Departments

User145718User145718 Member Posts: 7 Contributor II
edited December 2019 in Help
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!
Tagged:

Best Answer

Answers

  • Options
    lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, Member Posts: 1,195 Unicorn
    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
  • Options
    User145718User145718 Member Posts: 7 Contributor II
    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,
Sign In or Register to comment.