COURSE FINDER

SQL Server Analysis Services (SSAS) - Tabular Model

£1000 per delegate. This may be less for special offers on specific course dates and in-company training courses

Duration: 3 days

Trainer: S047OW

Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...

Introduction

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.

Prerequisites

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.

Course Contents

Getting started

- Multidimensional vs tabular
- Separate named instances
- The development environment

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

Relationships

- Diagram view
- Creating relationships
- Multi-column relationships
- Basket analysis

Excel pivot tables

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

OLAP PivotTable Extensions

- Installing OLAP extensions
- The CUBEVALUE function

Other client tools

- Standalone PowerView
- Creating a report
- Charts and slicers

Other data sources

- Linking to Access
- Linking to Excel
- Pasting in data

Calculated columns

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

Measures

- Creating measures
- SUMX, AVERAGEX, etc.

The DAX editor

- The essential add-in
- Installing the DAX editor
- Loading and saving measures

DAX functions

- The CALCULATE function
- Using FILTER
- Sorting and ranking
- Sampling data

DAX queries

- The CALCULATETABLE function
- Adding columns
- Summarising

Advanced DAX queries

- Defining measures in queries
- Named parameters
- Linking to Reporting Services

Calendars

- Creating a calendar table
- Using multiple calendars

Date calculations

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

MDX considerations

- When to use MDX and DAX
- Basic MDX

Hierarchies

- Creating a hierarchy
- Viewing hierarchies
- Parent-child hierarchies

KPIs

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

xVelocity considerations

- In-memory mode
- Row vs column orientation
- Memory usage
-DirectQuery

Perspectives

- Creating perspectives
- Using in Excel

Course Times

Usually 9.30am - 4.30pm. Course times will be confirmed in the joining instructions once the course has been booked.
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
  • Corps Construct Logo
  • Safety & Health Logo
  • Hawks Logo
  • Know How Logo
  • SYNERGIETRAINING Logo
  • Induct Ltd Logo
  • Ace Safety Logo
  • 1UPACCESS Logo
  • BAM Construction Training Logo
  • Citrus Training Logo
  • 3B Training Logo
  • Astutis Logo
  • Construction Industry Training Providers Logo
  • Health Life and Safety Logo
  • MI Construction Training Logo
  • Innov8 Training Logo
  • BSI Training Logo
  • OM Safety Training Logo
  • TotalComms Training Logo
  • SDA Safety Logo
  • Construction Skills People Logo
  • Phoenix Health and Safety Logo
  • Harris Safety Training Logo
  • First Response Training Logo
  • Alliance Learning Logo
  • ALS Safety Logo
  • KeyOstas Logo
  • Libben Health and Safety Logo
  • Global Management Academy Logo
  • Illumine Logo
  • CCAS Health and Safety Logo
  • ROSPA Logo
  • PJH Safety Training Logo
  • OMS Logo
  • Tala Training Logo
  • PRS Health and Safety Training
  • SSG Training and Consultancy Logo
  • RB Services Logo
  • Safety Training Services Logo
  • Clarkson Evans Training Logo
  • Lighthouse Training Logo
  • The Building Safety Group Logo
  • ProSafety Logo
  • Total Training Solutions Logo
  • Kentec Training Logo
  • Total Electrical Training logo
  • NTSS logo
  • Frinton Training logo
  • Envesca logo
  • The Safety Maintenance Company logo
  • APT Health and Safety logo
  • Sandwell Training Association logo
  • PC Workshops logo
  • Zero Harm Training logo
  • R2 Training logo
  • The Bradley Group logo
  • Risk Health and Safety logo
  • Wise Global Training logo
  • Total Training Company Logo
  • Sibbald Training logo
  • Total Construction Training logo
  • UTN Training logo
  • Collective Safety Solutions logo
Telephone Hotline (footer image)

Telephone Hotline

01933 233884

(Monday to Friday - 8:00am to 5:30pm).

© 2021 Book My Course Limited. All rights reserved

Home | About Us | Contact Us | FAQs | Privacy Policy | Terms & Conditions | Site Map | News / Articles | Cookie Policy