All courses REMOTE until June 30 | Limited in-class sessions in June - Call Us | From July 1 all courses available in-class and remotely

power bi courses nexacu

Microsoft Power BI DAX Training Course

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

Sign up for any course and remote login details will be provided.
All classes from April 1 to June 30 will be delivered remotely.
Call to attend in person, limited in-class sessions available from Jun 1.


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

Brisbane

Sydney

Parramatta

Melbourne

Canberra

Adelaide

Perth

Remote Online

Upcoming Courses:
Brisbane
Date
Course
City
Status
Fri 12-Jun-20
Power BI DAX
Brisbane
Confirmed
Mon 29-Jun-20
Power BI DAX
Brisbane
Confirmed
Fri 17-Jul-20
Power BI DAX
Brisbane
Scheduled
Fri 31-Jul-20
Power BI DAX
Brisbane
Scheduled
Mon 31-Aug-20
Power BI DAX
Brisbane
Scheduled
Fri 25-Sep-20
Power BI DAX
Brisbane
Scheduled
Fri 30-Oct-20
Power BI DAX
Brisbane
Scheduled
Wed 18-Nov-20
Power BI DAX
Brisbane
Scheduled
Sydney
Date
Course
City
Status
Fri 12-Jun-20
Power BI DAX
Sydney
Confirmed
Mon 29-Jun-20
Power BI DAX
Sydney
Confirmed
Fri 17-Jul-20
Power BI DAX
Sydney
Scheduled
Mon 31-Aug-20
Power BI DAX
Sydney
Scheduled
Fri 25-Sep-20
Power BI DAX
Sydney
Scheduled
Fri 30-Oct-20
Power BI DAX
Sydney
Scheduled
Wed 18-Nov-20
Power BI DAX
Sydney
Scheduled
Parramatta
Date
Course
City
Status
Fri 12-Jun-20
Power BI DAX
Parramatta
Confirmed
Mon 29-Jun-20
Power BI DAX
Parramatta
Confirmed
Melbourne
Date
Course
City
Status
Fri 12-Jun-20
Power BI DAX
Melbourne
Confirmed
Mon 29-Jun-20
Power BI DAX
Melbourne
Confirmed
Fri 17-Jul-20
Power BI DAX
Melbourne
Scheduled
Mon 31-Aug-20
Power BI DAX
Melbourne
Scheduled
Fri 30-Oct-20
Power BI DAX
Melbourne
Scheduled
Wed 18-Nov-20
Power BI DAX
Melbourne
Scheduled
Canberra
Date
Course
City
Status
Fri 12-Jun-20
Power BI DAX
Canberra
Confirmed
Mon 29-Jun-20
Power BI DAX
Canberra
Confirmed
Fri 24-Jul-20
Power BI DAX
Canberra
Scheduled
Adelaide
Date
Course
City
Status
Fri 12-Jun-20
Power BI DAX
Adelaide
Confirmed
Mon 29-Jun-20
Power BI DAX
Adelaide
Confirmed
Thu 23-Jul-20
Power BI DAX
Adelaide
Scheduled
Perth
Date
Course
City
Status
Fri 12-Jun-20
Power BI DAX
Perth
Confirmed
Mon 29-Jun-20
Power BI DAX
Perth
Confirmed
Fri 31-Jul-20
Power BI DAX
Perth
Confirmed
Mon 31-Aug-20
Power BI DAX
Perth
Scheduled
Fri 30-Oct-20
Power BI DAX
Perth
Scheduled
Wed 18-Nov-20
Power BI DAX
Perth
Scheduled
Remote Online
Date
Course
City
Status
Fri 12-Jun-20
Power BI DAX
Remote Online
Confirmed
Mon 29-Jun-20
Power BI DAX
Remote Online
Confirmed
Fri 17-Jul-20
Power BI DAX
Remote Online
Scheduled
Thu 23-Jul-20
Power BI DAX
Remote Online
Scheduled
Fri 24-Jul-20
Power BI DAX
Remote Online
Scheduled
Fri 31-Jul-20
Power BI DAX
Remote Online
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
Time
9am - 4pm ( approx )
Class Size (max)
Capped*
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - June 30** Resuming thereafter at 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 Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - June 30** Resuming thereafter at 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 Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - June 30** Resuming thereafter at 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 Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - June 30** Resuming thereafter at 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 Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - June 30** Resuming thereafter at 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 Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - June 30** Resuming thereafter at 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 Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - June 30** Resuming thereafter at Level 4, 220 St Georges Tce, Perth WA 6000

