COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
Classroom training -  SSAS - Tabular Model

Classroom Training

SSAS Tabular Model training course

Classroom training course - online version also available

£695 + VAT for most venues (£795 + VAT for London)

2 days

For anyone who is familiar with relational databases, tabular models in Analysis Services are easier to create and use than the old multi-dimensional cube models; plus they use DAX as a language, rather than the harder-to-understand MDX. Tabular models are a natural extension of PowerPivot within Excel.

This course will show you (among other things): how to create tabular models by combining tables from SQL Server, Access, Excel and other data sources; how to create DAX calculated columns and measures to extend your data mode; and how to extract data from these models using clients such as Excel pivot tables.

Course details

  • Locations for SSAS - Tabular Model coursesPossible locations:London, Manchester, Online
  • Next SSAS - Tabular Model course locationNext classroom course:Thu 20 August 2020
  • SSAS - Tabular Model course timesTime:10.00-16.30

Course Contents

The contents of this course are as follows:

Getting started

  • Multidimensional vs tabular
  • Separate named instances

Visual Studio basics

  • Visual Studio windows
  • Setting startup options
  • Creating a project

Connecting to SQL Server

  • Creating and using connections
  • Filtering rows and columns

Creating a data model

  • Hiding from client tools
  • Renaming tables/columns
  • How column storage works
  • How processing works

Relationships

  • Diagram view
  • Creating relationships

Excel pivot tables

  • Analysing data in Excel
  • Connecting from Excel
  • Using Excel pivot tables

Covered if time allows If time

Power BI Desktop overview

  • Importing from SSAS
  • Basic visualisations
  • How publishing works

Other data sources

  • Linking to Excel
  • Pasting in data

Calculated columns

  • Using IF and SWITCH
  • BLANK arithmetic
  • Linking tables using RELATED

Measures

  • Creating measures
  • SUMX, AVERAGEX, etc.

Changing query context

  • The CALCULATE function
  • Using FILTER

Prototyping using PowerPivot

  • Using PowerPivot
  • Importing PowerPivot models into SSAS
  • Constraints

Accessing DAX queries

  • From within Excel
  • From Reporting Services

Calendars

  • Creating a calendar table
  • Using multiple calendars

Date calculations

  • Working days
  • Period to date
  • Prior and parallel periods
  • Semi-additive measures

Hierarchies

  • Creating a hierarchy
  • Viewing hierarchies

KPIs

  • The parts of a KPI
  • Absolute and relative measures
  • Creating and viewing KPIs

Perspectives

  • Creating perspectives
  • Using in Excel

Covered if time allows If time

Security

  • How security works
  • Creating roles
  • Filtering rows by role

You should be familiar with how relational databases work to attend this course. You'll also find the course more difficult if you haven't used pivot tables in Excel.

Why Choose Us?

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"Thoroughly enjoyed the course especially as I had the privilege of being the only candidate. Consequently was able to discuss detailed issues related to my area of concern. Also, as it’s not a Microsoft certified course with an exam, there’s no time pressure and the trainer could be flexible about allowing some familiar aspects to be dropped so we could focus on other areas in more detail."

Phil Breeze (Sepura plc)

"2 days passed quickly as the course involved lots of hands on exercises. Contents were relevant and I would recommend it."

InSun Ahn (Tokyo Electron Europe Ltd)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Scheduled SSAS - Tabular Model training dates

Here are the classroom SSAS - Tabular Model courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Thu/Fri 20-21 August 2020 2 £695 Book places
Tue/Wed 01-02 December 2020 2 £695 Book places
Date(s) Venue
20/08
01/12

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite SSAS training at your offices (we'll even provide and set up the computers).

Related Courses

SSAS - Multidimensional

Introduction

2 day course

DAX

Introduction

2 day course

Introduction to SSIS

Introduction

2 day course

Other Analysis Services training resources

SSAS exercises

SSAS exercises

The exercises listed here should give you some idea of what to expect from this course.

View SSAS or Tabular exercises

SSAS blogs

SSAS blogs

Have a look at our Analysis Services blogs for inspiration on SSAS!

View SSAS multi-dimensional or SSAS tabular blogs

This page has 0 threads Add post