MS552

Master Power BI 2

  • Duration 2 days
  • Regular fee 1 000
  • Preferential fee 900?
  • Locations
    • Montreal
  • New 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 (MS421)

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
  • M: Variables and parameters
  • M: Advanced data modeling
  • M: Many to Many in DAX
  • M: Creating a transition matrix
  • M : Incompatible granularities
  • M : Weighted distribution
  • Basics of Query Folding
  • Query Folding: beyond the basics
  • xVelocity: Overview
  • xVelocity: VertiPaq Analyzer
  • xVelocity: Cardinality
  • xVelocity: Calculated columns
  • Advanced visualization
  • Advanced visualization: Digital narrative
  • Advanced visualization: Bookmarks
  • 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.
  • Montreal

    February 18 to February 19 2019

  • Montreal

    May 6 to May 7 2019

Trainer(s) assigned(s)