Data Analysis Expressions (DAX)

Course Dates:

Call for Dates

Course Specifications

Course length: 1 Day

Course Fees: S$285.00 (Group Discount of 10% for 3 or more participants)

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.

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

 


Our Testimonials

During the Advanced Excel class, the trainer helped me to clarify my doubts especially the VLookup.
- Clarinda

A very engaging course that I really enjoyed. The tutor was very cheerful and helpful.
- Manisha

Good experience and thanks to the Trainer for her kind patient in teaching our company.
- Belle

Why choose us?

Hands-on Training Method
ACTA and Microsoft Certified Trainers
Small class size
Complete Course Material
Free One-Time Refresher
Affordable Price
Certification of Completion
Central Location

Our Training Location

10 Anson Road
#31-12 International Plaza
Singapore 079903
(Tanjong Pagar MRT Station)

Call: +65 6673 4479

Email: admin@vteach.com.sg

Privacy Policy