Course Length: 2 days

Course Description


The Data Analysis Expressions (DAX) language allows users to filter and query tables.  This course will discuss the basics of DAX data types, variables, and formatting.  It will demonstrate data modeling concepts from getting and extending data to optimizing and simplifying data models.  This course will explore working with DAX in Power BI, Excel PowerPivot, and SQL Server.  The course will also discuss how to break down the DAX syntax and use a variety of functions.  Finally, this course will show how to optimize DAX queries.


To ensure success in this course, you should have a basic understanding of Power BI and Excel functions.

Excel Level 2

Excel Formulas

Excel Level 3

MS DA-100 Analyzing Data with Power BI (aka) MS PL 300 Microsoft Power BI Data Analyst

Target Student:

This course is primarily designed for students who want to gain the skills necessary to use DAX in the BI and data analytics domain.

Course Objectives:

In this course, you will learn how to use DAX queries in Power BI, PowerPivot, and SQL Server.  You will

  • Understand how DAX queries work.
  • Use DAX variables and formatting
  • Build data models
  • Work with DAX in Power BI, PowerPivot, and SQL Server
  • Understand DAX functions and syntax:
    • Table functions
    • Date, Time, and Time Intelligence functions
    • Filter functions
    • Statistical functions
  • Work with DAX patterns
  • Optimize data models and DAX queries