All courses available in-class or via remote login

power bi courses nexacu

Microsoft Power BI DAX Training Course

Learn the fundamentals of DAX on our One-Day Course - login from home

All courses available in-class or remotely.
To attend remotely, select "Remote Online" as your location on book now.


Power BI is a powerful tool. Users can achieve quite a lot without much DAX knowledge but to take your skills and modelling ability to the next level, fundamental understanding of the DAX language is key. Our one-day course will introduce key concepts and work through exercises so students leave with a clearer picture of how to write DAX. You will learn:

  • To write DAX functions and understand expressions
  • use tools to help manage and create DAX
  • create complex expressions 
  • learn methods to optimise expressions and more

Remote Online

Brisbane

Sydney

Parramatta

Melbourne

Canberra

Adelaide

Perth

Upcoming Courses:
Remote Online
Date
Course
City
Status
Fri 14-Aug-20
Power BI DAX
Remote Online
Scheduled
Mon 31-Aug-20
Power BI DAX
Remote Online
Confirmed
Tue 15-Sep-20
Power BI DAX
Remote Online
Scheduled
Fri 18-Sep-20
Power BI DAX
Remote Online
Confirmed
Mon 5-Oct-20
Power BI DAX
Remote Online
Scheduled
Thu 29-Oct-20
Power BI DAX
Remote Online
Scheduled
Fri 20-Nov-20
Power BI DAX
Remote Online
Scheduled
Mon 14-Dec-20
Power BI DAX
Remote Online
Scheduled
Thu 14-Jan-21
Power BI DAX
Remote Online
Scheduled
Fri 15-Jan-21
Power BI DAX
Remote Online
Scheduled
Brisbane
Date
Course
City
Status
Mon 31-Aug-20
Power BI DAX
Brisbane
Sold Out
Tue 15-Sep-20
Power BI DAX
Brisbane
Scheduled
Thu 29-Oct-20
Power BI DAX
Brisbane
Scheduled
Fri 20-Nov-20
Power BI DAX
Brisbane
Scheduled
Mon 14-Dec-20
Power BI DAX
Brisbane
Scheduled
Fri 15-Jan-21
Power BI DAX
Brisbane
Scheduled
Tue 16-Feb-21
Power BI DAX
Brisbane
Scheduled
Mon 8-Mar-21
Power BI DAX
Brisbane
Scheduled
Thu 1-Apr-21
Power BI DAX
Brisbane
Scheduled
Fri 23-Apr-21
Power BI DAX
Brisbane
Scheduled
Sydney
Date
Course
City
Status
Fri 18-Sep-20
Power BI DAX
Sydney
Confirmed
Tue 27-Oct-20
Power BI DAX
Sydney
Scheduled
Fri 20-Nov-20
Power BI DAX
Sydney
Scheduled
Thu 14-Jan-21
Power BI DAX
Sydney
Scheduled
Fri 26-Feb-21
Power BI DAX
Sydney
Scheduled
Parramatta
We are busy updating this schedule.

Book a course in any city and remote login details will be provided.
Melbourne
Date
Course
City
Status
Fri 14-Aug-20
Power BI DAX
Melbourne
Scheduled
Tue 15-Sep-20
Power BI DAX
Melbourne
Scheduled
Mon 5-Oct-20
Power BI DAX
Melbourne
Scheduled
Thu 29-Oct-20
Power BI DAX
Melbourne
Scheduled
Fri 20-Nov-20
Power BI DAX
Melbourne
Scheduled
Mon 14-Dec-20
Power BI DAX
Melbourne
Scheduled
Fri 15-Jan-21
Power BI DAX
Melbourne
Scheduled
Tue 16-Feb-21
Power BI DAX
Melbourne
Scheduled
Thu 1-Apr-21
Power BI DAX
Melbourne
Scheduled
Fri 23-Apr-21
Power BI DAX
Melbourne
Scheduled
Canberra
We are busy updating this schedule.

Book a course in any city and remote login details will be provided.
Adelaide
We are busy updating this schedule.

Book a course in any city and remote login details will be provided.
Perth
Date
Course
City
Status
Fri 2-Oct-20
Power BI DAX
Perth
Scheduled
Tue 10-Nov-20
Power BI DAX
Perth
Scheduled
Thu 3-Dec-20
Power BI DAX
Perth
Scheduled
Thu 21-Jan-21
Power BI DAX
Perth
Scheduled
Fri 5-Mar-21
Power BI DAX
Perth
Scheduled
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Power BI DAX Course Details

Price
$595
Duration
1 day
Times
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training Live Online
microsoft_gold

Power BI DAX Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
L10, 333 Adelaide Street, Brisbane QLD 4000

*Limited in-class seats due to COVID-19.
microsoft_gold

Power BI DAX Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 3, 37 Pitt Street, Sydney NSW 2000

*Limited in-class seats due to COVID-19.
microsoft_gold

Power BI DAX Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 3, 90 Phillip Street, Parramatta NSW 2150

*Limited in-class seats due to COVID-19.
microsoft_gold

