Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Improve your skills while working at home
Online Training options available for all of our courses
Live-Instructor - Online Group Training - On-Demand


Excel BI Tools: DAX Formulas for Dynamic Tables Training Course

Excel BI Tools: DAX Formulas for Dynamic Tables Training Course


Course Description:  The Excel BI Tools: DAX Formulas for Dynamic Tables course will train students on how to DAX language to create reusable formulas that can work across multiple data sources to produce powerful reports. DAX related reporting requirements are covered in the course, and students will also learn how to build models that extend the capabilities of Power BI, Excel, and SQL Server Analysis Services.

Please note: This class is taugh using Excel Software, but user of Power BI and SQL Server Analysis Services will easily be able to follow along.

The course will cover the following topics:

  • DAX Functionality Review
  • Controlling Content & Values
  • Context Control Functions
  • Contexts In Relationships
  • Advanced Concepts
  • Time Intelligence Calculations
  • DAX Dashboard Techniques

Training Dates
(Click on the course name below to view course details and full list of class dates)

Excel BI Tools: DAX Formulas for Dynamic Tables
Locations: Available Nationwide and Online
Class Date(s): 4/27/20 - 4/28/20
Course Fee : $995


Excel BI Tools: DAX Formulas for Dynamic Tables
Locations: Available Nationwide and Online
Class Date(s): 5/27/20 - 5/28/20
Course Fee : $995


Excel BI Tools: DAX Formulas for Dynamic Tables
Locations: Available Nationwide and Online
Class Date(s): 6/22/20 - 6/23/20
Course Fee : $995


Excel BI Tools: DAX Formulas for Dynamic Tables
Locations: Available Nationwide and Online
Class Date(s): 7/20/20 - 7/21/20
Course Fee : $995


Excel BI Tools: DAX Formulas for Dynamic Tables
Locations: Available Nationwide and Online
Class Date(s): 8/24/20 - 8/25/20
Course Fee : $995


Course Syllabus

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

Excel Analytics On-Site Group Training
Arrange a private Excel Analytics training class for your team with one of our Certified Instructors. Private instruction for your team members at a lower per-student price than attending the public courses. Learn More or complete the quote request form below.



Data Analysis On-Demand Training

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)


Business Computer Skills Microsoft Partner

Business Computer Skills BBB Profile