Course Outline
Power BI Architecture
Data sources
- On-premises and online data sources
- Data transformations + M language
- Direct connections to selected sources (SQL Server, OLAP)
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)
- Functions for naturalizing a parent-child hierarchy
- Filter functions
- DAX templates
Visualizations
- Interactive data analysis
- Select the appropriate visualization
- Filters, grouping, exclusions
- Visualization on maps
- Visualization enhancements (so-called custom visuals)
Data Access Management - Row-Level Security
Team work and mobile with Power BI
- Dashboards and reports
- Q & A mechanism
- Workspaces Mobile applications
Testimonials (5)
Constructive exchanges
Cécile - Transdev Compagnie Axonaise
Course - Power BI
Machine Translated
Depth and knowledge was good and the trainer was able to answer all questions and explain clearly why those answers were given.
Dino - Hastings Direct
Course - Power BI
- The experience of the trainer - availability of the online server/pc with power bi installed on it - very structured the training material - the attitude of trainer - great tone and pace of the voice
Iurie
Course - Power BI
I liked the interactive part where the trainer showed us how to put in practice the theory and then we did the exercises.
Simon
Course - Power BI
The way of explanation and the sequence of subjects