Mastering Intermediate DAX - Power BI, Power Pivot & SSAS
4.4 (183 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,487 students enrolled

Mastering Intermediate DAX - Power BI, Power Pivot & SSAS

Take your Data Analysis Expression Skills to the Next Level with DAX for Power BI, Power Pivot and Analysis Services
4.4 (183 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,487 students enrolled
Created by Paula Guilfoyle
Last updated 5/2020
English
Current price: $53.99 Original price: $89.99 Discount: 40% off
3 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 6 articles
  • 4 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Assignments
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Carry out difficult DAX expressions in Power BI, Power Pivot and SSAS
  • Have the ability to modify the current filter context with DAX expressions
  • Have the ability to modify how totals and subtotals are shown
  • Explain and work with Context Transition in DAX
  • Work with hierarchies and related functions
  • Calculate different moving averages without using Time Intelligence functions
  • Work with advanced calculations using iterators
  • Understand Bidirectional filters
  • Advanced relationships and UseRelationship
Requirements
  • You should be familiar with either Power Pivot, Power BI or Analysis Services
  • You should have a want to learn DAX (Data Analysis Expressions)
  • You should have a basic working knowledge of DAX ( material covered in Master the Fundamentals of DAX)
Description

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 refresh the fundamentals of how DAX works.  as this section is a refresher section we will work through example rather fast.. We will discuss Row context and Filter context, ALL, FILTER, RELATEDTABLE, CALCULATE, EARLIER, Relationships and much more.

The aim of section 2 is to introduce you to some DAX functions that we will be working with in more detail later in this course.  Many of the functions and expressions we will use in this section allow you alter or amend how totals and subtotals are shown. Functions covered will include ISFILTERED, ISCROSSFILTERED, ALLSELECTED, HASONEVALUE and SELECTEDVALUES

In Section 3 we will look in dept at CALCULATE and Contest Transition.  You will learn when to use FILTER inside CALCULATE and also when it is useful to combine CALCULATE and VALUES.

Section 4 is packed with Case Studies.  We will look at different problems and the solutions.  The first case study will focus on parent-child-hierarchy and include functions such as PATH and PATHLENGHT.  The second case study will look at different Moving Averages using EARLIER, FILTER, VALUES and AVERAGE.  In the third case study we will look at the use of Iterator functions over different granularities.

Finally you will learn about about advanced relationships.  We will look at BI Directional Filters and the use of USERELATIONSHIP

Each section of this course contains a folder to download. The folder contains the examples shown in the course and also activities for you to complete. These Activities are of utmost importance.  When it comes to learning DAX, practice is a must.

Who this course is for:
  • Analysis Services Users
  • Power BI Users
  • Excels Power Pivot Users
  • Those that need to model data using SSAS, Power BI or Power Pivot
  • Data Analyst, Finance and Accounting Staff, Marketing Professionals, Business Managers and all those involved with reporting
  • This course is NOT for you if you are already comfortable working with intermediate or advanced level DAX
Course content
Expand all 30 lectures 01:59:37
+ Introduction
6 lectures 35:19

A quick introduction to this course

Preview 02:14

Download files for section 1

Downloads for this section
00:04

before we get stuck into the meat of this course, we need to refresh the basics as you need a deep understanding of these to move on.  In this video we will look at row and filter context

The Basics Recap 1
24:17

Following on from the previous video, still on recap, in this video we will look at CALCULATE

Preview 06:55

In this video we will discuss the best way to take this course

How to take this course
01:36
Don't forget
00:12
+ Section 2 More DAX Expressions
6 lectures 17:42

The aim of this section is to introduce to to some dax functions that we will be working with in more detail later in this course.  Many of the functions and expressions we will use in this section allow you alter or amend how totals and subtotals are shown

Section 2 Intro
00:26

There are two files in the zip folder, one file contains the examples we worked on in this section and the other file contains the activities for this section.

Section Downloads
00:14

ISFILTERED and ISCROSSFILTERED will return a TRUE or FALSE when conditions are met.  This can provide a base for changing subtotals

ISFiltered and ISCrossfilter
06:11

Following on and looking at ways we can amend totals and subtotals in this video we will look at ALLSelected

ALLSelected
02:38

There are many alternatives when looking to alter the totals and subtotals, another option is the use of HASONEVALE

HasOneValue
03:40

new to DAX, and not yet available in all versions of excel is SELECTED VALUES.  This can also be used to alter subtotals

Preview 04:33
Complete the activities in this section
Section 2 Activities
2 questions
+ More Complex uses of Calculate
7 lectures 32:09

A quick overview to this section

Section Overview
00:34

Here you will find all the files and activities for this section

Section Downloads
00:04

If calculate contains filters in its syntax, when and why do you need to use an explicit filter inside of calculate?

When to use Filter inside Calculate
03:28

Values is a table expression.  It will return a table based on the values in the column selected.  It is not of much use on its own, but combined with other functions it can return a table in which expressions can be carried out on.

Using Values with Calculate
04:30

Context transition is a function of CALCULATE.  It converts the row context into the filter context.  This is the first of 3 videos on Contest Transation

Context transition
09:33

In this video we will walk thought a correct and incorrect expression showing you how context transition works

Context transition 2
09:57

When dealing with Context transition there are some problem you can encounter.  Learn about these issues and how to overcome them in this video

More complex context transition issues
04:03
Advanced Parameter Table – Dynamic Segmentation
Section 3 Activity
2 questions
+ Case Studies
11 lectures 34:25
Section Introduction
00:50
Section Activities and Downloads
00:03

In this video we will present the problem that we are about to work through


hierarchies - case study 1- the problem
02:48

Using parent child hierarchies we will set about solving the problem as presented in the previous video

hierarchies - case study 1- the solution
08:27
Moving Averages - case study 2 - the problem
01:38

In this video we are not going to use time intelligence functions as one might expect.  Instead we will focus on using the Earlier Function.

Moving Averages - case study 2 - the solution
05:39
Iterators - case study 3 - the problem
02:18
Iterators - case study 3 - the solution
09:31
carry out the following practice activities to make sure you understand section 4
practice activities for section 4
3 questions

A quick wrap up on this course

Course Conclusion
01:11
Bonus
00:49
Bonus Material
01:11