Course Outline
Power BI Architecture
Data sources
- On-premises and online data sources
- Data transformations + M language
Modeling
Relationship between tables (single and multidirectional data filtering)
- DAX - Understanding the syntax and best practices
- Introduction to DAX
- Most commonly used functions and context of calculations
- Working with the time dimension (including fiscal periods, comparing periods, YTD)
- Filter functions
Visualizations
- Interactive data analysis
- Select the appropriate visualization
- Filters, grouping, exclusions
- Visualization on maps
Teamwork with Power BI
- Dashboards and Reports
- Q & A
Requirements
Audience that will most benefit from this training:
- Business Analysts: Those who need to analyze and visualize data to make informed business decisions.
- Data Analysts: Professionals working with data, who want to create interactive reports and dashboards.
- Managers/ Team Leads: Individuals responsible for monitoring key performance indicators (KPIs) and tracking business metrics.
- Anyone interested in data visualization and analytics.
By the end of this training, participants will be able to have:
- Understanding of Power BI architecture, data sources, and transformations.
- Proficiency in creating relationships between tables and using DAX functions.
- Ability to design effective visualizations and dashboards.
- Familiarity with teamwork/report sharing features
Testimonials (5)
The content was tough but that extra effort I had to put helped me remember and understand power BI better.
Melvin - TLI Group
Course - Power BI DAX Fundamentals
Discussing about our issues
Rr Dwi Putri Periska Sari - PT. Becton Dickinson Indonesia
Course - Power BI for Developers
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 - Electricidade de Mocambique
Course - Advanced Power BI
The second day as Power Bi is a really friendly tool, and clearly Costas knows it very well, it was really good to learn about that tool. Unfortunately we have to see Power pivot in excel first which is really not user friendly but definitely a must see first in order to understand how Power Bi works, and it makes Power Bi look super cool :)
Anne-Cecile Jacquot - Ameropa
Course - Excel to Power BI
The second day was very interesting. It was a good training to see some possibilities within Power BI; but mostly you learn then while you work with Power BI. Fact is also that the training base has all access rights and everything works, but as soon as you try to connect to the live system, it does not work and this makes the knowledge transfer a bit difficult.