Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
Course Outline
Introduction
- Overview of Power BI features and architecture
- Advanced tools and data analysis in Power BI
Getting Started
- Installing Power BI and other components
- Data strategies for efficiency
- DAX language fundamentals
Managing Data
- Querying and aggregating data
- R integration and M query
- 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
Advanced Visualizations, Reports, and Dashboards
- 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
- Creating an automated flow with Power Automate
- Creating Q&A visual in reports
- Optimizing dashboards for mobile devices
- Tips for designing 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
- Experience with Power BI
- Familiarity with DAX language
Audience
- Business analysts
- Data analysts
- Developers
Testimonials
It was informative
Isidro de Paz, European Space Agency
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 - Isidro de Paz, European Space Agency
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 - Isidro de Paz, European Space Agency
-Detailed course -Many exercises were included -Discussion about the model impact
Isidro de Paz, European Space Agency
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 - Isidro de Paz, European Space Agency
get to know the trainees first in order to better adapt the training, details about SharePoint, Good habits to implement BI
Lisboa Abel Vilanculos - Ernesto Sitoe Junior, Electricidade de Mocambique
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
Ernesto Sitoe Junior - Ernesto Sitoe Junior, Electricidade de Mocambique
Related Courses
Power BI
14 hours
Power BI for Business Analysts
21 hours
Power BI for Developers
28 hours
Power BI Dashboards
14 hours
Power BI Dashboard Design
7 hours
Excel to Power BI
7 hours
Analyzing Data with Power BI
28 hours
Power BI DAX Fundamentals
21 hours
Datameer for Data Analysts
14 hours