Microsoft SQL Server Data Mining Add-Ins for Office 2007
Microsoft SQL Server 2005 Data Mining Add-Ins for Office 2007 is a set of easy to use data mining capabilities that enable predictive analysis at every desktop. Being able to harness the highly sophisticated data mining algorithms of Microsoft SQL Server 2005 Analysis Services within the familiar environment of Office, business users can easily gain valuable insight into complex sets of data with just a few mouse clicks. Designed with the end users in mind, the Data Mining Add-Ins for Office 2007 empowers end users to perform advanced analysis directly in Microsoft Excel and Microsoft Visio.
Overview
The Microsoft SQL Server 2005 Data Mining Add-Ins for Microsoft Office 2007 contain three add-ins. Two for Microsoft Office Excel 2007 and one for Microsoft Office Visio 2007.
| • | Table Analysis Tools for Excel: Provides an easy-to-use add-in that leverage SQL Server 2005 Data Mining behind the scenes to perform powerful end user analysis on spreadsheet data. |
| • | Data Mining Client for Excel: Offers a full data mining model development lifecycle directly within Excel 2007. |
| • | Data Mining Templates for Visio: Enable powerful rendering and sharing of mining models as annotatable Visio 2007 drawings. |
Download Add-ins
| • |
Download SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007
|
Tutorials
The Microsoft SQL Server 2005 Data Mining Add-Ins for Office 2007 video tutorials has been created to help you to quickly get started using the Data Mining Add-Ins for Office 2007. The series consist of a small selection of short videos focusing on illustrating how to use the various features and allowing you to benefit from the powerful add-ins in a matter of minutes.
Server Configuration Utility
Watch this video to learn how to use the Server Configuration Utility to prepare the Analysis Services Server for use with the Microsoft SQL Server 2005 Data Mining Add-Ins for Office 2007.
Table Analysis Tools Tutorials
| • | Getting Started with the Table Analysis Tools for Excel |
| • | Analyze Key Influencers |
| • | Detect Categories |
| • | Forecast |
Data Mining Client Tutorials
| • | Getting Started with Data Mining Client for Excel 2007 |
| • | Explore Data |
Webcast
Data Mining Add-ins for the 2007 Office System
Microsoft SQL Server 2005 Analysis Services contains data mining and predictive analytical functionality that makes advanced analytics accessible to a much wider audience than ever before. Now, thanks to a set of add-ins for the 2007 Microsoft Office system, any information worker can take advantage of the power of SQL Server data mining. In this webcast, learn about the Data Mining Add-ins for the 2007 Office system, and see exciting demonstrations that highlight these enhancements to Microsoft Office Excel 2007 functionality that is accessible by any user.
Virtual Lab
Using the Microsoft SQL Server 2005 Data Mining Add-Ins for the 2007 Microsoft Office System
This lab will help you become familiar with preparing Excel data for building mining models. You will walk-through the process of applying a mining model to a new data set and then view the results in Excel. This will be done by acting as a representative from a sporting goods company that wants to take advantage of historical data on existing customers to create a marketing campaign to find out which prospects are most likely to purchase a bike.
Screencast
Introducing the Table Analysis Tool for Excel 2007
This screencast is the first in a series BI Developer screencasts recorded as part of a workshop built on SQL Server 2005 that have been delivered around the globe by Microsoft and Microsoft Partners. This training event introduces the student to the Table Analysis Tools for Excel 2007. These powerful tools hide the complexity of data mining technologies behind intuitive and automated tasks, delivering rich and innovative insight at the desktop.