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
We got a good foundation to build on and got to test the things we had learnt, going at a sensible pace. The training system was flexible and allowed us to be brought up to date if needed and at any point we could just stop and ask questions/clarify and were encouraged to do so.
Steven Murphy, Gambling Commission
It was the right level for a beginner
Steven Murphy, Gambling Commission
The trainer's confidence in answering questions or providing solutions
Cheryl De Gracia - Sykes Asia Inc.
Content and Relevance
Letlhognolo Marumolwa - University of South Africa
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.
Meggan Witte - Leggett & Platt, Inc.
training itself
John Denver Virtucio - Sykes Asia Inc.
I mostly enjoyed the very lively and ease.
Rey Jasper Matias - Sykes Asia, Inc.
I was benefit from the good Explanation and ability to Switch Topics when requested by the trainee.
- McArthurGlen
I enjoyed the about the actual application of the lectures provided by the Jonathan.
- Sykes Asia, Inc.
I like most the DAX function topic as well as the Trainer's eagerness to resolved inappropriate output, he speak based on his audience level of understanding.