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 (10)
Content and Relevance
Letlhognolo Marumolwa - University of South Africa
Course - Power BI
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
Elena
Course - Power BI
structure and the way it was presented
Tibor Balazs
Course - Power BI
Conocer todas las posibilidades de este programa
Olga - CEIM
Course - Power BI
The trainer's confidence in answering questions or providing solutions
Cheryl De Gracia - Sykes Asia Inc.
Course - Power BI
I liked the ability to work with sample data so that I could actually see how to utilize the tool. Having a visual and then getting the opportunity to repeat those steps during the training was also an added benefit.