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 (1404)
Mijalis Alexandros Méndiz Pazos (Apr 14, 2024) Awesome introduction to the basic concepts of the DAX language.
Akshat Raj (Apr 11, 2024) This course is very helpful.
Gary Netherton (Apr 10, 2024) Great introduction to DAX. Very interesting and thorough review.
MOHAN TRIVEDI (Apr 9, 2024) Excellent
Harshal Pawar (Apr 6, 2024) Good Course with clear explanation.
Domingo Juan (Apr 2, 2024) Thank you so much for this wonderful course, I have learned a lot and I appreciate your effort and dedication to teaching DAX. Thank you.
Judith Morsnowski (Apr 2, 2024) Really good, thanks!
Yassine Artiba (Mar 29, 2024) Perfect
Simon Schäfer (Mar 25, 2024) Great, thank you very much for all the great and very understandable explanations and examples.
Enmanuel López (Mar 21, 2024) This course was amazing to carry on understaning all of the most important topics in DAX. Good Job. Keep it up!
David Gim (Mar 20, 2024) Very good to me. Thank you.
Now I finished step 2.
Next Go to step 3.
Alberto Mazzoleni (Mar 17, 2024) Very clear explanations
Fernanda Rivera (Mar 17, 2024) Wonderful course! very clearly explained.
Mansi Patel (Mar 15, 2024) It was great learning from SQLBI about DAX language. The explanations were simple and great.
Sagar Soni (Mar 11, 2024) great course. full of value
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