Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
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.
Anabelle Anore - Sykes Asia, Inc.
Related Courses
Power BI for Business Analysts
21 hours
Power BI for Developers
28 hours
Power BI Dashboards
14 hours
Power BI Dashboard Design
7 hours
Excel to Power BI
7 hours
Analyzing Data with Power BI
28 hours
Advanced Power BI
21 hours
Power BI DAX Fundamentals
21 hours
Datameer for Data Analysts
14 hours