D.O.T.S. Power BI DAX Introduction
£485.00 – £13,500.00
This is the Dual Online Training Solution (D.O.T.S.) version of our Introduction to Power BI Data Analysis Expressions (DAX). In this course, delegates will learn the fundamentals of the DAX language. The main topics covered are Calculated Columns; DAX Syntax; Calculated Tables; Measures; Iterator Functions; Understanding Calculation Contexts; and CALCULATE Function Basics.
Description
This is the Dual Online Training Solution (D.O.T.S.) version of our Introduction to Power BI Data Analysis Expressions (DAX). In this course, delegates will learn the fundamentals of the DAX language. The main topics covered are Calculated Columns; DAX Syntax; Calculated Tables; Measures; Iterator Functions; Understanding Calculation Contexts; and CALCULATE Function Basics.
Our Dual Online Training Solution provides your staff with two modes of training: live instructor-led training is followed with three year’s access to the self-paced version of the same course. The material covered in the live training will be very similar to that covered in the self-paced video training. So, the self-paced training provides a very effective form of post-training reinforcement.
Course Outline
Getting Started
Welcome to the Course
Downloading the Course Files
DAX Overview
DAX Objects
Calculated Columns
Calculated Columns versus M Computed Columns
Creating Calculated Columns
Calculated Columns versus Measures
Calculated Columns, Measures and Visuals
DAX Syntax
Referring to Objects
DAX Operators
Using Variables
Calculated Tables
Creating Calculated Tables
Creating a Date Table
Cloning a Table
Using the DISTINCT Function
Using the FILTER Function
Measures
Creating a Measures Table
Implicit Measures
Measures and the Filter Context
Basic Aggregation Functions
Logical Functions
Iterator Functions
Implicit and Explicit Iteration
The SUMX Function
The AVERAGEX Function
The COUNTX Function
Calculation Contexts
Understanding Calculation Contexts
The Row Context
The Filter Context
Context Transition
CALCULATE Function Basics
CALCULATE Overview
Using CALCULATE with Booleans
Using CALCULATE with FILTER
Using CALCULATE with ALL
Additional information
Date | 2 Feb 2022(Tutor-led, Online), ; 11 Apr 2022(Tutor-led, Online), ; 8 Jun 2022(Tutor-led, Online), ; 10 Aug 2022(Tutor-led, Online), ; 26 Oct 2022(Tutor-led, Online), Private Training for up to 10 Users, Private Training for up to 20 Users, Private Training for up to 30 Users, Private Training for up to 40 Users, Private Training for up to 50 Users, Private Training for up to 60 Users, Private Training for up to 70 Users, Private Training for up to 80 Users, Private Training for up to 90 Users, Private Training for up to 100 Users |
---|