Introduction to DAX for Power BI Desktop Users - Level 3 Virtual Classroom Live November 25, 2024

Price: $1,300

This course runs for a duration of 2 Days.

The class will run daily from 7:00 AM PST to 3:00 PM PST.

Class Location: Virtual LIVE Instructor Led - Virtual Live Classroom.

Enroll today to reserve your spot!

Space is limited. Enroll today.

Enroll Now

Description

This course takes an in-depth approach to the DAX language, teaching designers how to build models that extend the capabilities of source data for more in-depth, customized business intelligence solutions. Topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with complex time intelligence calculations.

Course Overview

Lesson 1 : Basic DAX Functionality

Review of Calculated Columns
Review of Measures
Rules of Evaluation
Evaluation Context
Formatting DAX Code

Lesson 2 : Controlling Content & Values

Controlling Values - DAX
Error Handling

Lesson 3 : Content Control Functions

Iterative Functions
The FILTER Function
The ALL Function
The CALCULATE Function

Lesson 4 : Contexts In Relationships

Working With Many Tables
Row Context & Relationships
Elevated Calculated Columns
Filter Context & Relationships
Cross Filtering Issues

Lesson 5 : Time Intelligence Functions

Calculating Operating Periods
To-Date Functions
Controlling Totals
Advanced Date Functions
Prior Year Functions

Prerequisites

Data Model Design using Power BI Desktop – Level 2

Course Comments

This is Part 3 of a 3 Part Exclusive Power BI Cloud Learning Series

Part 1 Report Builder
Part 2 Data Model Designer

For small to large group training

Phone: 651-905-3729

Knowledge Transfer Consulting Services Inc. is a single-source solution provider offering a full range of Training Delivery and Training Management solutions from concept to delivery. Learn more