Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007 (Data Mining Add-ins) allow you take advantage of SQL Server 2005 predictive analytics in Office Excel 2007 and Office Visio 2007. The download includes the following components:
- Table Analysis Tools for Excel: This add-in provides easy-to-use tasks that leverage SQL Server 2005 Data Mining to perform powerful analytics on your spreadsheet data.
- Data Mining Client for Excel: This add-in allows you to go through the full data mining model development lifecycle within Excel 2007 using either your spreadsheet data or external data accessible through your SQL Server 2005 Analysis Services instance.
- Data Mining Templates for Visio: This add-in allows you to render and share your mining models as annotatable Visio 2007 drawings.
If you choose, you can install each of these components separately.
Abstract courtesy : Microsoft
Reference : Pinal Dave (http://blog.SQLAuthority.com)