Course Description
Who Should Attend
This course is intended for Power Users, IT Professionals, Report Developers, BI Professionals, Project Managers and Team Leads interested in exploring the Microsoft toolsets for data mining, machine learning, and predictive analytics.
Course Outline
1 - Introduction
Introduction
Course Materials
Facilities
Prerequisites
What We'll Be Discussing
2 - 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
3 - 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
4 - 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
5 - 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
6 - Concept Reinforcement Scenarios
Scenario 1
Scenario 2
Scenario 3
Scenario 4
Scenario 5
Lab 1: Concept Reinforcement Scenarios