Certificate Authentication

Getting started, data sources

• Installing Power BI and other components
• Data strategies for efficiency
• On-premises and online data sources
• Data transformations + M language

Managing Data

• Querying and aggregating data
• Importing and transferring data
• Pivoting and unpivoting data
• Transposing and joining data tables
• Tips and tricks on advanced functionalities

Advanced Data Modeling

• Working with tables and dimensions
• Defining data granularity
• Working with relationships and cardinality
• Creating measures using DAX
• Optimizing models for performance
• Fixing common issues in modeling

Advanced Rules and Calculations using DAX

• Creating tables using a formula
• Applying conditional functions
• Filtering multiple tables
• Working with disconnected tables
• Working with variables in DAX
• Calculating and filtering context
• Working with dynamic measures

Visualizations, Reports

• Visualization types in Power BI
• Customizing visual elements
• Creating Power BI maps visualization
• Creating Power BI visuals with R
• Using filters and slicers in reports
• Enhancing visual elements for reports