The DAX Workshop - Part 1

Learn DAX by working through real-world business scenarios via 45 exercises and tutorials

4.80 (228 reviews)
Udemy
platform
English
language
Other
category
instructor
1,169
students
5 hours
content
Aug 2020
last update
$44.99
regular price

What you will learn

This is a hands on course. You will learn how to work through many common business related problems and scenarios

The importance of understanding the current filter context and how it affects your measures is stressed in each exercise

By working through many exercises you will understand the CALCULATE function and how understanding "context transition" is essential

You will learn how to build "primitive" time intelligence functions then build higher level functions on top of them to solve common reporting requirements

You will be working with real-world data models based on Contoso, AdventureWorks and a baseball model containing 145 years of data

Description

The DAX Workshop is a course that allows the student to get proficient in the DAX language by practicing on all sorts of common business scenarios. Approximately 45 practice exercises, and a half-dozen tutorials, exist covering most of the important parts of the DAX language. The focus of this course is not so much on teaching the language, although there is a lot of that. The main focus is working through exercises to clearly show how the DAX language can be used to solve common business reporting requirements.

Content

Introduction

Introduction
Who Should and Shouldn't Purchase this Course
What Will be Covered?
What's Included in this Course?

Evaluation Context

Understanding Row and Filter Contexts

Calculated Columns and Measures

Understanding Calculated Columns and Measures

Basic Table Functions

Basic Table Functions

Common Iterators

Common Iterators

CALCULATE

Using CALCULATE

Dates and Date Tables

Dates and Date tables in DAX

Time Intelligence

Time Intelligence functions in DAX

Miscellaneous Exercises

Miscellaneous Exercises

Congratulation! / What's Next?

Congratulations! / What's Next?

Bonus Section

Bonus Lecture

Screenshots

The DAX Workshop - Part 1 - Screenshot_01The DAX Workshop - Part 1 - Screenshot_02The DAX Workshop - Part 1 - Screenshot_03The DAX Workshop - Part 1 - Screenshot_04

Reviews

Nariboyana
September 4, 2023
Well explained and easy to follow lectures. I learned a lot of nuances in Dax from this course. I highly recommend this course to anyone who is interested in improving his Dax ability.
Andrew
September 6, 2022
I found this course challenged me. I learned a great deal when completing the assignments, as I often had to look things up on the internet in order to complete the assignment. Which is the way I work when developing a Power BI tool. Randy's explanations were simple and allowed me to understand his solution to the assignment. This course was well worth me completing and I feel more confident with DAX. I'm now looking forward to completing part 2 of the DAX Workshop.
Fadwa
February 21, 2022
I love the way Mr.Randy explains the complex scenarios into small,simple thing. Highly recommend for those want to practise a lot and have the knowledge of how writing DAX queries
Jonas
January 8, 2022
Like always Randy takes you through the course in a certain path which makes you understand everything in a nice and smooth way
Jeff
September 3, 2021
I signed up because of how you described most other courses' lack of exercises and real-world practice. I can grok the concept, but I need to dig in on it. I thought this first lesson was really clear, but I found myself googling quickly on how to get the Contoso 2 dataset loaded into Power BI. Did I miss a link/instuctions on that? If not maybe you could consider including them? Thanks Randy, great so far!
Carol
January 13, 2021
So far this course is great. I'm really excited to apply the skills I learn in this course at my job.
Chakravarthi
November 23, 2020
This course deserves 10 stars. This is probably the best course on Udemy if you are seriously looking to learn DAX by practice.
Prince
May 12, 2020
Voice is less audible in some video moreover video quality (clarity) is not upto the mark even on 720P
Rochelle
May 8, 2020
I've gone through the first section of assignments and have determined I do not care for the way this is being taught. I wish I had started it sooner and would have been able to get a refund. The structure is very odd compared to other courses on Udemy.
Nitin
May 4, 2020
Course is really amazing for practice in DAX. Randy Minder is gentleman he always respond your query with proper solution.I have enrolled for DAX part2 as well. Just a small feedback for a course please don't use heavy Datasets.
Lim
April 10, 2020
Course gave a good introduction to DAX. However the youtube video resolution was no sharp which is painful to the eyes. furthermore I realized I cannot go back to the previous lectures as it is disabled after one completes the exercises
Joachim
April 6, 2020
I have just gone through the first 20 %, and I do not like the teaching method. There is not enough explanation of the DAX functions and concepts before we are asked to do assignments. We end up relying on the assignment solutions. I really prefer if there is a video explaining the concepts one at a time, while going through some examples with it. And then we can be asked to solve similar questions afterwards. There are also some bad ideas in the course content. For example, why make us work through assignments that take a lot of time to load, why use calculated columns when measures are better, instead of coming up with examples/assignments, where the calculated columns should be used. I have noticed some other small things that in themselves are not important, but point to a larger lack of attention to detail: For example, I think it is suboptimal to use nested IF statements when you could use the time to teach us SWITCH(...) and SWITCH(TRUE()...). I also think the measure and column names should have been chosen more carefully.
Craig
April 1, 2020
Real World examples of Dax and Power, hands on learning and explanation of Filter Context and deeper dive into Filter, Calculate and Related functions.
Henri
March 18, 2020
I personally find this course a good match since it exclusively focuses on learning DAX in the Power BI environment. This course is also an easy pick in the sense that it does not require previous experience in Excel.
Manoj
March 12, 2020
This is an amazing course and I loved it thoroughly. It really makes you skilled in DAX and Randy has a very clear way of explaining the solutions. I am very glad that I took this course and highly recommend anyone who is new to DAX. Thanks Randy for creating this wonderful course. It is worth much more than price of it.

Charts

Price

The DAX Workshop - Part 1 - Price chart

Rating

The DAX Workshop - Part 1 - Ratings chart

Enrollment distribution

The DAX Workshop - Part 1 - Distribution chart

Related Topics

2475238
udemy ID
7/24/2019
course created date
2/8/2020
course indexed date
Bot
course submited by