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 (1487)
AKBAR ATTAMIMI (Jul 14, 2024) Amazing course added with clear explanations!
Pablo de Lima (Jul 13, 2024) wonderful!!!!
Tim Whalen (Jul 9, 2024) It was very informative and functions explained thoroughly.
Jazlaan Ur Rehman (Jul 6, 2024) amazing course
Quique Torrón (Jul 3, 2024) Very interesting Course!!! Thank yo so much.
Alberto Torrens (Jul 2, 2024) Amazing Introduction course
Mahdi Ghafarianzadeh (Jul 2, 2024) This is by far the best entrance to the world of DAX. You get how the DAX works and see the whole picture.
Harshit Kumar Rai (Jun 30, 2024) This is what I call a perfect course. Thanks for removing my DAX fear.
ROTIMI RASAKI (Jun 25, 2024) Very Informative
Billy Joe Wilsher (Jun 23, 2024) Goods over view of Dax
Jack Hillyer (Jun 21, 2024) Very good intro
SeethaLakshmi Govindarajan (seethagovindarajan) (Jun 21, 2024) It was an informative course while understanding the fundamentals of DAX.
Herbert Cortez (Jun 21, 2024) Great course for beginners!
Sinisa Ivkovic (Jun 19, 2024) Thanks to my colleague, I just learn what I was supposed to learn long time ago.
Damian Glowala (Jun 3, 2024) Great Introducing into DAX formula language!
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
A team management dashboard is available if you choose to assign this course after the purchase or you get a transferable license.
Learn more