Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008

Chapter 24. Microsoft Office 2007 as a Data Mining Client

In this chapter we take a look at using the 2007 Microsoft Office system as an end-user client for SSAS data mining objects. Here we’ll examine the ins and outs of using Microsoft Office Excel 2007 and Microsoft Office Visio 2007 as end-user clients for SSAS data mining structure and models. We’ll take a look at the functionality of the Microsoft SQL Server 2008 Data Mining Add-ins for Office 2007. As you may recall from Chapter 2, these add-ins enable both Excel 2007 and Visio 2007 to function as end-user interfaces to SSAS data mining models. We’ll start by reviewing the installation process for the Data Mining Add-ins.

Installing Data Mining Add-ins

As we introduced in Chapter 2, several ...