DAX with AI: Scenarios – Video Course
IMPORTANT
This course will be released by November 30, 2026 . We suggest you wait until then to purchase it, unless you want to take advantage of the
bundle offer .
This course shows how to manage AI agents with complex scenarios, where your work is mainly to control the direction of the development, which includes writing DAX code and modifying the model so that it generates the correct result for the business problem described.
The course is a library of nine complete scenarios. Each one starts from the business requirement and ends with a model and a set of measures you must review and validate. A separate track of shorter lessons covers the concepts that come back in more than one scenario (grain, additivity, virtual tables, lineage, and others). Every scenario lists the lessons it requires, so you can take only the ones you need for the use case you are interested in, or you can just go through the whole course from A to Z.
Presentation of DAX with AI: Scenarios
Preview of DAX with AI: Scenarios
FREE
Concept: Calculation Contracts
Calculation Contracts and Strength of Claims
FREE
Demo and Prompts
What is an average sale?
FREE
Agree on a short contract
FREE
Check and document the answer
FREE
Inventory Availability from Movements, Sparse Snapshots, and Reservations
Inventory Availability from Movements, Sparse Snapshots, and Reservations
FREE
Demo and Prompts
Introduction and prerequisites
FREE
Introduce the model and define the on-hand contract
FREE
Expose the sparse-snapshot failure
Reconstruct end-of-day on hand
Searching for a better algorithm
Reconstruct end-of-day reservations
Calculate availability and daily behavior
Retain source checks as a reusable test
Recap the module
Common concepts (available by Nov. 30, 2026)
Grain, Iteration Grain, Additivity, and Totals
Populations, Denominators, and Validation
Filter Paths and Relationship Semantics
Time, Events, States, and Snapshots
Reusable DAX: Measures, Functions, and Calculation Groups
Virtual Tables, Lineage, and Set-Based DAX
Scenarios (available by Nov. 30, 2026)
Currency Conversion with Historical and Current Rates
Comparable-Store Sales
Yearly Product Status Transitions
Support Ticket Resolution and Interaction Journeys
Budget, Forecast, and Actuals at Incompatible Grains
Shared-Cost Allocation and Profitability
Financial Statements with Ragged Accounts
Workforce Analytics
What is included
This video course contains 149 minutes of training, for a total of 31 lectures.
Our training platform tracks your progress and resumes the course from where you left off.
The course is accessible on desktop and mobile browsers for
36 months after the purchase date .
The videos are hosted by SQLBI on vimeo.com – if you are in a country that blocks access to this platform, you will need a VPN to watch the videos.
You can download all the exclusive content produced by our trainers for this video course, including all the examples and the exercises. Take a look at the curriculum for more details.
In this video course both our senior trainers are in front of the camera. The conversational style allows for more entertaining lectures, and it answers the most common questions on the topics covered.
After completing all the lectures in this video course,
you will be able to download a certificate of completion in PDF format from your student dashboard.
Options
Volume discounts are offered when you purchase multiple courses within one same order. To obtain the discount, just press the
Enroll Now button and add more courses or students in the next step. The discount cannot be applied to transferable licenses.
Amount
Discount
$ 500 +10% $ 1000 +15% $ 1500 +20% $ 4000 +25%
You can get a group discount by registering 10 or more students to the same course. To obtain the discount, just press the
Enroll Now button and add more students in the next step.
Students
Discount
10+ 25% 25+ 30% 50+ 40% 100+ 50% 200+ 65% 300+ 70% 350+ 72%
This video course is also available with a transferable license, which is a convenient solution for teams.
License type
Price
Duration
Student(s)
Untransferable
$ 199
$ 159
36 months
1
Transferable
$ 790
$ 632
36 months
Unlimited *
* The number of concurrent access reflects the number of licenses you have purchased. E.g. If you have a single transferable license, only one student can access the course at a time. To give another student access to the course, you must revoke the access and assign the license to the different student.
More on licenses
This video course is also available in the following bundles for enterprise customers:
Enterprise Advanced Bundle Enterprise Advanced Bundle (Transferable)
Enterprise bundles
Training Platform
Along with subtitles, you can view a transcript of the content of each lecture in different languages.
The transcripts are synchronized with the video and you can easily jump from one segment to another.
Learn more
Save the most interesting lectures for future use and easy access with bookmarks.
Press the marker button in every lecture and check the Bookmarks tab.
Learn more
You can highlight segments of the video transcripts, like you would with a printed book. Highlights are automatically saved and quickly accessible from your Bookmarks tab.
Learn more
In every section of this course, you will find an easy way to start a discussion about a topic relevant to the course.
Our team usually replies within a few hours!
Learn more
A team management dashboard is available if you choose to assign this course after the purchase or you get a transferable license.
Learn more