O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Excel for Data Mining

One exciting feature in Excel is the ability to work as a native client for SSAS data structures. The next few sections will explore using Excel as a data mining client. To make this functionality available to Excel, you first need to install the SQL Server Data Mining Add-ins. The Data Mining Add-in is available as a download for Office 2007. However, it works with 32-bit Office 2010 as well. The add-in is accessible at www.microsoft.com/downloads/en/details.aspx?FamilyId=896A493A-2502-4795-94AE-E00632BA6DE7&displaylang=en.

Image Note The Data Mining Add-ins add functionality to both Excel and Visio as a 32-bit version ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required