Overview
This three-day instructor-led 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.
Before attending this course, students should have:
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.
This module explains how the class will be structured and introduces course materials and additional administrative information. Lab 1: None This module will get students grounded in the terminology and concepts commonly utilized in data mining. Lab 1: Data Mining Concepts This module familiarizes the student with the data mining tools in SQL Server Analysis Services. Lab 1: SQL Server Analysis Services Data Mining Tools This module explains the Microsoft implementations of the generic types of algorithms uses in data mining. The students will work with each algorithm and implement an example of each. Lab 1: The Microsoft Data Mining Algorithms This module switches to the use of Excel with PowerPivot and the Data Mining Add-ins. Here the students will see the different capabilities between Excel and SQL Server Analysis Services and learn to use the data mining features of Excel and generate consumable reports from analytics and data mining. Lab 1: Excel PowerPivot Data Mining Add-ins This module consists of five scenarios to help reinforce the concepts covered in this course. Lab 1: Concept Reinforcement Scenarios
At Course Completion
Prerequisites
Target Student
Course duration
3 Days
Course outline
Module 1: Introduction