O'Reilly logo

Microsoft ® Office 2007 Business Intelligence by Doug Harts

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

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 ...

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