Introduction to DAX for Power BI Desktop Users - Level 3

Price
$1,190.00

Duration
2 Days

 

Delivery Methods
Virtual Instructor Led
Private Group

Request More Information
Download Course Details
Course Details Only
Course Details & Schedule
Skip to Class Dates

Course Overview

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.

United Training is committed to working as a partner with our clients. Choose United Training and take advantage of the following benefits.

  • Robust Public Enrollment Schedule. Enjoy access to hundreds of Guaranteed to Run dates across a diverse catalog of course titles.
  • Private Group Training. Let our world-class instructors come to you to deliver training at your place of business or we can present to your team online using our Virtual Instructor-Led Training platform.
  • Custom Training Solutions. Our subject matter experts can customize the class to specifically address the unique goals of your team.
  • Free Re-Takes. Most completed United Training courses carry our unbeatable Learning Guarantee. This guarantee allows students to repeat most United Training courses, if they are the same version, FREE OF CHARGE, within six months of completion of the courses. Exceptions: Cisco, Citrix, VMware, Red Hat, and courses provided by affiliated 3rd party training providers.

Course Prerequisites

Data Model Design using Power BI Desktop – Level 2

Agenda

1 - Basic DAX Functionality

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

2 - Controlling Content & Values

  • Controlling Values – DAX
  • Error Handling

3 - Content Control Functions

  • Iterative Functions
  • The FILTER Function
  • The ALL Function
  • The CALCULATE Function

4 - Contexts In Relationships

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

5 - Time Intelligence Functions

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

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
 

Upcoming Class Dates and Times

May 25, 26
7:00 AM - 3:00 PM
ENROLL $1,190.00
Guaranteed to Run
Virtual: Online - PST
Jul 27, 28
7:00 AM - 3:00 PM
ENROLL $1,190.00

Virtual: Online - PST
 

Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
Contact Us about Starting Your Business Training Strategy with United Training