Introduction to DAX

£195.00

What Will You Learn?

  • To have the ability to add analytical value to data models by creating calculated columns and measures
  • To develop a strong understanding of how to work with time intelligence functions in DAX
  • To build the foundations necessary for authoring more complex DAX calculations

Category:

DESCRIPTION

DAX is both a programming and query language that gives you the ability to extend what is possible in either your Power BI or Tabular data models. The Introduction to DAX course is designed to teach the fundamentals of DAX, while emphasizing the basic building blocks required to author more complex DAX calculations. This video-based course quickly moves from basic DAX functions to more advanced functions like CALCULATE and iterator functions like SUMX.

INSTRUCTOR

MITCHELL PEARSON

BI Consultant and Trainer
As a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS and SSRS). In addition to the BI Stack, he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.

 

WHAT TO KNOW BEFORE THE CLASS

A basic understanding of Excel functions is helpful, but not necessary for this course.


Duration: 4:36:42
DAX is both a programming and query language that gives you the ability to extend what is possible in either your Power BI or Tabular data models. The Introduction to DAX course is designed to teach the fundamentals of DAX, while emphasizing the basic building blocks required to author more complex DAX calculations. This video-based course quickly moves from basic DAX functions to more advanced functions like CALCULATE and iterator functions like SUMX
 
Introduction to DAX - What you need to get started
Module 00 - Getting Started (Introduction to DAX)
08:01
Module 01A - Data Modeling Basics (Overview)
16:16
Module 01B - Data Modeling Basics (Tabular)
06:57
Module 02A - What is DAX (Overview)
18:20
Module 02B - What is DAX (Tabular)
05:38
Module 03A - Creating Calculated Columns (Basics)
22:22
Module 03B - Creating Calculated Columns (Basics Continued)
15:53
Module 04 - Navigation Functions
18:11
Module 05 - Conditional and Logical Functions
24:08
Module 06 - Creating Calculated Measures
31:20
Module 07A - Time Intelligence (Overview)
12:50
Module 07B - Time Intelligence (Time Intelligence Functions)
32:25
Module 08 - Using X-Functions and A-Functions
19:26
Module 09 - Table Functions
22:45
Module 10 - DAX as a Query Language
22:10
Class Survey

SYSTEM REQUIREMENTS

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7 or Windows 8
  • 1 GHz or faster CPU
  • 1 GB of available RAM (recommended 2 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014 (Many features discussed are enterprise/developer edition only)
  • AdventureWorksDW2008R2 or AdventureWorksDW2012 databases installed on the instance