Data Mining with Microsoftยฎ SQL Serverยฎ 2008
About the Authors
Credits
Acknowledgments
Contents at a Glance
Contents
Foreword
Introduction
How This Book Is Organized
Who Should Read This Book
Conventions
Tools You Will Need
Whatโs on the Website
Chapter 1: Introduction to Data Mining in SQL Server 2008
Business Problems for Data Mining
Data Mining Tasks
Data Mining Project Cycle
Summary
Chapter 2: Applied Data Mining Using Microsoft Excel 2007
Setting Up the Table Analysis Tools
The Analyze Key Influencers Tool
The Detect Categories Tool
The Fill From Example Tool
The Forecasting Tool
The Highlight Exceptions Tool
The Scenario Analysis Tool
The Prediction Calculator Tool
The Shopping Basket Analysis Tool
Technical Overview of the Table Analysis Tools
Summary
Chapter 3: Data Mining Concepts and DMX
History of DMX
Why DMX?
The Data Mining Process
Key Concepts
DMX Objects
DMX Query Syntax
Prediction
Summary
Chapter 4: Using SQL Server Data Mining
Introducing the Business Intelligence Development Studio
Setting Up Your Data Sources
Creating and Editing Models
Processing
Using Your Models
Using SQL Server Management Studio
Summary
Chapter 5: Implementing a Data Mining Process Using Office 2007
Introducing the Data Mining Client
Importing Data Using the Data Mining Client
Data Exploration and Preparation
Modeling
Accuracy and Validation
Model Usage
Data Mining Cell Functions
Model Management
Trace
Summary
Chapter 6: Microsoft Naive Bayes
Introducing the Naive Bayes Algorithm
Using the Naive Bayes Algorithm
Understanding Naive Bayes Principles
Naive Bayes Parameters
Summary
Chapter 7: Microsoft Decision Trees Algorithm
Introducing Decision Trees
Using Decision Trees
Decision Tree Principles
Parameters
Stored Procedures
Summary
Chapter 8: Microsoft Time Series Algorithm
Overview
Usage
DMX
Principles of Time Series
Parameters
Model Content
Summary
Chapter 9: Microsoft Clustering
Overview
Usage of Clustering
Principles of Clustering
Parameters
Summary
Chapter 10: Microsoft Sequence Clustering
Introducing the Microsoft Sequence Clustering Algorithm
Using the Microsoft Sequence Clustering Algorithm
Microsoft Sequence Clustering Algorithm Principles
Model Content
Algorithm Parameters
Summary
Chapter 11: Microsoft Association Rules
Introducing Microsoft Association Rules
Using the Association Rules Algorithm
Association Algorithm Principles
Understanding Basic Association Algorithm Terms and Concepts
Algorithm Parameters
Summary
Chapter 12: Microsoft Neural Network and Logistic Regression
Same Principle, Two Algorithms
Using the Microsoft Neural Network
Model Content
Interpreting the Model
Principles of the Microsoft Neural Network Algorithm
Nonlinearly Separable Classes
Algorithm Parameters
Summary
Chapter 13: Mining OLAP Cubes
Introducing OLAP
Performing Calculations
Browsing a Cube
Understanding Unified Dimension Modeling
Understanding the Relationship between OLAP and Data Mining
Building OLAP Mining Models Using Wizards and Editors
Understanding Data Mining Dimensions
Using MDX within DMX Queries
Using Analysis Management Objects for the OLAP Mining Model
Summary
Chapter 14: Data Mining with SQL Server Integration Services
An Overview of SSIS
Working with SSIS in Data Mining
Summary
Chapter 15: SQL Server Data Mining Architecture
Introducing Analysis Services Architecture
XML for Analysis
Processing Architecture
Predictions
Data Mining Administration
Summary
Chapter 16: Programming SQL Server Data Mining
Data Mining APIs
Using Analysis Services APIs
Using Microsoft. AnalysisServices to Create and Manage Mining Models
Browsing and Querying Mining Models
Stored Procedures
Summary
Chapter 17: Extending SQL Server Data Mining
Plug-in Algorithms
Data Mining Viewers
Summary
Chapter 18: Implementing a Web Cross-Selling Application
Source Data Description
Building Your Model
Making Predictions
Integrating Predictions with Web Applications
Summary
Chapter 19: Conclusion and Additional Resources
Recapping the Highlights of SQL Server 2008 Data Mining
Exploring New Data Mining Frontiers and Opportunities
Further Reference
Appendix A: Data Sets
Appendix B: Supported Functions
DMX Language Functions
VBA Functions
Excel Functions
ASSprocs Stored Procedures
Index