6.2. Excel 2007: Data Mining Analyze Ribbon Menu Tools
We're going to jump into data mining with the Analyze tools that make it easy to look for patterns in Excel tables. Excel tables are a big improvement in Excel 2007 and make it easy to turn a spreadsheet of cells into organized rows and columns. The data can be a stand-alone workbook, or it can come from external data sources—as we discuss in Chapter 4.
Given that we have an Excel table of data, we need to connect Excel to any available SQL Server 2005 Analysis Services server to make use of the data mining algorithms that are part of the SQL Server–based application. As Figure 6-4 shows, we'll able to stay within the comfortable world of Excel on our desktop computer but reach out to SQL ...
Get Microsoft ® Office 2007 Business Intelligence 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.