Power BI DAX Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
*REMOTE* Level 3, 466 Little Lonsdale St, Melbourne VIC 3000

*Limited in-class seats due to COVID-19.
microsoft_gold

Power BI DAX Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Ethos House, Level 1, 28 Ainslie Place, Canberra ACT 2601

*Limited in-class seats due to COVID-19.
microsoft_gold

Power BI DAX Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 3, 97 Pirie Street, Adelaide SA 5000

*Limited in-class seats due to COVID-19.
microsoft_gold

Power BI DAX Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 4, 220 St Georges Tce, Perth WA 6000

*Limited in-class seats due to COVID-19.
microsoft_gold

Power BI Course Outlines

Other Courses
  • Microsoft Office 365 Training Courses
  • Microsoft Excel Training Courses
  • Microsoft Excel Specialist Training Courses
  • Microsoft SharePoint Training Courses
  • Microsoft Power Apps Training Courses
  • Microsoft Project Training Courses
  • Microsoft Visio Training Courses
  • Data Analytics Training Courses
  • Python Training Courses
  • Microsoft PowerPoint Training Courses
  • Microsoft Word Training Courses
Course Rating
Microsoft Power BI Training Courses

4.70 5 Microsoft Power BI Training Courses
4.70 out of 5
5887 Student Reviews

Contact Us



What do I need to know to attend?

  • Use Power BI Desktop proficiently to source / model data and create basic tables, columns and measures with DAX
  • Understanding the basic concepts of data modelling and how to perform related tasks in Power BI
  • Have good general knowledge of simple DAX and understand the evaluation contexts (row, filter, context transition etc.)
  • Advanced Excel skills is desired, knowledge of programming / scripting concepts will be an advantage
  • Students should have attended our Power BI Advanced course.

Power BI DAX Learning Outcomes

  • Write expressions more confidently using DAX
  • Work with a wider range of DAX functions
  • Make use of tools to compliment creating and managing DAX

 

  • Create more complex expressions using methods to build and prove an outcome
  • Appreciate the concepts of data model and expression performance
  • Use techniques to optimise an expression for better efficiency

Power BI DAX Course Content

  • Course Introduction
  • What is DAX
  • DAX Functions
  • DAX Contexts
  • What is Vertipaq
  • DAX efficiency
  • DAX references
  • DAX best practices

 

  • Recap of Contexts
  • Introduction to Contexts
  • Recap of DAX Contexts
  • The Row Context
  • The Filter Context
  • Measures and Calculated Columns
  • Dataset for exercises – Computer Store sales
  • Filter and Row Context in a measure
  • The CALCULATE function
  • Context Transition
  • Filter Expressions of CALCULATE
  • Rules of Evaluation
  • CALCULATE and FILTER

 

  • Contexts in Calculated Columns
  • Introduction to Columns
  • Row Context in Calculated Columns
  • Filter Context in Calculated Columns
  • Relationships in Row Contexts
  • The RELATED function
  • The RELATEDTABLE function
  • Using RELATEDTABLE in a column
  • CALCULATED in row contexts
  • Row to Filter Context
  • Transformation Whiteboard
  • Exercise on row to filter contexts
  • Duplicates in the transformation
  • The LOOKUPVALUE function

 

  • Row Contexts in Measures
  • Introduction to Row Contexts
  • Row Contexts in Measures
  • Simple iterator in a measure
  • Row Context and a related table
  • Some more calculations exercise
  • Re-using measures
  • Implicit CALCULATE in a measure
  • An alternative approach using variables

 

  • Functions and FILTER
  • Introduction to DAX functions
  • Time Intelligence functions
  • Date (Dimension) tables
  • Using in-built TOTALYTD
  • Date modifier functions
  • Using date modifier DATESBETWEEN
  • Using date modifier DATESYTD
  • The magic behind Date Table functions
  • The case for simplicity – MAX or LASTDATE
  • Understanding the FILTER function
  • Contexts in the FILTER function
  • The filter context in functions
  • Naked column references
  • Simple filter expression
  • Comparing a value in the filter context
  • Adding another filter condition
  • The value of VALUES

 

  • Table Functions
  • Introduction to Table functions
  • Summarising tables
  • Using SUMMARIZE alone
  • The problem with SUMMARIZE
  • Using ADDCOLUMNS and SUMMARIZE
  • Using SUMMARIZECOLUMNS as a better alternative
  • A summary table in a measure

 

  • Practical DAX
  • Introduction to DAX calculations
  • Comparing functions – min/max and time intelligence
  • Debugging with DAX
  • Alternative patterns
  • The Quick Measure version
  • The KEEPFILTERS function
  • The TREATAS function
  • A few ORs or TREATAS
  • Using TREATAS and KEEPFILTERS
  • Using TREATAS for virtual relationships

 

  • DAX Tools
  • Use of third party tools
  • Introducing DAX Studio
  • What is DAX Studio
  • Download and Install DAX Studio
  • The DAX Studio Interface
  • How DAX Studio connects to the data
  • Viewing data model information
  • Creating a table query
  • Ordering a query result
  • A query returning a scalar
  • Defining a Measure
  • Declaring a variable
  • Incoming filter context

 

 

  • DAX Performance
  • Introduction to DAX Performance
  • The basics of the Vertipaq engine
  • Where is Vertipaq
  • A database of columns
  • Compression of a column
  • Identifying column compression
  • Understanding the TABLE_ID column
  • Power Query data statistics
  • Data Model Normalisation
  • Introduction to the Query Plan
  • Overview of the engines
  • The Formula Engine
  • The Storage Engine
  • Capturing a query
  • Special process to capture Power BI queries
  • Re-loading Power BI visuals
  • Understanding the query information from the capture

 

  • DAX Optimisation
  • Introduction to optimising DAX
  • Clear the Cache
  • Server Timings
  • Explaining the Server Timings
  • Steps to improve performance
  • Redefine a measure
  • The datacache
  • Optimisation by the Vertipaq engine
  • The CallBackDataID function
  • Reducing CallBackDataID instances
  • Optimising a Query in the Storage Engine
  • Viewing the Query Plan
  • Comparing two statistical functions

 

  • Extended Topics:
  • Table Joins
  • Introduction to Table Joins
  • The Inner Join
  • A join on unrelated tables – TREATAS
  • The Outer Join
  • The Cross Join Using
  • GENERATE for Joins

 

  • Nested Row Context
  • Introduction to Nested Rows
  • How Nested Rows work
  • The EARLIER function
  • The EARLIEST function
  • Create a nested row in a column
  • How to avoid complex nesting expressions
  • Using variables to store values before nesting
  • Avoid iterators where possible
  • Further improve the efficiency of an expression

 

  • Ranking
  • Introduction to Ranking
  • Arguments in RANKX
  • Create a calculated column for ranking
  • Sort order of ranking
  • Definitions when ranking ties
  • Breaking Ties Manually
  • Creating a measure for ranking
  • Adjustments to make the RANKX measure work

