VTeach Training Partner
Your Training Partner
Follow Us:
Contact VTeach Training
Register for Training

Data Analysis Expressions (DAX)

Course Duration

1 Day

Course Time

9am to 5pm

Course Fee

$285.00

(Group Discount of 10% for 3 or more participants)

Course Dates

Call for Dates

Course Objective:

This course is intended to expose the students to the technology of DAX and to familiarize them with functionality of DAX at an advanced level to produce sophisticated DAX calculations by use of the functions of DAX. This course is based on Excel Professional 2013 or higher.

Target Audience

This course is intended for Power Users, Business Intelligence Developers, and IT Professionals that will be involved with the development of Excel PowerPivot queries and tabular modeling.

Training Methodologies

  • Training is hands-on using easy-to-follow step-by-step instructions.
  • Instructor-Led Training (ILT) on live exercises of each topic.

Trainer

Training will be conducted by our experienced local trainer who has more than 10 years of experience with relevant certification.

Course Content

Lesson 1: Introduction to DAX 

  • DAX Syntax
  • DAX Data Types and Operator Overloading
  • DAX Operators
  • DAX Values

Lesson 2: Using DAX Functions 

  • Mathematical Functions
  • Statistical Functions
  • Logical Functions
  • Information Functions
  • Text Functions
  • Conversion Functions
  • Aggregation Functions
  • elational Functions

Lesson 3: Understanding Evaluation Contexts 

  • The CALCULATE Function
  • Filter Functions
  • Single Table Evaluation Context 
  • Multiple Table Evaluation Context

Lesson 4: Working with Dates

  • Date Functions
  • Working with Calendars
  • Using Multiple Calendars

Newsletter Subscription

Connect with VTeach by subscribing to our mailing list