Business Intelligence training -  SSAS - Tabular Model

SSAS Training

SSAS Tabular Model training course

£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.

This course runs in SQL Server 2016, but will be appropriate if you're using SQL Server 2012, 2014 or 2017 too.  If you're in any doubt about the differences between the various SQL Server versions, ask us!

Course details

  • Locations for SSAS - Tabular Model coursesLocations:Manchester, London
  • Next SSAS - Tabular Model course locationNext course:Thu 21 February 2019
  • SSAS - Tabular Model course timesTime:09.30-16.30

Course Contents

Getting started

  • Training topicMultidimensional vs tabular
  • Training topicSeparate named instances

Visual Studio basics

  • Training topicVisual Studio windows
  • Training topicSetting startup options
  • Training topicCreating a project

Connecting to SQL Server

  • Training topicCreating and using connections
  • Training topicFiltering rows and columns

Creating a data model

  • Training topicHiding from client tools
  • Training topicRenaming tables/columns
  • Training topicHow column storage works
  • Training topicHow processing works

Relationships

  • Training topicDiagram view
  • Training topicCreating relationships

Excel pivot tables

  • Training topicAnalysing data in Excel
  • Training topicConnecting from Excel
  • Training topicUsing Excel pivot tables

Covered if time allows If time

Power BI Desktop overview

  • Training topicImporting from SSAS
  • Training topicBasic visualisations
  • Training topicHow publishing works

Other data sources

  • Training topicLinking to Excel
  • Training topicPasting in data

Calculated columns

  • Training topicUsing IF and SWITCH
  • Training topicBLANK arithmetic
  • Training topicLinking tables using RELATED

Measures

  • Training topicCreating measures
  • Training topicSUMX, AVERAGEX, etc.

Changing query context

  • Training topicThe CALCULATE function
  • Training topicUsing FILTER

Prototyping using PowerPivot

  • Training topicUsing PowerPivot
  • Training topicImporting PowerPivot models into SSAS
  • Training topicConstraints

Accessing DAX queries

  • Training topicFrom within Excel
  • Training topicFrom Reporting Services

Calendars

  • Training topicCreating a calendar table
  • Training topicUsing multiple calendars

Date calculations

  • Training topicWorking days
  • Training topicPeriod to date
  • Training topicPrior and parallel periods
  • Training topicSemi-additive measures

Hierarchies

  • Training topicCreating a hierarchy
  • Training topicViewing hierarchies

KPIs

  • Training topicThe parts of a KPI
  • Training topicAbsolute and relative measures
  • Training topicCreating and viewing KPIs

Perspectives

  • Training topicCreating perspectives
  • Training topicUsing in Excel

Covered if time allows If time

Security

  • Training topicHow security works
  • Training topicCreating roles
  • Training topicFiltering rows by role

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Excellent content and very well presented by a very knowledgeable and personable trainer. Small groups which allowed the trainer to spend a lot of time with everyone on the course. The course manuals cover all aspects of the training and are very clear and concise. I am looking forward to my next course.A++++ "

Steve Morley (Best Food Logistics (formerly Bidvest Logistics))

"The quality of manuals, examples and trainer were excellent. The trainer was happy to move off course to answer questions and tailor the content, this was great."

James Lodge (The Office of the Director of Public Health)

"Great course; the trainer was very clear, concise and enthusiastic. The manuals will be a very useful point of reference in the future, I'm sure."

Paul Clewer (NHS South, Central and West CSU)

"Will be back - probably for SQL."

Chris Bell (BSI Group)

"Good content, good pace and well understood."

Susan Routledge (Sellafield Ltd)

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

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.

Scheduled SSAS - Tabular Model training dates

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

Dates Days Venue Price Booking
Thu/Fri 21-22 February 2019 2 £795 Book places
Tue/Wed 26-27 March 2019 2 £695 Book places
Thu/Fri 30-31 May 2019 2 £695 Book places
Tue/Wed 23-24 July 2019 2 £695 Book places
Thu/Fri 12-13 September 2019 2 £695 Book places
Tue/Wed 29-30 October 2019 2 £695 Book places
Tue/Wed 26-27 November 2019 2 £695 Book places
Date(s) Venue
21/02
26/03
30/05
23/07
12/09
29/10
26/11

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