6.4. Excel 2007: Data Mining Analyze Tab, Predictive Tools
The Analyze tab also has a set of tools with more of a predictive direction, where missing data should be filled in, or actual forecasting is of value. The following sections are not meant to be a complete discussion of data mining techniques, but rather to provide a brief presentation of the complete range of data mining tasks that can be accomplished with Excel 2007 connected to SQL Server Analysis Services 2005.
6.4.1. Excel Table: Fill From Example
Figure 6-18 shows how we start the Fill From Example data mining task. This can be used in two ways: to complete a partially filled column of data values, and to fill in a new column where the user has manually entered a few example values ...
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.
