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:Manchester, London
Next course:Thu 21 February 2019
Time:09.30-16.30

SCHEDULED DATES Course Contents - PDF

Course Contents

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

Why Choose Us?

No more than 6 people per class
Proper restaurant lunch included
468 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

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	London	£795	Book places
Tue/Wed 26-27 March 2019	2	Manchester	£695	Book places
Thu/Fri 30-31 May 2019	2	Manchester	£695	Book places
Tue/Wed 23-24 July 2019	2	Manchester	£695	Book places
Thu/Fri 12-13 September 2019	2	Manchester	£695	Book places
Tue/Wed 29-30 October 2019	2	Manchester	£695	Book places
Tue/Wed 26-27 November 2019	2	Manchester	£695	Book places

Date(s)	Venue
21/02	London
26/03	Manchester
30/05	Manchester
23/07	Manchester
12/09	Manchester
29/10	Manchester
26/11	Manchester

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

Other Analysis Services training resources

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

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