Name: Mastering Intermediate DAX - Power BI, Power Pivot & SSAS
Rating: 4.5 (453 reviews)

Udemy Business

Enseigner sur Udemy

Transformez vos connaissances en véritable opportunité et touchez des millions de personnes du monde entier.

Votre panier est vide.

Continuer vos achats

Se connecter

S’inscrire

Créé parPaula Guilfoyle CPA

Dernière mise à jour : 05/2020

Anglais

Ce que vous apprendrez

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

Contenu du cours

4 sections • 30 sessions • 1 h 59 min de durée totale

Introduction2:14
A quick introduction to this course
Downloads for this section0:04
Download files for section 1
The Basics Recap 124:17
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 26:55
Following on from the previous video, still on recap, in this video we will look at CALCULATE
How to take this course1:36
In this video we will discuss the best way to take this course
Don't forget0:12

Section 2 Intro0:26
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 Downloads0:14
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.
ISFiltered and ISCrossfilter6:11
ISFILTERED and ISCROSSFILTERED will return a TRUE or FALSE when conditions are met. This can provide a base for changing subtotals
ALLSelected2:38
Following on and looking at ways we can amend totals and subtotals in this video we will look at ALLSelected
HasOneValue3:40
There are many alternatives when looking to alter the totals and subtotals, another option is the use of HASONEVALE
SelectedValues4:33
new to DAX, and not yet available in all versions of excel is SELECTED VALUES. This can also be used to alter subtotals
Section 2 Activities

Section Overview0:34
A quick overview to this section
Section Downloads0:04
Here you will find all the files and activities for this section
When to use Filter inside Calculate3:28
If calculate contains filters in its syntax, when and why do you need to use an explicit filter inside of calculate?
Using Values with Calculate4:30
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.
Context transition9:33
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 29:57
In this video we will walk thought a correct and incorrect expression showing you how context transition works
More complex context transition issues4:03
When dealing with Context transition there are some problem you can encounter. Learn about these issues and how to overcome them in this video
Section 3 Activity

Section Introduction0:50
Section Activities and Downloads0:03
hierarchies - case study 1- the problem2:48
In this video we will present the problem that we are about to work through
hierarchies - case study 1- the solution8:27
Using parent child hierarchies we will set about solving the problem as presented in the previous video
Moving Averages - case study 2 - the problem1:38
Moving Averages - case study 2 - the solution5:39
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.
Iterators - case study 3 - the problem2:18
Iterators - case study 3 - the solution9:31
practice activities for section 4
Course Conclusion1:11
A quick wrap up on this course
Bonus0:49
Bonus Material1:11

Prérequis

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.

À qui ce cours s'adresse-t-il ?

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

Ce que vous apprendrez

Découvrir les sujets associés

Contenu du cours

Introduction6 sessions • 35 min

Section 2 More DAX Expressions6 sessions • 18 min

More Complex uses of Calculate7 sessions • 32 min

Case Studies11 sessions • 34 min

Prérequis

Description

À qui ce cours s'adresse-t-il ?