Course Outline
Introduction
- Overview of Power BI’s core features and architectural design
- Utilization of advanced tools and data analysis methodologies
Getting Started
- Installation procedures for Power BI and supporting components
- Data strategies designed for maximum efficiency
- Foundational concepts of the DAX language
Managing Data
- Techniques for querying and aggregating datasets
- Integration with R and usage of M query
- Processes for importing and transferring data
- Methods for pivoting and unpivoting data structures
- Transposing and joining data tables
- Advanced functionality tips and optimization tricks
Advanced Data Modeling
- Management of tables and dimensions
- Defining appropriate data granularity
- Configuration of relationships and cardinality
- Construction of measures using DAX
- Performance optimization of data models
- Resolution of common modeling issues
Advanced Rules and Calculations using DAX
- Table generation via formulas
- Application of conditional functions
- Filtering across multiple tables
- Handling of disconnected tables
- Implementation of variables within DAX
- Management of calculation and filter contexts
- Creation of dynamic measures
Advanced Visualizations, Reports, and Dashboards
- Overview of available visualization types in Power BI
- Customization of visual elements
- Development of map-based visualizations
- Creation of visuals using R
- Strategic use of filters and slicers in reporting
- Enhancement of visual elements for report clarity
- Automation of workflows with Power Automate
- Incorporation of Q&A visuals in reports
- Dashboard optimization for mobile devices
- Design principles for effective dashboards
Working with Embedded Analytics in Power BI
- Setup of the analytics environment
- Exploration of Power BI REST APIs and client APIs
- Review of practical examples and real-world use cases
Troubleshooting
Summary and Next Steps
Requirements
- Practical experience with Power BI
- Working 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
