Course Outline
Introduction
- Overview of Power BI features and architecture
- Advanced tools and data analysis techniques in Power BI
Getting Started
- Installing Power BI and supporting components
- Efficient data strategies
- Fundamentals of the DAX language
Managing Data
- Querying and aggregating data
- R integration and M queries
- Data import and transfer processes
- Pivoting and unpivoting data structures
- Transposing and joining data tables
- Advanced functionality tips and tricks
Advanced Data Modeling
- Working with tables and dimensions
- Defining data granularity
- Managing relationships and cardinality
- Creating measures using DAX
- Optimizing models for performance
- Resolving common modeling issues
Advanced Rules and Calculations using DAX
- Creating tables using formulas
- Applying conditional functions
- Filtering across multiple tables
- Working with disconnected tables
- Using variables in DAX
- Calculating and managing filter context
- Working with dynamic measures
Advanced Visualizations, Reports, and Dashboards
- Visualization types available in Power BI
- Customizing visual elements
- Creating map visualizations in Power BI
- Building Power BI visuals with R
- Using filters and slicers in reports
- Enhancing visual elements for reporting
- Creating automated flows with Power Automate
- Implementing Q&A visuals in reports
- Optimizing dashboards for mobile devices
- Design tips for effective dashboards
Working with Embedded Analytics in Power BI
- Setting up the analytics environment
- Exploring Power BI REST APIs and client APIs
- Practical examples and use cases
Troubleshooting
Summary and Next Steps
Requirements
- Practical experience with Power BI
- Familiarity with the DAX language
Target Audience
- Business analysts
- Data analysts
- Developers
Client satisfaction rate of 96%
Testimonials (5)
Johann's experience is very relevant and I particularly appreciated his efforts to share with us his experience on what commonly works best, and the common pitfalls of dashboards preparation.
Eduardo Pinto - European Space Agency
Course - Advanced Power BI
The engagement and approach Johann took on the course was quite adequate, as well as adaptable to the audience and progress made.
Isidro de Paz - European Space Agency
Course - Advanced Power BI
The time spent on data modeling. As most of the persons are not IT, it is good for everyone to know the implication of the relationships and the useful star concept
Filipe Fernandes - European Space Agency
Course - Advanced Power BI
get to know the trainees first in order to better adapt the training, details about SharePoint, Good habits to implement BI
Lisboa Abel Vilanculos - Electricidade de Mocambique
Course - Advanced Power BI
What I liked the most was the coach's openness regarding the change in content as well as the approach that was previously prepared to accommodate our real needs
