Introducing DAX Video Course
This is an introductory video course about the DAX language. DAX is the native language of Power BI, Power Pivot for Excel, and SSAS Tabular models in Microsoft SQL Server Analysis Services. The training is aimed at users of Power BI, Power Pivot for Excel, and at Analysis Services developers that want to move the first steps with DAX.
The goal is to teach the DAX language using Power BI for all the examples. You can download the initial Power BI Desktop file used in the demos and repeat all the steps shown in the videos. The same concepts can be used also on Power Pivot and on Analysis Services Tabular. The course is made of 150 minutes of lectures. You can watch the videos at anytime and the system will keep track of your advances. Within the course you can download the slides and the initial Power BI file used in the demos.
Presentation of Introducing DAX
Presentation of Introducing DAX Video Course
Slides and examples
How to download and use the examples
Introduction to DAX
Introduction to DAX
What is DAX?
Calculated Columns
Measures
Aggregation Functions
Using Variables
Table Functions
Table Functions
Calculated Tables
Filtering a Table
Removing Filters
Mixing Filters
DISTINCT
RELATEDTABLE
Evaluation Contexts
Evaluation Contexts
What is an Evaluation Context?
Example of a Filter Context
Row Context
There are Always Two Contexts
CALCULATE
CALCULATE
What is CALCULATE?
Filters are Tables
Evaluation Contexts and Relationships
Evaluation Contexts and Relationships
Filters and Relationships
Row Context - Many Tables
Filter Context - Many Tables
Context Transition
Time Intelligence in DAX
Time Intelligence in DAX
Date Table
What is Time Intelligence?
Conclusion
Student Rating
Student Reviews (1407)
faizal Muhammed (Apr 16, 2022) Fantastic!! Thanks for free content.
Eric Majri (Apr 15, 2022) Excellent classes that's clarified many questions I asked myself. Thanks a lot.
Diego González (Apr 13, 2022) clear fundamentals, very useful!
Moussa Bouguerra (Apr 13, 2022) Jolie et tres intuitif ... merci Alberto
Nicole Aalders (Apr 12, 2022) Flows nicely to build concepts and reinforce learning.
Hermes Banico (Apr 12, 2022) I found the other person who was off screen distracting. I was following the instructor ok, but the other person kept interrupting.
Filip Živković (Apr 9, 2022) Comprehensive but simple in the same time! You saved me so much time. Thank you so much!
Nicola Artuso (Apr 8, 2022) Very interesting and foremost very clearly explained
Hafiz Abdul Hannan (Apr 7, 2022) very good intro, gave real helpful insights
MAURICIO P S SOBRAL (Apr 6, 2022) Excellent course, excellent teaching!
Svetlana Dolgopolova (Apr 2, 2022) Great course!
John Edgar Mihelic (Apr 1, 2022) I learned a lot and the presentation was great
Maryia Ivanko (Mar 31, 2022) Great explanation!
Simone Piwowarczyk (Mar 30, 2022) Fantastic!!!!!!!!!!:)
Thank you very much!!!!!!!!!!!! =D
Rick Milliken (Mar 26, 2022) Awesome!!! Great Job.
What is included
This video course contains 3 hours of training, for a total of 32 lectures.
Our training platform tracks your progress and resumes the course from where you left off.
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.
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