MS552

Master Power BI 2

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

Objectives

To provide the knowledge and skills required to use the advanced features of Power BI

Targeted audience

Knowing the basics of Power BI can take you to a certain level. However, there are numerous lesser-known functions that can take your knowledge of Power BI to a higher level.

Prerequisite

Master Power BI 1

Training Details

Content

  • Taking the first steps with the R programming language
  • Installing and configuring Microsoft R Open
  • R basics for scripts
  • R for data cleaning
  • Taking the first steps with the M programming language
  • The syntax of M
  • M query basics
  • Variables and parameters
  • Advanced data modeling
  • Many to Many in DAX
  • Creating a transition matrix
  • Incompatible granularities
  • Weighted distribution
  • Basics of Query Folding
  • xVelocity: Overview
  • xVelocity: VertiPaq Analyzer
  • xVelocity: Cardinality
  • xVelocity: Calculated columns
  • Advanced visualization
  • Advanced visualization: Digital narrative (Digital Storytelling)
  • Advanced visualization: Markers
  • Advanced visualization: Selecting
  • Advanced visualization: Exploration
  • Advanced visualization: Visuals using DAX
  • Advanced visualization: Customized visuals
  • Advanced visualization: Customized themes
  • Power BI Administration
  • Power BI Administration: Presentation of data refresh
  • Power BI Administration: Planning data refresh
  • Power BI Administration: Implementing row-level security
  • Power BI Administration: Implementing dynamic security

Select the training date*

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

    November 20 to November 21 2019 - CONFIRMED

  • Montreal

    April 7 to April 8 2020 - CONFIRMED

  • Montreal

    July 6 to July 7 2020

  • Quebec City

    July 8 to July 9 2020

Trainer(s) assigned(s)