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 manner in which the presenter addressed questions. The method of delivering the course was very beneficial to the students. A very good teacher indeed.
ROSE BALOYI - National Transmission Company South Africa
Course - Power BI: Basics to Advanced
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.
Marco Iuliano
Course - Power BI Dashboards
Training adjust the training according to our needs and knowledge. He understood participants experience with Power BI.
