The Microsoft SQL Server Data Mining Add-ins for the 2007 Microsoft Office system help you derive patterns and trends that exist in complex data, visualize those patterns in charts and interactive viewers, and generate rich, colorful summaries for presentation and for business analytics. You can use these add-ins to utilize the predictive analytics of SQL Server in Microsoft Office Excel 2007 and Microsoft Office Visio 2007.

This package includes the following two add-ins for Office Excel 2007 (Table Analysis Tools and Data Mining Client) and one add-in for Office Visio 2007 (Data Mining Templates):

• Table Analysis Tools for Excel  This add-in provides easy-to-use tools that leverage SQL Server Data Mining to perform powerful analytics on your worksheet data.

  For more information, see Getting started with the Table Analysis Tools.

• Data Mining Client for Excel  This add-in enables advanced users to go through the full development life cycle for the data mining model within Office Excel 2007 by using either worksheet data or external data from SQL Server Analysis Services.

  For more information, see Basic Data Mining Tutorial.

• Data Mining Templates for Visio  This add-in enables you to render and share your data mining models as the following annotatable Office Visio 2007 drawings:
  • Decision Tree diagrams based on Microsoft Decision Trees, Microsoft Linear Regression, and Microsoft Logistical Regression algorithms
  • Dependency Network diagrams based on the Microsoft Naive Bayes, Microsoft Decision Trees, and Microsoft Association Rules algorithms
  • Cluster diagrams based on the Microsoft Clustering algorithm

  The templates interact with data mining models stored on an instance of SQL Server Analysis Services and provide access to the underlying data in the mining model. You can manipulate the elements included in the diagrams, add or remove nodes, and filter on the data by using probabilities. You can also work with the full range of features for enhancing the diagram that are provided by Microsoft Office Visio.

To download the add-ins, see:

• Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007
• Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office 2007

  The SQL Server 2008 Data Mining Add-in provides two additional analysis features:

  • Prediction Calculator  This tool generates both interactive and printable calculators for scoring new data against a desired outcome. You can use it, for example, to determine if a loan application should be approved or not based on the scores it computes for customer attributes like occupation and income.
  • Shopping Basket Analysis  This tool helps you quickly analyze purchase transactions and identify sales opportunities.

For additional information about the add-ins, including training, see:

• Product Information for Microsoft SQL Server Data Mining Add-ins for Office 2007
• Data Mining Add-Ins for Office 2007
• Analysis Services Data Mining