PowerPivot not only is a tool for evaluating history, but also can be used to model and predict what may happen in the future. Through Excel add-ins, SSAS servers can be used to execute native data-mining model algorithms. In this chapter we have covered the following:
How to find and install the Data Mining Add-Ins for Excel 2007 into an Excel 2010 32-bit environment
How to use the Data Mining Add-In and PowerPivot to find statistically significant influencers of measures within PowerPivot
How to obtain and install Predixion Insight into a 64-bit Excel environment
How to use Predixion Insight Now for task-oriented, predictive analytics