Welcome to ONLC Training Centers


Advanced DAX Functions Course Outline

 (2 days)

Special Note to New Hampshire Residents
This course has not yet been approved by the State's Department of Education. Please contact us to get an update as to when the class should be available in New Hampshire.

Overview
This course is for individuals responsible for taking data and turning it into powerful business intelligence solutions. The value of DAX goes far beyond just “saving you time;” it can transform your business. With DAX you can create reusable formulas the allow you to rapidly iterate and answer questions across multiple data tables and across different sources, offering huge business intelligence value.

This course takes an in-depth approach to the DAX language, teaching how to build models that extend the capabilities Power BI, Excel, or SQL Server Analysis Services. Specific topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with time intelligence calculations.

Audience
This class is for users of either Power BI, Excel Power Tools, or SQL Server Analysis Services (SSAS). While all three products have a very similar DAX-related interface, the course will be taught using the Excel 2016 software. Users of Power BI and SQL Server should have no problems with the slight differences between products.

This course is aimed at Excel power-users, Power BI BI professionals, and Excel power-users who have a general familiarity with DAX but need more knowledge and experience to take it to its full potential. Our Advanced Power Query and M course is a great complement to this class and is also designed for users of Excel, Power BI or SQL Server. For details on this companion course, go to
Advanced Power Query and M

Prerequisites
While attendees do not need extensive prior experience with DAX formulas, it is recommended that they have taken either our "Analyzing Data with Power BI" or "Excel BI Tools" class or have similar experience.

Course Outline

DAX Functionality Review
Review Of Calculated Column
PivotTable Function
Review Of Measure
Rules Of DAX Measure
Evaluation Context
Formatting DAX Code

Controlling Content & Values
Controlling Values
Switch Function
Error Handling

Context Control Functions
Filter Function
All Function
Iterative Functions
Earlier Function
Calculate Function
Additional Uses Of The All Function

Contexts In Relationships
Working With Many Tables
Row Context & Relationships
Filter Context & Relationships
Values Function

Advanced Concepts
Circular Dependencies
Controlling Totals
Advanced Hierarchy Concepts

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

Appendix : DAX Dashboard Techniques
Parameter Tables
Banding
Ranking
Advanced Slicer Techniques
View outline in Word

BDXM01

Attend hands-on, instructor-led Advanced DAX Functions training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.

Microsoft Gold Partner
Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $1095

Savings options:

 15 Day Pass
 CEA Tech Saver
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Attend from your office or home

If you have high-speed internet and two computers you can likely take this class from your office or home.

Need a class for a group?

We can deliver this class for a private group at your location. Follow the link to request more information.

Attend computer classes from ONLC Training Centers Request a copy via mail

GENERAL INFO

Class Format
Class Policies
Student Reviews

Bookmark and Share


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com