Chapter 6. Excel and Data Mining: Key Influencers, Categories, and Forecasting
This unique chapter explores Microsoft Data Mining technology, which has been hidden in the background of SQL Server Analysis Services for many years. Excel 2007 dramatically changes this by bringing Data Mining to the forefront and making it possible for every Excel analyst to connect to the amazing statistical algorithms produced by Microsoft Research over the last decade. Underlying patterns in multi-hundred-thousand row data sets can be uncovered with Cluster and Dependency analysis, and multiple columns of data can be focused with Regression analysis to produce true forecasting of data trends.
Examples of the following topics will be provided in this chapter: ...
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.
