# PowerPivot for Excel to create a simple sales forecast tool

• ### 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.

Friday, June 22, 2012 8:30 PM

• AFAIK,

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

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