Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

The DAX Workshop - Part 1

via Udemy

Overview

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

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.

Syllabus

  • Introduction
  • Evaluation Context
  • Calculated Columns and Measures
  • Basic Table Functions
  • Common Iterators
  • CALCULATE
  • Dates and Date Tables
  • Time Intelligence
  • Miscellaneous Exercises
  • Congratulation! / What's Next?
  • Bonus Section

Taught by

Randy Minder

Reviews

4.3 rating at Udemy based on 305 ratings

Start your review of The DAX Workshop - Part 1

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.