Help with data split

matias_sk2matias_sk2 MemberPosts:5Contributor I
edited November 2019 inHelp
Hi! I need help with data split.
I have a monthly budget for each product and I need to do a data-split for different geographical zones, according to historical company records.
For example, for a specific SKU there is a budget of 100 units a month. historically, the units are divided this way: Zone 1: 30%, zone 2: 20% and zone 3: 50%. So the budget for each Zone would be 30, 20 and 50 for zones 1, 2 and 3 respectively.

(that's just an example, I need to work with aprox 1500 SKU in 200 zones during 12 months)

Thank you
Tagged:

Answers

  • matias_sk2matias_sk2 MemberPosts:5Contributor I
    edited December 2018
    Hi@lionelderkrikor

    我已经从2017年历史月度销售数据2018 for each sku and sales zones.
    Also I have the budget 2019 for each sku, but I don't have budget for each sales zones.
    I need divide the 2019 budget for each zone according to the historical sales data.

    I attach an example of excel


    Thanks!

  • Telcontar120Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, MemberPosts:1,635Unicorn
    If you simply want to compute these percentages in RapidMiner, you can do that first by generating the average or sum of the prior years by zone with Generate Attrbiutes, and then use the Aggregate operator, where you group by Zone and then calculate the sum(fractional) as your aggregation function on your created variable.
    If you want to do something more complicated, like build a separate forecast model for each zone, then you could do that as well, but probably you would need to use Loop to go through the different values for zone and apply a separate forecast process to each.


    Brian T.
    Lindon Ventures
    Data Science Consulting from Certified RapidMiner Experts
    sgenzer matias_sk2
  • matias_sk2matias_sk2 MemberPosts:5Contributor I
    Hi@Telcontar120

    How could I do this?
    I have historical units and total budget units as input for each SKU


    Thanks!!
  • Telcontar120Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, MemberPosts:1,635Unicorn
    Have you created a process yet in RapidMiner? Did you take a look at the Aggregate operator sample process and compare it? You should post your process here with a a data sample and be more specific about the problem you are encountering. I provided a general description of how you would do this in RapidMiner already, but without a process to look at, I am not sure how I can be more helpful.
    Brian T.
    Lindon Ventures
    Data Science Consulting from Certified RapidMiner Experts
  • matias_sk2matias_sk2 MemberPosts:5Contributor I
    Hi@Telcontar120.
    I don't know which is the operator that I should use to make the data cross between the historical data and the budget data.
  • lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, MemberPosts:1,195Unicorn
    Hi@matias_sk2,

    I have difficulties to understand what is your goal :
    I know you provided a sample with your xls file but can you provide a more explicit explanation :
    Can you provide an example of what you have, and an example of what you want to obtain (the relationship(s) between 2017/2018 and 2019)?

    Regards,

    Lionel
  • matias_sk2matias_sk2 MemberPosts:5Contributor I
    Hi@lionelderkrikor

    In the Excel attachment you can see the logic that you would use to calculate this. Please your help, in Excel this can't be done for the SKU number that I need to make the division (around 1500 SKU, in 2000 zones and for 12 months)

    Thank you very much!
  • lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, MemberPosts:1,195Unicorn
    edited December 2018
    Hi@matias_sk2,

    这个过程answer to your need ?

    Hope it helps,

    Regards,

    Lionel

Sign InorRegisterto comment.