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
See training dates for details
Regular fee
$1,035
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$900
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 quoteDuration
2 days
Schedule
See training dates for details
Regular fee
$1,035
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$900
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