What is Remote Training?

Valued by Individuals

4.8/5
Over 22036 Reviews
It has been a great experience. The reliance of subjects was related to my requirements. There was a great opportunity provided tailor an example to finish the course. -Excel Macros/VBA 2 Day Brisbane
Nicholas - Excel Macros/VBA 2 Day, .
Great Course, learnt alot and was easy to follow -Analysis & Dashboards Melbourne
Julia - Analysis & Dashboards, .
Excellent Training session -Analysis & Dashboards Melbourne
Rashmikant - Analysis & Dashboards, .
This course enhanced my knowledge in Excel -Excel Advanced Parramatta
Maria - Excel Advanced, .
Good Course -Excel Advanced Parramatta
Baminahannadige - Excel Advanced, .
Michael is a very good teacher, he is very thorough with his explanations. Knows how to deliver the message across very well, is clearly very experienced with Microsoft. I would definitely recommend him and would enrol for another one of his classes if need be. -Excel Advanced Parramatta
Estephanos - Excel Advanced, .
Course was quite good, I picked up quite a few things but as there is so much to cover some things were skipped through quite quickly. Jag was very good at making sure everyone understood. -Excel Intermediate Adelaide
Bev - Excel Intermediate, .
It was a great day - learnt a lot of new things :) -Excel Intermediate Adelaide
Deborah - Excel Intermediate, .
very well explained, easy to understand -Excel Intermediate Adelaide
Borbasi - Excel Intermediate, .
Very well Done -Excel Intermediate Adelaide
Vladimir - Excel Intermediate, .
Excellent. Good pace and learnt lots -Excel Intermediate Adelaide
Debra - Excel Intermediate, .
Jason covered the content well and was great at explained everything -Excel Intermediate Canberra
Lisa - Excel Intermediate, .
Great course & Jason was a great facilitator. Challenging working remotely on a laptop. I personally didn't have two screens available & I think that would make it a lot easier to navigate but that aside, the pace of the course allowed for minimal inconvenience. -Excel Intermediate Canberra
Kyle - Excel Intermediate, .
Very informative. Thank you for a great lesson -Excel Intermediate Canberra
Peter - Excel Intermediate, .
Great Course! Very informing and helpful! Great teacher who encouraged questions and answered them thoroughly; thank you! -Excel Intermediate Parramatta
Charbel - Excel Intermediate, .
good and prompt view of using excel -Excel Intermediate Parramatta
Vincent - Excel Intermediate, .
Very good and fast paced course with very key concepts covered. -Excel Intermediate Parramatta
Vladimir - Excel Intermediate, .
A great course to understand some extra perks on Excel Michael was very helpful and engaging! Would recommend this course -Excel Intermediate Parramatta
Joseph - Excel Intermediate, .
Good crash course and very helpful -Excel Intermediate Parramatta
Mohan - Excel Intermediate, .
Ken was really great, very passionate about experienced presenter. Really enjoyed the intermediate session. Got a lot of useful tips on how to work more efficiently in MS Project Professional. Thanks Ken -Project Beginner - Project Intermediate Remote Online
Therese - Project Beginner - Project Intermediate, .

Trusted by Business

Procured by Government

Map of Australia