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.
Note The Data Mining Add-ins add functionality to both Excel and Visio as a 32-bit version ...
Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
