SQL Server training -  SSAS - Tabular Model

SSAS Training

SSAS - Tabular Model (3 days)

£895 + VAT for most venues (£995 + VAT for London)

As of SQL Server 2012, you can now create tabular models in Analysis Services, rather than building cubes in legacy multidimensional models. For anyone who is familiar with relational databases, tabular models are easier to create and use than 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 how to create tabular models by combining tables from SQL Server, Access, Excel and other data sources, and how to extract data from these models using Excel pivot tables, PowerView, Reporting Services reports and above all the DAX query language.

Course details

  • Locations for SSAS - Tabular Model coursesLocations:Manchester, London
  • Next SSAS - Tabular Model course locationNext course:Mon 14 November 2016
  • 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

Relationships

  • Training topicDiagram view
  • Training topicCreating relationships

Excel pivot tables

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

PowerView

  • Training topicCreating PowerView reports
  • Training topicWays to filter data
  • Training topicPowerView charts

Other data sources

  • Training topicLinking to Access
  • 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.

DAX editors

  • Training topicDAX Editor
  • Training topicDAX Studio
  • Training topicPros and cons of each

Changing query context

  • Training topicThe CALCULATE function
  • Training topicUsing FILTER

Prototyping using PowerPivot

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

DAX queries

  • Training topicThe CALCULATETABLE function
  • Training topicAdding columns
  • Training topicSummarising data

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

The EARLIER Function

  • Training topicHow it works
  • Training topicBanding

Hierarchies

  • Training topicCreating a hierarchy
  • Training topicViewing hierarchies
  • Training topicParent-child 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

Security

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

xVelocity considerations

  • Training topicColumn storage
  • Training topicDirectQuery

Processing and Partitions

  • Training topicHow processing works
  • Training topicTypes of processing
  • Training topicCreating and using partitions

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"The trainer is very friendly and helpful."

Wenlong Wang (Hometrack Data System )

"The (Access Introduction for Developer) course format, presentation and venue (London) were excellent and accompanied by impressive courseware. I will be recommending this to others."

Russell Harding (Amdipharm Plc)

"Trainer was very good, with an informal delivery. Good selection of refreshments. Meal out was good touch; better than cheap sandwiches. Location is literally 2 mins from Piccadilly."

Stephen Hope (UK General Insurance)

"Very good trainer with very good experience, practical and intellectual knowledge. Proper time was given to all aspects, including understanding and any questions/explanations in the working sessions, I would have liked even more time to cover even the optional topics. This course was recommended to me by a colleague and I shall in turn recommend on to my colleagues. The venue was also good – well located and equipped."

Daniel Ware (WorldPay UK Ltd)

"An excellent course. I'll use almost all of the course content in my job. The exercises were helpful in consolidating learning. The trainer also included exercises that were relevant to our work."

Anita Holcroft (Learning and Skills Council)

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 it difficult if you haven't used pivot tables in Excel.

Related Courses

SSAS - Multidimensional

Introduction

3 day course

Reporting Services

Introduction

2 day course

Integration Services

Introduction

2 day course

Other SQL Server Analysis Services training resources

SSAS exercises

SSAS exercises

The exercises listed here for multi-dimensional models 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