Using the SQL Server Data Mining Add-ins with PowerPivot for Excel

Written by Nathaniel Scharer on 22 June 2010.

This article has the following goals:

Explain what the add-ins are, how they differ, and how each is intended to be used.
Describe how to install PowerPivot for Excel and the Data Mining Add-ins for SQL Server 2008 on the same computer. Provide troubleshooting and configuration tips.
Describe performance issues and other considerations; suggest ways to optimize the use of PowerPivot in conjunction with data mining.