MS552

Master Power BI 2

  • Duration 2 days
  • Regular fee 1 000
  • Preferential fee 900?
  • Locations
    • Quebec City
    • Montreal
  • New course
  • Laboratory
    course
SUMMARY
DETAILS

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

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
  • 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: Drillthrough
  • 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
  • Nesting of Power BI visuals

DATES*

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

    November 20 to November 21 2019

  • Montreal

    December 4 to December 5 2019

Trainer(s) assigned(s)

Other course(s) in this category