MS426

DAX, the language of Power BI features to optimize your data models

See the training dates
  • Duration 2 days
  • Regular fee 1 000
  • Preferential fee 900?
  • Locations
    • Montreal
    • Quebec City
  • New course
  • Laboratory
    course

Objectives

To provide the knowledge and skills required to use DAX (Data Analysis Expressions) expressions to resolve a wide range of analytical and data modeling issues.

Targeted audience

Professionals who use Power Pivot and/or Power BI Desktop to analyze data and wish to create dynamic, high-performance dashboards.

Prerequisite

Experience with Power BI.

Training Details

Content

  • Getting started with DAX
  • Introduction to DAX
  • Basics of data modeling
  • What is DAX
  • Creating calculated columns
  • Navigation functions
  • Conditional and logical functions
  • Creating calculated measures
  • Time Intelligence
  • Time intelligence functions
  • Using X functions and A functions
  • Table functions
  • DAX as a query language
  • Using variables
  • What is filter context?
  • Using filter context (CALCULATE, substituting filter contexts, FILTER, ALL, ALLEXCEPT)
  • CALCULATE and time intelligence (YTD, MTD,12 month rolling average, 3 month rolling average)
  • Semi additive measures
  • Overview of row context and transition context
  • Using iterator functions
  • Nested row context
  • Managing errors
  • Implementing basic security
  • Dynamic security
  • Role playing dimensions (importing several tables and USERELATIONSHIP)
  • Advanced DAX functions (CONTAINS, FIND, SEARCH, SUBSTITUTE, ALLSELECTED, RANKX)

Select the training date*

*Unless stated otherwise, all sessions are in French.
  • Montreal

    January 29 to January 30 2020 - CONFIRMED

  • Quebec City

    June 3 to June 4 2020

  • Montreal

    June 22 to June 23 2020

Trainer(s) assigned(s)