Summary

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