SQLBits 2024
DAX in a Day
Learn in one day the core concepts of the DAX language, with a lot of focus on the evaluation context. (in-person only)
Power BI, Analysis Services Tabular and Excel users can improve their data models with the Data Analysis eXpression (DAX) language. Although this language looks a bit like Excel, many people struggle in writing more advanced DAX expressions.
In this one day workshop the different aspects of DAX are discussed. What are the types used in DAX? How to use DAX for creating calculated columns, tables and mainly measures? A lot of attention goes into the evaluation context: What is row context and filter context? How does context transition and expanded tables relate to this?
A lot of DAX code will be dissected to illustrate these concepts, such that you leave with a better idea of how to use DAX for solving your business needs.
Please note that this is an in-person only session, and is not available to virtual attendees
In this one day workshop the different aspects of DAX are discussed. What are the types used in DAX? How to use DAX for creating calculated columns, tables and mainly measures? A lot of attention goes into the evaluation context: What is row context and filter context? How does context transition and expanded tables relate to this?
A lot of DAX code will be dissected to illustrate these concepts, such that you leave with a better idea of how to use DAX for solving your business needs.
Please note that this is an in-person only session, and is not available to virtual attendees
Speakers
Nico Jacobs's other proposed sessions for 2026
Fabric Data Agents - 2026
The Power of Paginated Reports - 2026
What are Fabric Materialized Lake Views - 2026
When Translytical Task Flow meets Fabric Data Function - 2026
It's about time: Calendar-based time intelligence in Power BI - 2026
Nico Jacobs's previous sessions
Getting started with SparkML in Microsoft Fabric
Microsoft Fabric supports machine learning in their Spark notebooks. See an end-to-end demo of how Fabric data is used to build machine learning models upon, which are then used to make predictions about other Fabric datasets.
DAX in a Day
Learn in one day the core concepts of the DAX language, with a lot of focus on the evaluation context. (in-person only)
What Power BI users need to know about R
Learn the basic knowledge to use the R language in Power BI as source, transformation or visualization
Analyze data streams with Azure stream analytics
Azure stream analytics is a new Azure service for analyzing streaming data.