Fundamentals of Data Analysis Expression DAX
4.1 (25 ratings)
7,379 students enrolled

# Fundamentals of Data Analysis Expression DAX

Data Analysis Expression DAX functions, examples and use cases
4.1 (25 ratings)
7,379 students enrolled
Last updated 5/2020
English
English [Auto]
Current price: \$139.99 Original price: \$199.99 Discount: 30% off
11 hours left at this price!
30-Day Money-Back Guarantee
This course includes
• 1.5 hours on-demand video
• Access on mobile and TV
• Certificate of Completion
Training 5 or more people?

What you'll learn
• In this course, you will get understanding of Data Analysis Expression DAX with examples and use cases
Requirements
• Microsoft Power BI installed (this course includes video on installing Power BI) an initial level understanding of data analytics and visualization
Description

Data Analysis Expression DAX Tutorial which includes topics on;

-Syntax

-Row Context

-Filter Context

-Calculated Column

-Measure

-Implicit Filter

-Explicit Filter

-Iterators

-Evaluation Context

Examples of simple to complex functions including

-SUM function

-SUMX function

-AVERAGEX function

-CONCATENATEX function

-FILTER function,

-CALCULATE function

-RELATED function

-RELATEDTABLE function etc.

These functions are discussed with reference to business logic, use cases and examples of visualization.

Who this course is for:
• Anyone who have interest in learning of DAX for Data Analytics and Visualization
Course content
Expand 9 lectures 01:19:03
+ Introduction
9 lectures 01:19:03

Data Analysis Expression DAX Expression and Query Language Tutorial

-Syntax

-Row Context

-Filter Context

-Calculated Column

-Calculated Measure Examples

You will definitely love this course because it is simple, easy and takes you levels ahead in Data Analysis Expression DAX without even noticing :)

Preview 07:28

In this video, we will be discussing how to install Microsoft Power BI.

-Options available for installing Power BI

Preview 03:30

In this video, we will be discussing;

-Calculated columns with examples.

-Many to 1 and 1 to many relationships within DAX.

-Related Function

-Relatedtable Function

-SUMX

DAX 02 - Calculated Columns with Example Functions
12:32

In this video, we will discuss;

-What is a measure and what it does?

-Implicit and Explicit filters.

-Isfiltered function

-Simple example with SUM function.

-Min function with demo

-What measures cant do?

-Use of CALCULATE function to filter data.

DAX 03 - Measures in DAX
16:34

In this video, we will discuss;

-Calculate vs Filter functions (When calculate is used and when filter function is used with examples)

-Demo of a filter function.

DAX 04 - Filter Function in a Measure
09:56

In this video, we will discuss;

-ALL function (When it is used and what it does)

-ALL with single column vs table.

-Demo of ALL with Calculate and Sum functions

DAX 05 - All Function in a Measure
06:09

In this video, you will find;

-What are iterators?

-What makes iterators unique?

-Iterator function parameters.

-Example of an Iterator function "AVERAGEX"

DAX 06 - Iterators
06:29

In this video, we will be discussing about iterator functions;

-SUMX

-AVERAGEX

-CONCATENATEX with business use case examples.

DAX 07 - Iterator Examples
07:34

In this video, our discussion will focus on the evaluation context;

-When an expression gets evaluated or

-What DAX engine can see when an expression gets evaluated.

Examples of evaluation context with

-RANKX function

-SUMX function

-ALL function and

RELATEDTABLE

DAX 08 - Iterator Evaluation Context
08:51