Preferred method of contact:

Introduction to DAX for Excel Users - Level 4

COURSE TYPE

Advanced

Course Number

2905

Duration

2 Days

PDF Add to WishList

This is the fourth course in the Power BI for Excel 2016 training series. This course is built for Power BI for Excel Designers that will be responsible for taking basic PowerPivot data models turning them into powerful business intelligence solutions. 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. Specific 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, creating advanced DAX dashboards and report elements using Slicers.

Course Outline

  • Lesson 1: Basic DAX Functionality
  • Review Of Calculated Columns
  • PivotTable Functions
  • Review Of Measures
  • Rules Of DAX Measures
  • Evaluation Context
  • Formatting DAX Code
  • Lesson 2: Controlling Content & Values
  • Controlling Values
  • Switch Function
  • Error Handling
  • Lesson 3: Context Control Functions
  • Iterative Functions
  • Filter Function
  • All Function
  • Earlier Function
  • Calculate Function
  • Lesson 4: Contexts In Relationships
  • Working With Many Tables
  • Row Context & Relationships
  • Filter Context & Relationships
  • Values Function
  • Lesson 5: Time Intelligence Calculations
  • Working With Date Tables
  • Calculating Operating Periods
  • Working With Missing Periods
  • DAX Date Functions
  • Advanced Date Functions
  • Prior Year Functions
  • Moving Averages
  • Lesson 6: Appendix: Advanced Concepts
  • Circular Dependencies
  • Controlling Totals
  • Advanced Hierarchy Concept
  • Additional uses of the ALL function
  • Lesson 7: Appendix: DAX Dashboard Techniques
  • Parameter Tables
  • Banding
  • Ranking
  • Advanced Slicer Techniques
Show complete outline
Show Less

Convenient Ways to Attend This Instructor-Led Course

Hassle-Free Enrolment: No advance payment required to reserve your seat.
Tuition due 30 days after you attend your course.

In the Classroom

Live, Online

Private Team Training

In the Classroom — OR — Live, Online

Tuition — Standard: $1550  

Apr 11 - 12 ( 2 Days)
7:00 AM - 3:00 PM PDT
Seattle, WA / Online (Adobe Connect) Seattle, WA / Online (Adobe Connect) Reserve Your Seat

Jun 6 - 7 ( 2 Days)
7:00 AM - 3:00 PM PDT
Bellevue, WA / Online (Adobe Connect) Bellevue, WA / Online (Adobe Connect) Reserve Your Seat

Guaranteed to Run

When you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time, location — will run. Guaranteed.

Private Team Training

Enrolling at least 3 people in this course? Consider bringing this (or any course that can be custom designed) to your preferred location as a private team training.

For details, call 1-888-843-8733 or Click here »

This event has been added to your cart.

Tuition

Standard

In Classroom or
Online

Standard

$1550

Private Team Training

Contact Us »

Training Hours

Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm

- ,

Prev
Next
Chat Now

Please Choose a Language

Canada - English

Canada - Français