Courses

Audience

Duration

Prerequisite

Requirement

This course is intended for a broad audience ranging from strong business users through to IT professionals

1 Day

No specific prerequisite

Students require a computer with access to the internet

Course Overview

This course introduces participants to SQL Server Analysis Services tabular data models.  Participants learn how to create and deploy the models with particular emphasis on DAX (Data Analysis Expressions).

The course is delivered by an instructor that is making use of PowerPoint slides and interactive demonstrations.  The learning is reinforced by providing hands-on workshops where the participants have the opportunity to practice the techniques being taught.  Access to a computer with connectivity to the internet is mandatory to access the training portal.

 

Topics covered include:

  • BI Semantic Models
  • What Is an Analysis Services Tabular Data Model
  • Options for Creating an Analysis Services Tabular Data Model Project
  • Perspectives
  • Partitions
  • DirectQuery Mode
  • Security
  • Deployment Options
  • DAX
  • Time Intelligence

SQL Server Integration Services (SSIS)

Tabular Method

DSI Developed Course:

follow us

416 538-6849 ext.1

Copyright © 2017 Dimensional Strategies Inc. All rights reserved.