Learn DAX by working through real-world business scenarios via 45 exercises and tutorials
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.
What you’ll 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.
Course Content
- Introduction –> 5 lectures • 9min.
- Evaluation Context –> 1 lecture • 11min.
- Calculated Columns and Measures –> 1 lecture • 2min.
- Basic Table Functions –> 1 lecture • 4min.
- Common Iterators –> 1 lecture • 4min.
- CALCULATE –> 1 lecture • 17min.
- Dates and Date Tables –> 1 lecture • 4min.
- Time Intelligence –> 1 lecture • 5min.
- Miscellaneous Exercises –> 1 lecture • 1min.
- Congratulation! / What’s Next? –> 1 lecture • 2min.
- Bonus Section –> 1 lecture • 1min.
Requirements
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.