Enable Technology

Database 

Microsoft SQL Server 2016/2017 Analysis Services SSAS Data Mining




Course Overview


A two day course demonstrating how to use SQL Server Data Mining tools. The course introduces delegates to the DMX language and Microsoft graphic validation tools. The intention is to give participants the skills necessary to data mine their own organisations data sets.

Duration: 2 day course



Course Content


Topics include-

SSAS Data Mining
Data Mining Concepts
SSAS Data Mining Tools
DMX
Algorithms
Microsoft Association
Microsoft Clustering
Microsoft Decision Trees
Microsoft Linear Regression Microsoft
Microsoft Logistic Regression Microsoft Logistic Regression
Microsoft Naive Bayes
Microsoft Neural Network
Microsoft Sequence Clustering
Microsoft Time Series
Plugin Algorithms

Create Mining Structures
Columns Data Types
Nested Tables
Column Distributions
Discretization Methods
Classified Columns
Drillthrough on Mining Structures

Create Mining Models
Add a Mining Model to an Existing Mining Structure
Delete a Mining Model from a Mining Structure
Exclude a Column from a Mining Model
Create an Alias for a Model Column
Change the Discretization of a Column in a Mining Model
View or Change Modeling Flags
Specify a Column to Use as Regressor in a Model
Change the Properties of a Mining Model
Apply a Filter to a Mining Model
Delete a Filter from a Mining Model
Enable Drillthrough for a Mining Model View or Change Algorithm Parameters
Process a Mining Model
Make a Copy of a Mining Model
Create a Data Mining Dimension

Testing and Validation
Training and Testing Data Sets
Create a Lift Chart, Profit Chart or Classification Matrix
Create a Cross-Validation Report
Choose and Map Model Testing Data
Apply Filters to Model Testing Data
Choose the Column to Use for Testing a Mining Model
Choose an Accuracy Chart Type and Set Chart Options
Using Nested Table Data as an Input for an Accuracy Chart

Queries
Create a Prediction Query Using the Prediction Query Builder
Create a DMX Query in SQL Server Management Studio
Create a Singleton Query in the Data Mining Designer
Apply Prediction Functions to a Model
Choose and Map Input Data for a Prediction Query
Manually Edit a Prediction Query
View and Save the Results of a Prediction Query
Create a Content Query on a Mining Model
Query the Parameters Used to Create a Mining Model
Create a Singleton Prediction Query from a Template
Create a Data Mining Query by Using XMLA
Change the Time-out Value for Data Mining Queries

Data Mining Projects
Import a Data Mining Project using the Analysis Services Import Wizard
Processing Data Mining Objects
Deployment of Data Mining Solutions
Deploy a Data Mining Solution to Previous Versions of SQL Server
Export and Import Data Mining Objects

Architecture
Logical Architecture
Physical Architecture
Data Mining Services and Data Sources
Management of Data Mining Solutions and Objects
Moving Data Mining Objects

Processing
Data Mining Model Viewers
Browse a Model Using the Microsoft Tree Viewer
Browse a Model Using the Microsoft Cluster Viewer
Browse a Model Using the Microsoft Time Series Viewer
Browse a Model Using the Microsoft Naive Bayes Viewer
Browse a Model Using the Microsoft Sequence Cluster Viewer
Browse a Model Using the Microsoft Association Rules Viewer
Browse a Model Using the Microsoft Neural Network Viewer
Browse a Model Using the Microsoft Generic Content Tree Viewer

Stored Procedures
SystemGetCrossValidationResults
SystemGetClusterCrossValidationResults
SystemGetAccuracyResults
SystemGetClusterAccuracyResults






Email us about this courses         Telephone on 01952 305730






Training Locations: Enable Technology run courses in Wolverhampton, Telford, Shrewsbury, Birmingham, Cannock, Walsall, Dudley, Sandwell, Bridgnorth, Lichfield, Burton-upon-Trent, Stafford, Redditch, Bromsgrove, Solihull, Tamworth, Worcester, Shropshire, Staffordshire, Worcestershire and across the West Midlands.




West Midlands Scheduled Courses: Excel VBA; MS Project, SSRS; SQL; Crystal Reports; HTML;Adobe Illustrator; ASP.NET; Dreamweaver; Flash; Photoshop; InDesign; Google Scripting; Visio; PHP; Microsoft Access; JQuery JavaScript; Web Development; Office;

Birmingham Scheduled Courses: SQL; Excel VBA; MS Access;Photoshop; Adobe Illustrator; InDesign; Dreamweaver; MS Project;Visio; Flash; SSRS;PHP; JavaScript JQuery; HTML CSS; Microsoft Office;

Wolverhampton Scheduled Courses: Microsoft Access; Excel VBAMS Project; Visio; Adobe Illustrator; Photoshop; Dreamweaver; InDesign; Flash; HTML CSS; JavaScript; SQL; Microsoft Office; Adobe

Telford Scheduled Courses: SQL; Excel VBA; MS Project; Visio; PowerPoint; Photoshop; Adobe InDesign; Illustrator; Dreamweaver; Web Design; Office;

Cannock Scheduled Courses: Excel VBA; PHP; Microsoft Access; Visio; MS Project; PowerPoint; Dreamweaver; Photoshop; InDesign; Adobe Illustrator; Flash; JavaScript; HTML CSS;

Walsall Scheduled Courses: Excel; Access; MS Project; Visio; Photoshop; InDesign; Adobe Illustrator; Dreamweaver; Flash; SQL; JavaScript; HTML CSS;

Dudley Scheduled Courses: Excel; MS Access; SQL; MS Project;Visio; Adobe Illustrator; InDesign; Photoshop; Dreamweaver; Flash; JavaScript; HTML CSS;

Sandwell Scheduled Courses: Access;Excel; Microsoft Project; Visio; PowerPoint; Adobe Illustrator; Photoshop; Adobe InDesign; Dreamweaver; Flash; JavaScript; HTML CSS; SQL;

Shropshire Scheduled Courses: Illustrator; InDesign; Adobe; Dreamweaver; Flash; Photoshop; Excel; Project; Visio; PowerPoint; Office; JavaScript; HTML; Access;

Staffordshire Scheduled Courses: Illustrator; InDesign; Photoshop; Dreamweaver; Flash; Adobe; Excel;