Enable Technology

Data Analytics 

Data Mining using Excel and Microsoft SQL Server Analysis Services

Course Overview

This course is intended for Power Users, IT Professionals, Report Developers, BI Professionals and  Project Managers interested in exploring the Microsoft toolsets for data mining, machine learning and predictive analytics. Participants will fully explore the potential of Excel PowerPivot and Excel Data Mining Add-ins used in  conjunction with Microsoft  SQL Server Analysis Services (SSAS).

Duration: 3 day course

Course Content

Topics include:

Data Mining Concepts
Concepts and Terminology
Data Mining and Results
Models, Induction and Prediction

SQL Server Analysis Services Data Mining Tools
Introduction to SQL Server Data Tools
Data Mining Wizard
Testing and Validation of Mining Models
Cross Validation
The Mining Model Prediction Tab
The User Interface
Offline Mode and Immediate Mode
Data Source
Data View
Exploring Data
Named Calculation
Named Queries
Compare Mining Structures
Cross Validation
Creating Reports Using Reporting Services
Saving Queries
Saving Results to the Database
Multiple Nested Tables

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

Excel PowerPivot Data Mining Add-ins
Data Mining Tab
Data Preparation
Model Usage
Accuracy and Validation
Data Modelling
Visio Data Mining Add-In


Email us about this courses

Telephone on 01952 305730