locked
PowerPivot for Excel to create a simple sales forecast tool RRS feed

  • Question

  • I want to know if PowerPivot for Excel could be used to create a simple sales reforecast tool.
    Sales(Plant,Product,Market,Week) need to be reforecast monthly over a time span of 2*52 weeks.
    No statistical analysis is needed.
    Only simple transformations are needed, for example:

    • Sales(Plant,Product,Market,Week) = x *Sales(Plant,Product,Market,Week)
      for all plants, products, markets, weeks
    • Sales(Plant,Product,Market,Week) = x *Sales(Plant,Product,Market,Week)
      for all plants, products, markets, weeks > week0 and weeks < week1
    • Sales(Plant,Product,Market,Week) = x *Sales(Plant,Product,Market,Week)
      for all plants, products, markets, weeks > week0 and product = xxxx

    Other slightly more complex transformations may be needed too.
    For example: adding a predefined set of data, adding some product, partly interchanging some products, creating a new set of data for one full year, ...

    This process would be based on two "documents": the existing forecast and the transformation rules that have been decided each month. The result is a new forecast.

    There are of course many ways to create such a tool.
    Combining SQL and scripting (VBA, C#)  might be safe and flexible.
    However, I was curious to know if PowerPivot for Excel could be used,
    how it could be used, and what benefits there could be.

    The end-users are non-programming people, they feel confortable with excel.

    Thanks to share your know-how.

    Friday, June 22, 2012 8:30 PM

Answers

  • AFAIK,

    Forcasting is possible in MDX: http://www.mosha.com/msolap/articles/mdxlinreg.html


    Please vote as helpful or mark as answer, if it helps
    Cheers, Raunak | t: @raunakjhawar | My Blog

    Saturday, June 23, 2012 12:30 PM

All replies

  • A side question is: can DAX help for this?
    Is DAX suited for this kind of "multidimensional tansformations"?

    Thanks

    Saturday, June 23, 2012 9:46 AM
  • AFAIK,

    Forcasting is possible in MDX: http://www.mosha.com/msolap/articles/mdxlinreg.html


    Please vote as helpful or mark as answer, if it helps
    Cheers, Raunak | t: @raunakjhawar | My Blog

    Saturday, June 23, 2012 12:30 PM