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

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.

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Downloads for this section

Lecture 3 The Basics Recap 1

Lecture 4 The Basics Recap 2

Lecture 5 How to take this course

Lecture 6 Don't forget

Section 2: Section 2 More DAX Expressions

Lecture 7 Section 2 Intro

Lecture 8 Section Downloads

Lecture 9 ISFiltered and ISCrossfilter

Lecture 10 ALLSelected

Lecture 11 HasOneValue

Lecture 12 SelectedValues

Section 3: More Complex uses of Calculate

Lecture 13 Section Overview

Lecture 14 Section Downloads

Lecture 15 When to use Filter inside Calculate

Lecture 16 Using Values with Calculate

Lecture 17 Context transition

Lecture 18 Context transition 2

Lecture 19 More complex context transition issues

Section 4: Case Studies

Lecture 20 Section Introduction

Lecture 21 Section Activities and Downloads

Lecture 22 hierarchies - case study 1- the problem

Lecture 23 hierarchies - case study 1- the solution

Lecture 24 Moving Averages - case study 2 - the problem

Lecture 25 Moving Averages - case study 2 - the solution

Lecture 26 Iterators - case study 3 - the problem

Lecture 27 Iterators - case study 3 - the solution

Lecture 28 Course Conclusion

Lecture 29 Bonus

Lecture 30 Bonus Material

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