The more you use it, the more you realize the fantastic potential of Power BI for business intelligence. With the M language you will see how to automate the import of data, transform it to facilitate its analysis and load it into tables. With R and Python you will go further in statistical data visualization. With Dax you will push the analysis of databases. Since Power BI is very powerful, you must identify the differences in the tool's functionalities in order to take advantage of them.
Duration
2 days
Schedule
On request
Regular fee
Price on request
Objectives of the training
To provide the knowledge and skills required to use the advanced features of Power BITargeted 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 (Course MS421).Trainers
Course architecture
Training eligible for grants from SCALE AI
- 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
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote