Data Mining, Predictive Analytics with Microsoft Analysis Services and Excel PowerPivot

Course details

This course will introduce the students to the concepts of data mining, machine learning and predictive analytics utilizing the Microsoft toolsets including SQL Server Analysis Services and Excel with PowerPivot and the Data Mining Add-ins.

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

Target Audience: 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.