Explore

DAX - Mastering DAX Foundations for Power BI

4 hours on-demand video

$ 9.99

Save Course

Go to Course

Brief Introduction

Demystifying DAX for Advanced Power BI Reporting

Description

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.

Requirements

Requirements
Students should be familiar with Power BI reporting already.
Some Excel formulas knowledge is an advantage but not necessary.
Students should have the latest version of Power BI for practice

Recommended for you

Microsoft Certified: Data Analyst Associate with Power BI

Analyzing and Visualizing Data with Microsoft Power BI - Exam Guide. Get Microsoft Certification in 30 days. Knowing this, what are you doing to let everyone know you mean business?...

Save Course

Advanced DAX for Microsoft Power BI Desktop

Master the DAX language and build advanced Power BI & data analysis skills with a top business intelligence instructor Hear why our Power BI courses are the TOP-RATED on Udemy:...

Save Course