What you'll learn:
- Understand Context Transition Once and For All
- Understand Why Your DAX Measures Return Wrong Results
- Master CALCULATE Function to Write Any Calculations You Need
- Master Difficult Concepts Like Row Context and Filter Context
- Understand When to Use RELATED and When to Rely on Relationships
- Learn Step-by-Step What Goes on Behind the Scenes when DAX Calculates Formulas
- Master DAX in Power BI as well
If you've completed a basic Power BI or Excel PowerPivot DAXcourse and you find yourself struggling with DAX concepts, then this is your course. Specifically if you struggle with:
- Context Transition: What does it mean and how do you know it's happening?
- Row & Filter context: What are they and why are they important?
- CALCULATE function: How does it work and why is it so powerful?
- FILTERfunction: What's the use of this function and how can you properly use it
- When to use RELATEDfunction and when to rely on relationships
- When to use ITERATOR functions and when to use the standard version of the function
- How can you debug your measure and formulas to see what's going on in the background?
All of this is covered in this compact DAXcourse!
You see, to create professional data models in Power BI and Excel Power Pivot, you need to learn DAX.
Here's the problem...
DAX can get difficult.
Most courses focus on the technical aspects only instead of real-life applications. Therefore, many people haven't explored what it has to offer!
They continue doing things the old "manual" way. Or the "complex" way with difficult formulas.
And that’s why I created this course!
This Advanced DAX course explains technical concepts in SIMPLE terms. It's a course addressed to Excel users and not IT Developers.
I broke down the concepts in unique ways so you can visualize what’s happening at each stage. Because complicated explanations cost time and knowledge!
And something else you may not know ...
Data modelling and DAX is not just for Excel but it’s also a skill you need to have for Power BI. So, you learn 1 feature and you can apply it to 2 different apps. In fact, the 2 applications most used in companies today.
Come join me in this course and finally master difficult DAXconcepts!
