SQL Server Analysis Service Tabular Data Model Training Course – SSAS Training Course

SQL Server Analysis Services Training Course

In this SSAS, SQL Services Analysis Services, course you will learn the differences between Tabular and Multidimensional. Tabular is the in-between of Power BI and Multidimensional and is a lot easier to use than Multidimensional. Let us show you how to get the most out of this Analysis Services model.

Learning Outcomes

Creating a model, adding date tables, working with DAX, creating relationships and adding measures, calculated columns, KPIs and hiearchies.

Course Requirements

Power BI Users, Excel Users, Data Warehouse Developers or Complete Beginners wanting to understand the Tabular Data Model.

Course Length

1-day

SQL Server Analysis Service Tabular Data Model Training Course – SSAS Training Course Agenda

The TDM
  • Tabular Data Model
  • Multidimensional Model
  • What’s the difference?
  • When would you use either?
Models & Data
  • SQL Server Data Tools
  • Loading data from
  • SQL
  • Excel
  • Text files
Tabular Tasks
  • Renaming Columns
  • Date Tables
  • Creating Relationships
A whiter DAX
  • DAX – an Intro
  • Calculated Columns
  • Measures
  • KPIs
  • Perspectives
  • Hierarchies
Security
  • Roles
Cubes
  • How to deploy
  • How to refresh regularly
  • How to query

 

Course Price

This course costs £500 excluding VAT

How to Book

Call us or email us on the form below, any question, ask us!

You Might Also Like…

SSRS Training Course
SSIS Training Course
Power BI Training Course
Performance Tuning Course
SSAS Multidimensional Course
New Features of SQL Course
Data Warehouse Training
Advanced TSQL Course
Advanced SQL DBA Course

 

2 + 4 =

Summary
SQL Server Analysis Service Tabular Data Model Training Course - SSAS Training Course
Service Type
SQL Server Analysis Service Tabular Data Model Training Course - SSAS Training Course
Provider Name
Sequallity Ltd,
80-83 Long Lane,London,EC1A 9ET,
Telephone No.020 3507 1989
Area
UK
Description
Learn the differences between Tabular and Multidimensional. Tabular is the in-between of Power BI and Multidimensional and is a lot easier to use than Multidimensional. Let us show you how to get the most out of this relatively new Analysis Services model.