DAX topics
12 short topics in SQL and Relational Databases. Each one is a single focused exercise with a clear piece of evidence at the end.
12 topics, one exercise each.
Work through them in order, or jump to the one you need.
These are draft topic outlines (draft; instructor review pending). Full lessons follow after review; ask Ajay if you need a topic sooner.
- 01
Query expression syntax
Demonstrate query expression syntax in a focused DAX example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 02
Data selection and projection
Demonstrate data selection and projection in a focused DAX example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 03
Predicates and filtering
Demonstrate predicates and filtering in a focused DAX example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 04
Grouping and aggregation
Demonstrate grouping and aggregation in a focused DAX example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 05
Ordering and result windows
Demonstrate ordering and result windows in a focused DAX example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 06
Combining data sources
Demonstrate combining data sources in a focused DAX example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 07
Null and missing-value behavior
Demonstrate null and missing-value behavior in a focused DAX example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 08
Reusable query parameters
Demonstrate reusable query parameters in a focused DAX example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 09
Query composition and subexpressions
Demonstrate query composition and subexpressions in a focused DAX example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 10
Query execution and optimization reasoning
Demonstrate query execution and optimization reasoning in a focused DAX example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 11
Query result validation
Demonstrate query result validation in a focused DAX example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 12
Query integration with applications
Demonstrate query integration with applications in a focused DAX example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course →
Learn the same ideas beyond DAX.
These courses share topics with this one, so you can compare how each language or tool handles the same concept.
More in Markup configuration and query languages.
You have the curiosity.
Let’s turn it into capability.
Start with a practical workshop or bring a specific question to Ajay.