NEED HELP? TALK TO AN EXPERT (904) 638-5743

Introduction to DAX

Part Of The On-Demand Courses

WHAT YOU'LL 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
This course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

Course 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.

 

Click here for a downloadable PDF

Outline

 

Module 00 | Introduction to DAX
09m 02s total

 

Module 00A | Getting Started
09m 02s

 

Module 01 | Data Modeling Basics
34m 86s total

 

Module 01A | Overview
27m 28s

 

Module 01B | Tabular
07m 58s

 

Module 02 | What is DAX
29m 48s total

 

Module 02A | Overview
23m 30s

 

Module 02B | Tabular
06m 18s

 

Module 03 | Creating Calculated Columns
50m 55s total

 

Module 03A | Basics
27m 55s

 

Module 03B | Basics (Continued)
23m 00s

 

Module 04 | Navigation Functions
20m 08s total

 

Module 04A | Navigation Functions
20m 08s

 

Module 05 | Conditional and Logical Functions
29m 56s total

 

Module 05A | Conditional and Logical Functions
29m 56s

 

Module 06 | Creating Calculated Measures
40m 20s total

 

Module 06A | Creating Calculated Measures
40m 20s

 

Module 07 | Time Intelligence
36m 46s total

 

Module 07A | Overview
09m 12s

 

Module 07B | Time Intelligence Functions
27m 34s

 

Module 08 | Using X-Functions and A-Functions
17m 41s total

 

Module 08A | Using X-Functions and A-Functions
17m 41s

 

Module 09 | Table Functions
27m 20s total

 

Module 09A | Table Functions
27m 20s

 

Module 10 | DAX as a Query Language
21m 59s total

 

Module 10A | DAX as a Query Language
21m 59s

Instructor

MITCHELL PEARSON

Training Content Manager

Mitchell Pearson has been with Pragmatic Works for 8 years as a Data Platform Consultant and the Training Content manager. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure.

 

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

What to Know Before Class

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

REVIEWS

Great course material, presentation, and format. Very useful information that can be applied at work immediately.

David H.

Huge fan of this class and the T-SQL class. Both instructors are very clear and concise with their examples and start from the very beginning... which is much appreciated!

Anonymous

I enjoy these classes at my own speed.

Anonymous

Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required