Advanced DAX functions and concepts

Summary

In this course, you’ll learn how to master the advanced concepts and intricacies of DAX (Data Analysis Expressions). You’ll learn how to work with dates and how to create variables. You’ll understand how relationships work & you’ll learn all about DAX’s evaluation contexts. You’ll apply key concepts through case-study style learning, with concise lessons and applied assessments. C reated & customized for Chartered Accountants Ireland by kubicle.com

Venue details:  
Online, ,
Start date & time:  
03 December 2018 00:00
End date & time:  
01 January 2020 00:00
Price: €75.00  (€75.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
3.00
CPD hours:  
3.00
Speaker details
No speakers have been associated with this event.

Description

Product type:  
CPD online course
Category:  
Information technology

Who Should Attend?

This is an advanced course, and is suited to learners who already have a basic knowledge of DAX. You should know how to write formulas in DAX, and have some experience of using common DAX functions, in particular Calculate. This course will be of interest to any business professionals, such as accountants, management consultants and analysts who want to master DAX formulas.

Course Overview

This Kubicle course contains 13 lessons, 3 exercises and 1 Exam. It covers the following topics:

  • Date Functions
  • Data Tables
  • Time Intelligence
  • Working with Variables
  • Understanding Cross Filtering
  • Relational Functions
  • Filtering Functions
  • Understanding the Row Context
  • Multiple Row Contexts
  • Understanding Filter Contexts
  • Context Transition

Key Outcomes

Once you’ve completed this course, you’ll have a thorough understanding of the principles behind DAX formulas. You’ll also have an understanding of the data model used in Power BI, and you’ll be able to perform time intelligence analysis. The skills you’ll learn in this course will help you create more detailed DAX formulas, and help you reduce errors, giving you an excellent command of DAX.