SSAS - Tabular Model (online)

Wise Owl

Course

Online

£ 825 + VAT

The best SQL Server courses

See all

See all

Description

  • Type

    Workshop

  • Level

    Beginner

  • Methodology

    Online

  • Class hours

    12h

  • Duration

    2 Days

  • Start date

    Different dates available

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Personal tutor

    Yes

  • Virtual classes

    Yes

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.

Important information

Documents

  • SSAS (Tabular Model).pdf

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Visual Studio basics
  • Connecting to SQL Server
  • Creating a data model
  • Relationships
  • Excel pivot tables
  • Other data sources
  • Calculated columns
  • Measures
  • Changing query context
  • Prototyping using PowerPivot
  • Accessing DAX queries
  • Calendars
  • Date calculations
  • Hierarchies
  • KPIs
  • Perspectives

Teachers and trainers (1)

David Wakefield

David Wakefield

Director / Programmer / Trainer

Course programme

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

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

If time

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

Additional information

This course can also be provided as a client course at your premises or online.

See related categories

SSAS - Tabular Model (online)

£ 825 + VAT

The best SQL Server courses

See all

See all