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
Introduction
- Overview of Power BI and its capabilities
- Overview of DAX
DAX Basics
- Understanding the role of DAX in Power BI
- Exploring the DAX formula syntax
- Creating basic DAX expressions
- Understanding data types in DAX
DAX Aggregation and Calculation Functions
- Using aggregation functions
- Using logical functions
- Using mathematical functions
- Using text functions
- Using data and time functions
Optimizing DAX Performance
- Identifying and resolving performance issues in DAX
- Understanding query context and evaluation order
- Optimizing DAX calculations and expressions
- Best practices for DAX development
- Tips and tricks for efficient DAX modeling
Summary and next steps
Requirements
- Basic knowledge of Power BI
- Familiarity with the DAX language
Audience
- Business analysts
- Data analysts
- Developers
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.
Trainer approach and the way how he was able to explain everything. it was shown in very interesting way
Justyna - Estera Derkowska, Intermediate Capital Group Polska Sp. z o.o.
Trainer approach and the way how he was able to explain everything. it was shown in very interesting way
Justyna - Estera Derkowska, Intermediate Capital Group Polska Sp. z o.o.
The pace and the organization (no need to follow the trainer, we had to do later exercises on our own and ask for help if got stuck)
Estera Derkowska, Intermediate Capital Group Polska Sp. z o.o.
interactive. always could ask a questions. clear and understandable.
Kanan - Estera Derkowska, Intermediate Capital Group Polska Sp. z o.o.
Visualization tasks were very helpful to understand the application in real life
Amina - Estera Derkowska, Intermediate Capital Group Polska Sp. z o.o.
Good pace, good instructor, lots to cover.
Estera Derkowska, Intermediate Capital Group Polska Sp. z o.o.
Discussing about our issues
Rr Dwi Putri Periska Sari - Endah Palupi Puspitaningrum, PT. Becton Dickinson Indonesia
Materinya runut dan mencakup hal2 umum terkait powerbi untuk pemula
Angel - Endah Palupi Puspitaningrum, PT. Becton Dickinson Indonesia
Right what i want
Endah Palupi Puspitaningrum, PT. Becton Dickinson Indonesia
Seeing all the options of visuals.
Apex Global Solutions
I liked everything!
Chana Wertheimer - Apex Global Solutions
The interactive nature. Lots of hands on examples and not just lecture style and hand outs. I learn much better working the way it was taught to us
Derek Brown - Apex Global Solutions
hands-on examples
Apex Global Solutions
Very interactive, trainers were always open to answering questions and helping out if we were falling behind. Appreciated that they were able to customize the training to our needs and use the data sets we provided.
Audrey Bernard - Environment and Climate Change Canada
Being able to follow along with hands-on examples
Robin White - Environment and Climate Change Canada
I liked the mix between theory and hands-on work, the small class size, and how knowledgeable and fun the instructors were. Both instructors were always smiling and very personable. Even though each training session was long, the time (for me at least) often passed quickly because I found the material quite engaging.
Environment and Climate Change Canada
The pratcice option and the involving participants in solving the tasks
BAT Pécsi Dohánygyár Ltd
Data sources and tasks were really creative and interesting.
BAT Pécsi Dohánygyár Ltd
It was very interatctive, and a load of things to learn
BAT Pécsi Dohánygyár Ltd
New knowledge. :-)
BAT Pécsi Dohánygyár Ltd
Trainers are very knowledgeable, and patient in ensuring students could follow the lecture.
Trudy Staples Girardin - Indigenous Services Canada
I felt like we saw the whole spectrum of what Power BI can do. The trainers were super knowledgeable and so patient with our group.
Angela Murphy - Indigenous Services Canada
I learned a lot about Power BI and how to integrate the excel into it. I also enjoyed learning all different filters, visualizations and information that can be created.
Krystina Merkley - Indigenous Services Canada
I found the two instructors extremely knowledgeable, personable and respectful, great guys.
Bruce Pickett - Indigenous Services Canada
very friendly and accommodating. After the first day when he realized we were more advanced he re-structured the course and customized it to our needs.
Apex Global Solutions
I thought the trainer was very patient and had a lot of knowledge.
Sinead Goss - Linda White, Health Service Executive
Review of excel functions
Linda White, Health Service Executive
The time given to do each exercise after they were given.
Claire Delaney - Linda White, Health Service Executive
interesting training
christina Doyle - Linda White, Health Service Executive
I learnt more about excel
Linda White, Health Service Executive
I like how clearly everything was explained and the excercises
Claire Delaney - Linda White, Health Service Executive
I really enjoyed the VLookup part of the training - I think the trainer was really engaging and made the training very enjoyable.
Melissa Murray - Linda White, Health Service Executive
i had completed some power bi training previously so this was a good opportunity to learn about it again and i feel i understand it more now and as a result will be more confident in using it.
Karen Kinsella - Linda White, Health Service Executive
Trainers are very knowledgeable and patient in ensuring students could follow the lecture.
Trudy Staples Girardin - Indigenous Services Canada
I learned so much about Power BI, the trainers were patient and very knowledgeable.
Krystina Merkley - Indigenous Services Canada
Patience of Costas, adaptability to our various knowledge levels and work requirements. Possibility to ask questions.
Beatrice PLATEAU - Ameropa
It was informative
Isidro de Paz, European Space Agency
Johann's experience is very relevant and I particularly appreciated his efforts to share with us his experience on what commonly works best, and the common pitfalls of dashboards preparation.
Eduardo Pinto - Isidro de Paz, European Space Agency
The engagement and approach Johann took on the course was quite adequate, as well as adaptable to the audience and progress made.
Isidro de Paz - Isidro de Paz, European Space Agency
-Detailed course -Many exercises were included -Discussion about the model impact
Isidro de Paz, European Space Agency
Related Courses
Power BI
14 hours
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