*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 Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - June 30** Resuming thereafter at Australia

*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 PowerApps 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
  • Teach Remotely Training Courses
Course Rating
Microsoft Power BI Training Courses

4.70 5 Microsoft Power BI Training Courses
4.70 out of 5
5603 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 20915 Reviews
An engaging course that covers the main O365 collaboration applications and their purpose. Domenic presents very well and ensures participants aren't left behind. Thank you -Office365 Beginner Perth
Shane - Office365 Beginner, .
Great course. Very informative. Picked up plenty of new skills. Thank you Jagg for a great experience. -Excel Intermediate Adelaide
Roman - Excel Intermediate, .
Thanks for the training today! -Office365 Beginner Perth
Chun - Office365 Beginner, .
Really enjoyed the course, Dom was very thorough. -Office365 Beginner Perth
Halie - Office365 Beginner, .
Jagg was very clear and was always enthused and patient with us. He answered every question and taught be me loads. Thanks Jagg, great session and very beneficial. Bec -Excel Intermediate Adelaide
Rebecca - Excel Intermediate, .
Jagg was very friendly, very thorough and often asked how we were going or if we needed help or had any questions. Very informative course, thank you :) -Excel Intermediate Adelaide
Jo - Excel Intermediate, .
The trainer was excellent. He explained the concepts very well and was at a good pace. Enjoyed the session. I found though for myself that the intermediate was a bit basic. Would of preferred to learn more what employers are after which is the IFSUM, VLOOKUP, More complex formula's from different sources etc. -Excel Intermediate Adelaide
Melanie - Excel Intermediate, .
Jagg was excellent. Very patient and explained instruction at an easy pace. Coping with remote students as well as in classroom. Everything we learned was new to me and added to my knowledge!! Thank you! -Excel Intermediate Adelaide
Lee-Anne - Excel Intermediate, .
Very enlightening and informative. well paced. -Excel Intermediate Adelaide
Paul - Excel Intermediate, .
Informative ! -Office365 Beginner Perth
Narissara - Office365 Beginner, .
Fantastic. Lots of useful information. Thank you. -Excel Intermediate Adelaide
Melissa - Excel Intermediate, .
Steven was very good and very patient. Overall a good course. -SharePoint Site Owner Brisbane
Lisa - SharePoint Site Owner, .
Very interesting course, thank you Steven. -SharePoint Site Owner Brisbane
Karen - SharePoint Site Owner, .
Jason you were an absolute champion throughout, I was worried I wouldn't keep up but you helped all along the way. Thank you. -Excel Macros/VBA 2 Day Sydney
Anna - Excel Macros/VBA 2 Day, .
I really enjoyed the on-line training there was no over talking and Steven explained everything quite well. The content did cover a lot of detail but it was very useful and now need to apply in the office and demonstrate how efficient the use of SharePoint is. -SharePoint Site Owner Brisbane
Leesa - SharePoint Site Owner, .
Could not recommend this enough for those structuring and setting up a SharePoint site. The onsite learning was fantastic and easy to follow along with. -SharePoint Site Owner Brisbane
Penny - SharePoint Site Owner, .
Great course, learned a lot of new features. Looking forward to the next one. -Excel Macros/VBA 2 Day Sydney
Bertalan - Excel Macros/VBA 2 Day, .
Thankyou Jason for sharing your expertise. I have learnt a lot and will definitely use things I have learnt here professionally. Easy to follow along and always polite -Excel Macros/VBA 2 Day Sydney
Dane - Excel Macros/VBA 2 Day, .
Thank you , the course was very helpful -Excel Beginner - Excel Intermediate Sydney
Andy - Excel Beginner - Excel Intermediate, .
Thank You -Excel Beginner - Excel Intermediate Sydney
shannon - Excel Beginner - Excel Intermediate, .

Trusted by Business

Procured by Government

Map of Australia