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
The fact that we got ready solutions for given problems + showing a wide range of applications + passed a compendium of knowledge.
Wojciech Michalak
The trainer has a very wide knowledge, he can convey it. It involves participants to interact and solve problems encountered together.
Nina Rokita
The trainer was in constant contact with the recipients of the training, adjusted the pace to our needs and solved our problems on an ongoing basis and answered our questions
Dominika Jaworska
The training was very consistent, I learned about many interesting functionalities of the program.
Anna Klimczak
Well prepared, practiced exercises and knowledge of the teacher
Sandra Przewdzing
Offering a more in-depth scope about Power BI more than any training institute that I came across to.
Mohammed Al Ameer
Exercises, additional tips from the trainer, flexibility to add more insights when requested.
Anna Alechno
I mostly enjoyed the power BI possibility.
British American Shared Services Europe
I generally was benefit from the power bi web- Q.
Cristina Palii
I genuinely enjoyed the visualization part.
Alexandra Grigoriu
Good coverage of all Power BI themes relevant and useful for creating reliable dashboards and reports as a beginner.
Gabriel Purghel
I liked the focus and the emphasis on self-learning, playing and reading on external resources. No Application can be taught in 2 days and self-study is very important.
Vlad Andrei Bucur
The trainer was open to answer questions and provide solutions to our real examples.
British American Shared Services Europe
understandable way of passing knowledge, a large number of practical exercises
I genuinely was benefit from the subject matter.
- Bristol City Council
The knowledge of the trainer was really good, and they were able to answer any questions asked about the product.
- Bristol City Council
Trainer is refined, he was able to play around with our data using his vast knowledge of the course, despite the 0 background with our work.
Mc Gyver Pascua - Sykes Asia, Inc.
I enjoyed the experience in learning Power BI.
- Sykes Asia, Inc.
I liked the preparation of the raw data before layout.
Ayie Delos Santos - 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.
I enjoyed the about the actual application of the lectures provided by the Jonathan.
- Sykes Asia, Inc.
I was benefit from the good Explanation and ability to Switch Topics when requested by the trainee.
- McArthurGlen
I mostly enjoyed the very lively and ease.
Rey Jasper Matias - Sykes Asia, Inc.
Dax
Kristian Paul Lugtu - SYKES ASIA INC
NA
- SYKES ASIA INC
The way of transferring knowledge and translating issues.
- Anna Julia Solås
Everything
- Sykes Asia Inc.
training itself
John Denver Virtucio - Sykes Asia Inc.
understandable way of passing knowledge, a large number of practical exercises