Course ID: 251832

Live Training Course

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

When you register for training with TrainUp.com, you are also supporting local education. Find out how.

There are no upcoming events listed for this course. Feel free to contact us, chat or call 1-866-540-9677 for additional info. In the mean time please Search for additional courses or view similar courses below.
BROWSE By :
Category

In-Person Group Onsite Info

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

There are no upcoming events listed for this course. Feel free to contact us, chat or call 1-866-540-9677 for additional info. In the mean time please Search for additional courses or view similar courses below.
BROWSE By :
Category

Bring This Course On-Site

Have a group to train? Request On-Site training today to bring this training to your office. We bring our expert training partners to you!

No Course Dates Found

Join The 50,000+ Companies That Have Purchased Training from TrainUp.com

50K+ Companies Trained
Including 90% Of Fortune 500 Companies Have Purchased Training With TrainUp.com
300K+ Courses & Videos
Live Instructor-Led (Classroom & Virtual), Self-Paced E-learning & Custom OnSite Training Solutions From Leading Training Providers
800+ Expert Instructors
Industry-Leading Subject Matter Experts (SMEs).Tenured &
Award-Winning Instructor Network

Live Training Course

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

Course Dates

Join The 50,000+ Companies That Have Purchased Training from TrainUp.com

Bring Any training to your facility or train your team members remotely with a customized virtual course. Fill out the form to get started and a solutions rep will be in touch shortly!

Our on-site team responds to every request the same day!

Details about this course, including summary information, upcoming dates, and a link to this page, will be sent to the recipient specified below.

Send course information to the email address below:

Need to request approval from a manager at your organization? Add their email address below: