Upgrade to Enterprise DNA Membership

DAX Accelerator

  • June 19 - 23
  • 2pm Los Angeles (PDT)
  • 5pm New York (EDT)
  • 10pm London (BST)
  • June 20 - 24
  • 7am Sydney (AEST)
  • 9am Auckland (NZST)

Create advanced analytical models by learning how to harness the power of DAX calculations for use within Power BI

Coming Soon

Here's What You'll Get Through

This Accelerator Program

Power BI Videos

Over 5 days, accelerate your Power BI skills within our unique learning experience.

Power BI Reports

Get personal guidance and experience during instructure lead sessions from global experts

Power BI Sets

Best practice frameworks for elevating your Power BI skillset and development techniques

Power BI Assessment

Build the exact skills you need around Power BI in the fastest way possible

Power BI Super Users Workshop
  • Time Commitment:
    - 5 days
    - 2 hour workshop each day
    - 1 hour project based learning each day
  • Benefits:
    - Condensed learning
    - Collaborative environment
    - Ask questions live
    - Network with other data professionals

A UNIQUE LEARNING EXPERIENCE FROM ENTERPRISE DNA

What specifics will you learn during this

DAX Accelerator Program

  • Use DAX and also what you can achieve with DAX if utilized well
  • Structure and format DAX formula
  • Use DAX variables in your formulas effectively
  • Use calculated columns and measures in your models
  • Write aggregation, iteration and table DAX functions
  • Implement DAX functions in combination with each other
  • Visualize how the DAX calculation engine works via the concept of 'context'
  • Audit your formulas by understand filter and row context
  • Use the CALCULATE
  • Add additional virtual filters to your calculations by using table functionsalysis
  • Use DAX to solve common analytical scenarios you will face everyday in the real world
  • Use time intelligence table along with a quality date table
  • Use advanced table functions in unique calculation requirements

Here's an outline of the

DAX Accelerator Curriculum


DAY 1

DAX Basics

  • Calculated columns vs measures
  • Understanding context & how the DAX calculation engine works
  • Evaluation or initial context
  • Aggregations or filter context
  • Iterations or row context
  • DAX function types
  • Aggregation Functions - SUM/AVERAGE/MIN/MAX
  • More Aggregators - COUNT/COUNTA/COUNTBLANK/COUNTROWS/DISTINCTCOUNT
  • Iteration Functions - SUMX/AVERAGEX/MINX/MAXX

Expanding on CONTEXT

  • What are table functions? (think of virtual tables!)
  • FILTER
  • The versatile VALUES function
  • VALUES vs DISTINCT
  • VALUES vs SELECTEDVALUE (& HASONEVALUE)
  • ALL function - the remove filters function
  • How filter and row context work with relationships
  • Working with one table versus many tables
  • ISFILTERED/ISCROSSFILTERED
  • RELATED function
  • EARLIER function

CALCULATE Statement

  • Why CALCULATE is important?
  • Why do you even have to use CALCULATE? (It's all about CONTEXT!)
  • What can you do when you use CALCULATE?
  • How are formula calculated when you involve CALCULATE?
  • CALCULATE example w/USERELATIONSHIP
  • What are time intelligence functions?
  • Why you must have a date table?
  • The best time comparison function - DATEADD
  • DATEADD vs SAMEPERIODLASTYEAR
  • Aggregations - YTD, QTD, MTD

Advanced Techniques For Variables

  • Understanding how variables are evaluated
  • Using table variables to simplify ultimate formulas
  • Using variables to clean up multiple measure
  • When to create virtual vs physical relationships?
  • TREATAS
  • How does USERELATIONSHIP compare?
  • How to manipulate virtual tables using table functions
  • ADDCOLUMNS
  • SUMMARIZE
  • You can also combine table functions together
  • ROW

Ranking Functions

  • RANKX
  • TOPN
  • Practical examples for using ranking functions
  • This is where the measure branching methodology really shines
  • Compare multiple quarterly sales on each other

What you get from participating in
an accelerator program

  • Access to 5 days worth of training with two hour live sessions each day
  • Ability to collaborate with other data analysts during the week during workshops and through projects
  • Access will be given to all replays and instructor-led Q&A‘s will be available throughout the program
  • A certification to showcase your participation and learning experience
  • Tons of resources and direction to maintain your skills through time
  • Live support throughout the week to improve your skills and development abilities
Power BI Super Users Workshop

This Accelerator Program is Tailored for:

Data Analysts

Reporting Managers

Excel Users

Your Instructor For This Accelerator Program

Sam McKay

Sam is Enterprise DNA's CEO & Founder. He help individuals and organisations develop data driven cultures and create enterprise value by delivering business intelligence training and education on Microsoft’s Power BI platform

He partner with business decision makers and analysts across all industries and business functions.

  • Industries include: Financial Services, Consumer Goods, Energy, Retail, Insurance and others
  • Functions include: Finance, Accounting, Sales, HR, Marketing and more
  • People include: Directors, Executives, Team leaders, Analysts

There is no faster way to build your practical skills and make a difference within your teams than by attending one of our accelerator programs

Use our accelerator programs to further advance your career in data and analytics.

What our Students Say

Get full access to unparalleled training

& skill-building resources

For Individuals

Enterprise DNA

Membership

Empowering the most valuable Power BI users to expand their analytical thinking and insight generation possibilities

For Teams

Enterprise DNA

Center of Excellence

Training, tools, and guidance to unify and upskill the Power BI analysts in your workplace