Human Capital and Management
Company management
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
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
