We move! Starting September 1st, our QUEBEC CITY training center will be located at 5400, des Galeries Blvd, Suite 500, 5th Floor, Québec (Quebec) G2K 2B4
MS552

Master Power BI 2

See the training dates
  • Duration 2 days
  • Regular fee 1 000
  • Preferential fee 900?
  • Locations
    • Montreal
    • Quebec City
  • 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.
  • Montreal

    October 7 to October 8 2019 - CONFIRMED

  • Quebec City

    November 20 to November 21 2019

  • Montreal

    December 4 to December 5 2019

  • Montreal

    July 6 to July 7 2020

  • Quebec City

    July 8 to July 9 2020

Trainer(s) assigned(s)