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.3. Excel 2007: Data Mining Analyze Tab, Analysis Tools

The Analyze tab is where most people will accomplish data mining within Excel. This is because the data mining tasks are fairly easy to use, and simply need an Excel table of data to work with. Both pattern analysis and predictive analysis can be done with these Analyze tasks, and they don't require any previous knowledge of data mining.

6.3.1. Excel Table: Analyze Key Influencers

Figure 6-5 shows how we start the Analyze Key Influencers data mining task. For reference purposes, this data mining tool uses the Microsoft Research Naïve Bayes algorithm, which calculates the conditional probability between a target column selected, and all other columns (obviously something we can't do manually!). ...

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