Providing Technology Training and Mentoring For Modern Technology Adoption
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.
After completing this course, students will be able to:
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.
Before attending this course, students must have:
This module explains how the class will be structured and introduces course materials and additional administrative information.
After completing this module, students will be able to:
This module will get students grounded in the terminology and concepts commonly utilized in data mining.
Lab : Data Mining Concepts
This module familiarizes the student with the data mining tools in SQL Server Analysis Services.
Lab : 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 : 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 : Excel PowerPivot Data Mining Add-ins
This module consists of five scenarios to help reinforce the concepts covered in this course.
Lab : Concept Reinforcement Scenarios