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.5. Excel 2007: Data Mining Tab Tools

This is a more advanced area of Excel Data Mining. Although it uses the same connection to SQL Server 2005 Analysis Services to leverage the Microsoft Research statistical analysis tools, it provides a more sophisticated set of menus to configure the data mining experience.

The tools on this Data Mining tab are quite literally a client version of the SQL Server 2005 Data Mining tools. The difference is that we're able to do our work from within Excel instead of Visual Studio, which has long been the Data Mining design environment for SQL Server. These client tools allow us to save our work as "data mining models," which support the reuse of our configurations with new Excel tables. The data mining models ...

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