4.14 out of 5
4.14
751 reviews on Udemy

Master DAX fundamentals : Power BI, Power Pivot & SSAS

The Fundamentals of Data Analysis and Modelling with DAX for Power BI, Power Pivot and Analysis Services
Instructor:
Paula Guilfoyle CPA & MVP
3,795 students enrolled
English [Auto]
Explain and use Calculated Columns and Measures
Explain and use aggregation functions and expressions in DAX such as SUM and COUNT
Explain and use table functions such as Filter and RelatedTable
Explain and use iteration pairs such as SUMX and COUNTX
Set up Variables
Work with IF statements and DAX SWITCH function
Describe the fundamentals of how DAX works
Explain Row context and nested Row context
Explain Filter context
Use the ALL function to remove filters
Use the Calculate function to modify and replace basic filters
Explain and demonstrate how Relationships and DAX work together
Discuss the need for a DATE table
Use DAX to create a DATE table using CalendarAuto and other DAX functions
Use and explain Time Intelligence Functions such as TOTALTYD, SAMEPERIODLASTYEAR and more
Calculate Moving totals and Rolling Totals
Carry out Basic to Intermediate level DAX analysis

Data Analysis and data modelling made easy with Data Analysis eXpressions. DAX can be used in Power BI, Power Pivot and Analysis Services.

Analyse and Model your data with in Power BI, Excels Power Pivot and Analysis Services with Data Analysis eXpressions.

This is a hands on course

Course Overview

In the first section of this course you will be introduced to the use of the most common DAX expressions, such as SUM and SUMX, COUNT, ROUND, DIVIDE, MIN, MAX, IF Statements, TEXT expressions, Variables and More

In the next section of this course you will learn the fundamentals of how DAX works.  This section will include both theory and examples and it is of utmost importance that you understand how DAX works. We will discuss Row context and Filter context, ALL, FILTER, RELATEDTABLE, CALCULATE, EARLIER, Relationships and much more.

In the third section of this course you will learn about Time Intelligence and Date Tables. We will look at expressions such as TOTALYTD, SAMEPERIODLASTYEAR, DATESADD, DATESBETWEEN, CALENDERAUTO, and we will explore how many of these functions work using CALCULATE

Each section of this course contains Activities to complete. These Activities are of utmost importance.  When it comes to learning DAX, practice is a must.

Master DAX fundamentals : Power BI, Power Pivot & SSAS

1
Introduction

A quick introduction to this course Master DAX Fundamentals: Power BI, Power Pivot and SSAS

2
How to take this course

Please read the attached as it contains important information on how to take this course to get the most out of it

3
Before you forget

DAX (Data Analysis Expression) An Introduction

1
What is DAX

A brief history and overview of Data Analysis Expressions (DAX)

2
Calculated Columns and Measures

There are two types of calculations in DAX.  Calculated Columns and Measures.  We will look at both of these in this video

3
SUM and SUMX

learn about SUM and SUMX, be introduced to RELATED and iterators

4
Count and CountX

learn COUNT and COUNTX and see how calculated columns and measures differ, and learn when it is best to use each

5
Currency Data Type and the need to ROUND in DAX

When working with the Data type Currency in DAX, you need to ensure that all of the values are to the correct decimal place, for this you can use ROUND

6
DAX DIVIDE expression

the DAX DIVIDE function will allow you deal with errors when dividing one value by another,  Learn how to use DIVIDE in this video.

7
When you need a BLANK for the right data type

Are you familiar with the use of "" to get a blank in Excel?  Well in DAX you need to use the BLANK expression to ensure that your blank is of the correct data type

8
Related and Related Table

Related and related table will allow you take values from tables joined by relationships.  In this video you will be introduced to related table and will we will at related in more detail

9
MIN and MAX

If you are looking for the minimum value or the maximum value then DAX MIN and MAX expressions are required.  This video includes the updated DAX syntax for MAX in versions 2016 and after, as well as the original syntax.

MINX and MAXX are also covered in this video

10
Other Expressions

In this video you will be introduced to a number of iterators and pairs

11
IF Statements

learn how to carry out an IF statement in DAX

12
Conditional statement (AND OR and IN)
13
Classification columns using AND OR and IN
14
DAX Variables

Learn how to create a Variable to be used in DAX functions and expressions

15
DAX SWITCH expression

Learn how you can use the DAX SWITCH expression to replace nested IF statements

16
Working with Text in DAX

There are many TEXT expressions available in DAX, Expressions that will also you format, clean and extract data from TEXT.  In this video we will cover many of these TEXT expressions

17
Section Wrap up

An overview of section 1.

18
Section 1 Activities

How DAX works

1
How DAX works
2
Table Functions
3
Ignore Filters
4
Combining Table Functions
5
Nested Row Context

Learn to use DAX EARLIER expression 

6
Calculate

CALCULATE is known as one of the most powerful functions in DAX.  Find out why in this video

7
More on Calculate

Learn to use CALCULATE with two filters

8
DAX and Relationships
9
Section 2 Wrap up
10
Section 2 Activity

Time Intelligence Functions

1
Introduction to Time Intelligence

a quick overview of what to expect in this section on DAX Time Intelligence

2
Creating a Date Table

learn how to use DAX to create a DATE table, which is used for time intelligence functions

3
Multiple Date Tables

Learn how to address multiple date columns and tables when using DAX

4
Marking a Date Table

in some user interfaces you need to mark a date table as a date table. Don't forget to do this

5
Year to Date Calculations

In this video you will learn how to use DAX TOTALYTD, TOTALQTD and TOTALMTD expressions

6
How Time Intelligence Works

Following on from the previous lesson, in this video you will learn how these time intelligence functions work using Calculate.

7
Looking Back in Time

Sometimes you need to show same period last year, with dax time intelligence this is rather easy

8
Datesadd

learn more about how time intelligence works using datesadd

9
Parallel Periods
10
Moving Totals
11
Overall Total

Learn how to calculate the overall total ignoring any time period

12
Time Intelligence conclusion
13
Section 3 Activities

Conclusion

1
Course Conclusion
2
Thank you and bonus
3
Bonus
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.1
4.1 out of 5
751 Ratings

Detailed Rating

Stars 5
289
Stars 4
269
Stars 3
149
Stars 2
32
Stars 1
14
8e3e96a31ec33434e3cc23d80e5ca12b

Includes

3 hours on-demand video
6 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion