Enable Technology


Microsoft SQL Server 2016/2017 Analysis Services Tabular Modelling

Course Overview

A two day intensive course detailing how to create, deploy, use and manage tabular models in Microsoft SQL Server Analysis Services (SSAS) 2016 – 2017. The course is aimed at Data Analysts and SQL professionals.  No prior knowledge of SSAS is assumed.

Duration: 2 day course

Course Content

Topics include-

Overview of SSAS Tabular models
Version comparison
Data sources supported in SSAS tabular 2017
Data sources supported in SSAS  tabular 2016

Create Tabular Models
Tabular model designer
Create a New Tabular Model Project
Import from Analysis Services
Import from Power Pivot
Import from Power View

Import Data
Data sources supported in tabular 1400 models
Data sources supported in tabular 1200 models
Data types supported
Import data by using a native query

DirectQuery Mode
Enable DirectQuery mode in SSDT
Enable DirectQuery mode in SSMS
Add sample data to DirectQuery models
Define partitions in DirectQuery models
Test a model in DirectQuery mode
DAX formula compatibility in DirectQuery mode

Tables and Columns
Add columns to a table
Delete a Column
Change table, column
Row filter mappings
Specify Mark as Date Table for use with Time Intelligence
Add a table Delete a Table
Create a Calculated Table
Rename a Table or Column
Set the Data Type of a Column
Hide or freeze columns
Create a Calculated Column
Sort Data in a Table
Filter Data in a Table

Create a Relationship Between Two Tables
Delete Relationships
Bi-directional cross filters 

Understanding DAX in Tabular Models

Create and Manage Measures

Create and Manage KPIs

Create and Manage Hierarchies

Create and Manage Partitions in the Workspace
Database Process Partitions in the Workspace

Database Perspectives
Create and Manage Perspectives


Create and Manage Roles
Object-level security

Analyze in Excel
Analyze a tabular model in Excel

Deploy tabular model solutions
Deploy from SQL Server Data Tools

Manage Tabular Model Databases
Process Database, Table, or Partition
Manage Roles by using SSMS
Create and Manage Tabular Model Partitions
Process Tabular Model Partitions
Connect to a tabular model database
Restore from Power Pivot

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;