Learn about DAX calculations in Power BI and how to put it into practice when developing Power BI models
What you will learn
Understand the concept of CONTEXT
Use the CALCULATE statement
Create filters using table functions
Incorporate time intelligence functions in your analysis
Become a DAX master by combining patterns of DAX formula
Description
An outline of this training course
This is the first part of the Ultimate Beginner’s Guide to DAX course. This has been created to give you an introductory understanding of DAX, which is the formula language inside of Power BI. DAX is the true analytical power behind Power BI. If learnt well you can complete some incredible analysis that historically has been quite difficult to achieve with existing tools (like excel). The training covers some theory behind DAX that is important to understand and learn very well before you move on to more advanced formula and using complex analytical techniques.
Details of what you will learn during this course
- Learn – what the most important concept of DAX is – CONTEXT
- Understand – what the CALCULATE statement does
- Learn – what table functions are and when to use them
- Review – time intelligence functions
- Understand – how important learning DAX well is when using Power BI
What you get with the course
- One hour of course videos
- Demo data set to practice DAX formula with
- Power BI file (pbix file) resource showcasing all the examples used during the course
- 15 questions quiz to test your knowledge and understanding of the course content
Here are the specifics for the course
Learn how to:
- Understand the concept of CONTEXT
- Use the CALCULATE statement
- Create filters using table functions
- Incorporate time intelligence functions in your analysis
- Become a DAX master by combining patterns of DAX formula
Testimonials
“I’ve completed a lot of online training in the past, but this is by far the superior delivery of training. Provides detailed insights and simple mechanisms to build upon. I can absolutely recommend this for anyone wishing to get started with DAX in Power BI.” – Coenraad Mulder
“After completing the Beginners Guide to Power BI and DAX, I feel as though I am more proficient at Power BI than Excel. I found that the course tells you what you need to know, to help you build a really strong foundation early on in your Power BI journey.” – Nicholas
“Wish I came here first after months of going through countless videos and google searches. Learnt a lot in such a short time. I’m confident in using Power BI and looking forward to doing the next course on DAX.” – Audrey Taulalo
For a list of all courses available through Enterprise DNA, you may visit our site.
Content