Search Training

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

Course Overview

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.

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
  • 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

Enroll Today

This is a 3-day class

Price: $1,785.00
Payment Options

ILT Instructor‑Led Training


GTR  Guaranteed to Run

Class times are listed Eastern time. This class is available for Private Group Training

To sort by location or date, click the ‘When’ and ‘Where’ column headings.

Class dates not listed.
Please contact us for available
dates and times.