Introduction to DAX for Power BI Desktop Users - Level 3 Classroom Live Seattle, WA October 05, 2020

Price: $1,190

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: Seattle - Seattle, WA.

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 Review
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

Lesson 6 : Appendix - Advanced Concepts

Additional Uses Of The ALL Function
Advanced Data Tables
Working with Missing Periods
Working with Non-standard Years
Parameter Tables
Banding

Prerequisites

Power BI for the Cloud
Part 1
Part 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

Other Available Dates for this Course

Virtual Classroom Live
October 05, 2020

$1,190.00
2 Days    7:00 am PST - 3:00 pm PST
view class details and enroll
Virtual Classroom Live
November 02, 2020

$1,190.00
2 Days    7:00 am PST - 3:00 pm PST
view class details and enroll
Classroom Live
November 02, 2020

Seattle, WA
$1,190.00
2 Days    7:00 am PST - 3:00 pm PST
view class details and enroll
Classroom Live
December 07, 2020

Seattle, WA
$1,190.00
2 Days    7:00 am PST - 3:00 pm PST
view class details and enroll
Virtual Classroom Live
December 07, 2020

$1,190.00
2 Days    7:00 am PST - 3:00 pm PST
view class details and enroll