bestcourses is supported by learners. When you buy through links on our website, we may earn an affiliate commission. Learn more
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
Created by Paula Guilfoyle CPA & MVP, offered on Udemy
To make sure that we score courses properly, we pay a lot of attention to the reviews students leave on courses and how many students are taking a course in the first place. This course has a total of 2564 students which left 308 reviews at an average rating of 4.5, which is average.
We analyze course length to see if courses cover all important aspects of a topic, taking into account how long the course is compared to the category average. This course has a length of 2 hours , which is pretty short. This might not be a bad thing, but we've found that longer courses are often more detailed & comprehensive. The average course length for this entire category is 5 hours 20 minutes.
This course currently has a bestcourses score of 5.9/10, which makes it an average course. Overall, there are probably better courses available for this topic on our platform.
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
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.
What you will 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
- 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)