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

Get PowerPivot for Business Intelligence Using Excel and SharePoint now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.