Data Mining Concepts
- Concepts and Terminology
- Data Mining and Results
- CRISP-DM
- Business Problems for Data Mining
- Models, Induction, and Prediction
- Data Mining Tasks
- Key Concepts
- Lab 1: Data Mining Concepts
SQL Server Analysis Services Data Mining Tools
- Introduction to SQL Server Data Tools
- Project Walk-Through
- Stepping Through the Data Mining Wizard
- Testing and Validation of Mining Models
- Cross Validation
- The Mining Model Prediction Tab
- Reports
- Lab 1: SQL Server Analysis Services Data Mining Tools
The Microsoft Data Mining Algorithms
- Types of Data Mining Algorithms
- Microsoft Decision Trees Algorithm
- Microsoft Linear Regression Algorithm
- Microsoft Clustering Algorithm
- Microsoft Naïve Bayes Algorithm
- Microsoft Association Algorithm
- Microsoft Sequence Clustering Algorithm
- Microsoft Time Series Algorithm
- Microsoft Neural Network Algorithm
- Microsoft Logistic Regression Algorithm
- Lab 1: The Microsoft Data Mining Algorithms
Excel PowerPivot Data Mining Add-ins
- Data Mining Tab
- Connection
- Data Preparation
- Management
- Model Usage
- Accuracy and Validation
- Data Modeling
- Visio Data Mining Add-In
- Lab 1: Excel PowerPivot Data Mining Add-ins
Concept Reinforcement Scenarios
- Scenario 1
- Scenario 2
- Scenario 3
- Scenario 4
- Scenario 5
- Lab 1: Concept Reinforcement Scenarios