Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 50 Minute(s)
Language
English
Taught by
Ahmed Oyelowo
Rating
1 views
Course Overview
Demystifying DAX for Advanced Power BI Reporting
Background
DAX is the formula language of Power BI, Excel Power Pivot and SSAS Tabular. The formula language simply unlocks advanced capabilities for reporting in Power BI.
However, DAX is not an easy language to learn. Mastering it requires a proper understanding of the rudiments and a lot of constant practice.
In this course, I have used a very explanatory approach to ensure that you will understand, learn and master DAX faster than most courses where formulas ae being copied from a text editor without proper explanation of what is happening behind it.
As a Microsoft Most Valuable Professional for the Data Platform and a Microsoft Certified Trainer, I will be able to answer your DAX questions as you continue to develop your skills after this course.
What you will learn.
This course is suitable for all levels of Power BI users. You will learn from the introductory concepts to build a solid background. By the time you complete the course, you should have a better understanding of:
1. DAX usage in Power BI (Calculated Columns, Calculated Tables, Measures and Row Level Security)
2. The most important and used DAX functions
3. How the DAX Engine works behind the scenes
4. The CALCULATE function in DAX
5. Row Context, Filter Context and Context Transition
6. Time Intelligence functions and calculations
7. Other important DAX functions like RANKX and TOPN
Assignments.
Because DAX is about doing , and beyond looking, I am sorry to say that I included assignments for you. Don't worry if you stumble here and there while completing the assignments, it's completely normal. You will just have to watch the parts of the videos again till you are able to complete them. It's all for good.
The more DAX you write, the better you get over time. So this is a good opportunity to write a lot of them.
Course Content
- 6 section(s)
- 61 lecture(s)
- Section 1 Introduction & Overview of DAX
- Section 2 Understanding DAX Pillars and Functions
- Section 3 Understanding how the DAX Engine works
- Section 4 Manipulating Filters Context with CALCULATE() Function
- Section 5 Time Intelligence Calculations in DAX
- Section 6 Other DAX Calculations
What You’ll Learn
- Understand how the DAX engine works
- Understand Calculated Tables, Columns, Measures and when to use what
- Simplified understanding of DAX Evaluation Context, Row, Filter and Context Transition
- Understand the most used DAX functions
- Write Time Intelligence formulas
- Understand when to use Iterator functions
Reviews
-
OOluwafisayo Ojomo
A very good delivery of the concepts, and using the excel to show how the Power Bi engine treats some commands, makes understanding easier.
-
RRishad Thayamkulam Alavi
I love the way he explains and tries to find alternative ways going deep in to pre-set functions and recreating them manually so that we can know who the engine works and thus can manipulate functions anyway we want
-
AAc
Really clear and well laid out. Focused on the key concepts and common misconceptions. Love how the instructor showed different approaches and the pros and cons of each approach. Something to consider adding to the lecture is the use of ALL() syntax can ignore/bypass slicer filter
-
RRamanveer Randhawa
Very good course to wrap your head around DAX functions. Easy to understand for anyone who is also new to DAX, as well as great tips for intermediate users
