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
The DAXWorkshop 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.