DAX is a tricky language to work with, one thing that makes it particularly tricky is that you have to visualize what your code is doing almost 100% in your head.
That is, unless you can whiteboard it. In this presentation SkyPoint Cloud's Sr. Analytics Consultant and Data Wizard, Brian Grant, will walk you through the basics of DAX sketches which allow you to pick a filter setup and whiteboard what's happening in a set of nested visual cards and boxes representing changing row and filter context.
What you will walk away with is a much better sense of what your code is actually doing and how to think about solving problems in the future.
Brian Grant is a Senior Analytics Consultant with local data heroes SkyPoint Cloud and SkyPoint CSG. Having spent his early years deep in the study of acting and screenwriting, he finally graduated Summa Cum Laude with a degree in Economics. His driving belief is that the biggest barrier most people face when learning technology isn't technology at all, but language. Taught the right way, most people can learn most things; helping people learn skills that are "too technical" for them is his greatest joy.
Timestamps
0:32 What is DAX?
2:31 What are DAX Sketches/ DAX Sketching?
4:08 Friendly DAX & the Pocket Translator. Shortform DAX & Mechanical DAX
9:41 What’s in a DAX Sketch? (Initial Filter frame, Measures, & slicers
11:56 How to Add a frame within a frame (calculate function)
14:00 Taking a snapshot (Values & Temp tables in DAX)
23:10 Countrows with DAX Snapshots
24:20 Using SUMX Iterator with DAX Snapshots
33:23 SUMX vs. Iterator Filters in DAX
45:05 Creating a new DAX frame with temp table as a filter
46:35 Quick Review: 1. Filter Frame 2. Snapshots (Iterators, SUMX, Filters)
50:57 Live DAX Sketching Example 1 – Total Sales
59:27 Live Live DAX Sketching Example 2 – Total Transactions
1:07:54 DAX Sketching as an interactive de-bugger
- An Introduction to DAX Whiteboarding w/ @straighttovideo503 ( Download)
- Elements of DAX 03-00: Iterator Chapter Introduction ( Download)
- DAX Sketches w/ Brian Grant: An Intro to Context Transition ( Download)
- DAX Sketches w/ Brian Grant: The RELATED function and Table Expansion ( Download)
- Elements of DAX 06-00: Filter Revisers (Pt1) Chapter Introduction ( Download)
- How To - Show Measures on Rows ( Download)
- Power BI DC July 2021 | Seeing Inside DAX with Brian Grant ( Download)
- A Comprehensive Approach to Data Modeling ( Download)
- Brian Grant Building Your Own Power BI Image Generating Measures ( Download)
- Guided Tour of Exciting New Power BI Features! 2019 - Portland Power BI UG ( Download)
- Tabular Editor in an Hour ( Download)
- How to Build a Star Schema Data Model ( Download)
- Totals at the Top of a Power BI Matrix Visual ( Download)
- Power BI Report Design Tips & Tricks w/ @miguelmyers6093: Strategic Thinking Process ( Download)
