Analyzing Data with DAX for Power BI

WELCOME TO THE COURSE

5 Parts - 0:02 Hr

Welcome to the course

Welcome to the course.

2 Min

Attachments:

Download dataset

27.33 MB MB

Dataset walkthrough

12 bytes bytes MB

Connecting and Transforming the Data

0 bytes MB

Data Modeling

0 bytes MB

INTRODUCTION

11 Parts - 0:03 Hr

Introduction to DAX

0 bytes MB

DAX Calculations

DAX Calculations in Power BI

2 Min

Attachments:

DAX Functions in Power BI

0 bytes MB

DAX Operators

0 bytes MB

Referencing Model objects

0 bytes MB

Using Variables

0 bytes MB

Using Variables

1 Min

Attachments:

Using variables Demo

0 bytes MB

Adding Comments in DAX

0 bytes MB

Adding Comments in DAX Demo

0 bytes MB

Adding Comments in DAX Demo

0 bytes MB

CALCULATED TABLES

12 Parts - 0:02 Hr

Introduction to calculated tables

0 bytes MB

Using the VALUES Function

0 bytes MB

Using the VALUES Function with Table Input

0 bytes MB

Using the DISTINCT Function

2 Min

Attachments:

Combine multiple Tables with the UNION Function

0 bytes MB

Create Date Table with the CALENDAR Function

0 bytes MB

Create Date_Table with CALENDARAUTO

0 bytes MB

Add Columns to a Table with ADDCOLUMNS Function

0 bytes MB

Create a Table with the FILTER Function

0 bytes MB

Using the FILTER Function with Logical operators

0 bytes MB

Summarize Data with the SUMMARIZE Function

0 bytes MB

Calculated Tables Review

0 bytes MB

CALCULATED COLUMNS

5 Parts

Introduction to Calculated Columns

0 bytes MB

Add Calculated Column with the IF Function

0 bytes MB

Understanding Row Context

0 bytes MB

Using the RELATED Function to retrieve Data

0 bytes MB

Using the RELATEDTABLE Function

0 bytes MB

MEASURES AND AGGREGATE FUNCTIONS

8 Parts - 0:05 Hr

Introduction to Measures

5 Min

Attachments:

Creating Measures Table

0 bytes MB

Introduction to AGGREGATE Functions

0 bytes MB

Using the SUM Function to aggregate values

0 bytes MB

Using the COUNTROWS Function

0 bytes MB

Using the AVERAGE Function

0 bytes MB

Aggregate values using the MIN and MAX Functions

0 bytes MB

Difference between Measures and Calculated Columns

0 bytes MB

CONTEXT

4 Parts

Understanding Evaluation Context

0 bytes MB

Understanding FILTER Context

0 bytes MB

How FILTER Context works in Power BI

0 bytes MB

FILTER Context and Cross Filter Direction

0 bytes MB

ITERATORS

5 Parts - 0:04 Hr

Introduction to Iterators(X-Aggregators)

0 bytes MB

SUMX

0 bytes MB

AVERAGEX

0 bytes MB

MINX

Working with MINX

4 Min

Attachments:

MAXX

0 bytes MB

THE CALCULATE FUNCTION

17 Parts - 0:11 Hr

Introduction to the CALCULATE Function

0 bytes MB

Understanding the CALCULATE Function

0 bytes MB

Using the CALCULATE Function Demo 1

0 bytes MB

Using the CALCULATE Function Demo 2

0 bytes MB

Using the CALCULATE Function Demo 3

0 bytes MB

Creating a virtual table with the FILTER Function

0 bytes MB

Introduction to Filter Modifiers

0 bytes MB

Introduction to REMOVEFILTERS

0 bytes MB

Using REMOVEFILTERS with CALCULATE

0 bytes MB

Introduction to the ALL Function

0 bytes MB

Using the ALL Function with CALCULATE

0 bytes MB

ALLSELECTED Introduction

0 bytes MB

ALLSELECTED Demo

0 bytes MB

ISINSCOPE Function

0 bytes MB

CalculatedTable Function

0 bytes MB

Calculated Table Demo 1

CalculatedTable in Action.

4 Min

Attachments:

Calculated Table Demo 2

7 Min

Attachments:

RANKING FUNCTIONS

5 Parts

Introduction to RANKX

0 bytes MB

RANKX Demo

0 bytes MB

TopN Function Introduction

0 bytes MB

Creating table with TopN Function

0 bytes MB

Highlight Top N items on a visual

0 bytes MB

Play

TIME INTELLIGENCE CALCULATIONS

16 Parts

Introduction to Time Intelligence

0 bytes MB

Using the PREVIOUSYEAR Function to perform YoY Analysis

0 bytes MB

Using the PREVIOUSMONTH Function

0 bytes MB

Performing MoM Analysis

0 bytes MB

Using the PREVIOUSDAY Function

0 bytes MB

Using the DATEADD Function

0 bytes MB

Using DATEADD for MoM Analysis

0 bytes MB

Using SAMEPERIODLASTYEAR Function

0 bytes MB

Calculating Running Total with TOTALYTD Function

0 bytes MB

Running Totals with different Fiscal Year

0 bytes MB

Using the TOTALMTD Function

0 bytes MB

Using the DATESYTD Function

0 bytes MB

Using the DATESMTD Function

0 bytes MB

Continuous Running Totals Method 1

0 bytes MB

Continuous Running Totals Method 2

0 bytes MB

Time Intelligence Review

0 bytes MB

WORKING WITH RELATIONSHIPS

3 Parts

Additional Dataset

31.55 KB MB

Create virtual relationships with TREATAS

0 bytes MB

Working with inactive relationships with USERELATIONSHIP

0 bytes MB

Analyzing Data with DAX for Power BI

About this course

Comments (0)

Reviews (0)

Gift this course

Course specifications

THOMAS FESTUS CUDJOE

Tags

Report course

Share

Buy with points

18 Weeks Business Intelligence and Data Analytics