From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling
Unlock this course with a free trial
Join today to access over 24,600 courses taught by industry experts.
Wrapping up - Microsoft Excel Tutorial
From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling
Wrapping up
Congratulations! That officially wraps up the third and final course in our Excel Business Intelligence series. If you'd like to explore our entire stack of business intelligence courses, including Excel, Power BI, SQL, Tableau, and more, head to mavenanalytics.io to experience our award-winning guided learning platform. You can create your own personalized learning plan, work through real-world projects, earn badges and credentials, and track your progress every step of the way. So if you're ready to build practical, expert-level BI skills, sign up for Maven Analytics and start learning for free.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
Introduction to DAX functions27s
-
(Locked)
DAX formula syntax and operators4m 5s
-
(Locked)
Common DAX function categories3m 54s
-
(Locked)
Basic math and stats functions12m 45s
-
(Locked)
COUNT, COUNTA, DISTINCTCOUNT, and COUNTROWS10m 35s
-
(Locked)
Logical functions (IF, AND, and OR)16m 49s
-
(Locked)
Switch and Switch (TRUE)10m 33s
-
(Locked)
Text functions10m 53s
-
(Locked)
The CALCULATE function14m 39s
-
(Locked)
Add filter context with FILTER: Part 19m 20s
-
(Locked)
Add filter context with FILTER: Part 214m 23s
-
(Locked)
Remove filter context with ALL9m 6s
-
(Locked)
Join data with RELATED3m 39s
-
(Locked)
Iterator ("X") functions: SUMX12m 20s
-
(Locked)
Iterator ("X") functions: RANKX5m 33s
-
(Locked)
Basic date and time functions4m 58s
-
(Locked)
Time intelligence formulas17m 2s
-
(Locked)
Speed and performance considerations3m 3s
-
(Locked)
DAX best practices2m 3s
-
(Locked)
Final section53s
-
(Locked)
Data visualization options4m 24s
-
(Locked)
Wrapping up47s
-
-