Attend courses from home - All courses REMOTE from April 1 - April 30

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 April 30 will be delivered remotely.
Normal classes at oursite to resume thereafter, dates subject to review.


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

Upcoming Courses:
Brisbane
Date
Course
City
Status
Thu 2-Apr-20
Power BI DAX
Brisbane
Confirmed
Mon 6-Apr-20
Power BI DAX
Brisbane
Scheduled
Fri 24-Apr-20
Power BI DAX
Brisbane
Scheduled
Thu 30-Apr-20
Power BI DAX
Brisbane
Scheduled
Thu 28-May-20
Power BI DAX
Brisbane
Scheduled
Mon 29-Jun-20
Power BI DAX
Brisbane
Scheduled
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
Sydney
Date
Course
City
Status
Thu 2-Apr-20
Power BI DAX
Sydney
Confirmed
Mon 6-Apr-20
Power BI DAX
Sydney
Scheduled
Fri 24-Apr-20
Power BI DAX
Sydney
Confirmed
Thu 30-Apr-20
Power BI DAX
Sydney
Scheduled
Thu 28-May-20
Power BI DAX
Sydney
Scheduled
Mon 29-Jun-20
Power BI DAX
Sydney
Scheduled
Fri 17-Jul-20
Power BI DAX
Sydney
Scheduled
Fri 31-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
Parramatta
Date
Course
City
Status
Thu 2-Apr-20
Power BI DAX
Parramatta
Confirmed
Mon 6-Apr-20
Power BI DAX
Parramatta
Scheduled
Fri 24-Apr-20
Power BI DAX
Parramatta
Scheduled
Thu 30-Apr-20
Power BI DAX
Parramatta
Scheduled
Fri 12-Jun-20
Power BI DAX
Parramatta
Scheduled
Melbourne
Date
Course
City
Status
Thu 2-Apr-20
Power BI DAX
Melbourne
Confirmed
Mon 6-Apr-20
Power BI DAX
Melbourne
Scheduled
Fri 24-Apr-20
Power BI DAX
Melbourne
Confirmed
Thu 30-Apr-20
Power BI DAX
Melbourne
Scheduled
Thu 28-May-20
Power BI DAX
Melbourne
Scheduled
Mon 29-Jun-20
Power BI DAX
Melbourne
Scheduled
Fri 17-Jul-20
Power BI DAX
Melbourne
Scheduled
Fri 31-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
Canberra
Date
Course
City
Status
Thu 2-Apr-20
Power BI DAX
Canberra
Confirmed
Mon 6-Apr-20
Power BI DAX
Canberra
Confirmed
Fri 24-Apr-20
Power BI DAX
Canberra
Scheduled
Thu 30-Apr-20
Power BI DAX
Canberra
Scheduled
Fri 12-Jun-20
Power BI DAX
Canberra
Scheduled
Adelaide
Date
Course
City
Status
Thu 2-Apr-20
Power BI DAX
Adelaide
Confirmed
Mon 6-Apr-20
Power BI DAX
Adelaide
Scheduled
Fri 24-Apr-20
Power BI DAX
Adelaide
Scheduled
Thu 30-Apr-20
Power BI DAX
Adelaide
Confirmed
Fri 12-Jun-20
Power BI DAX
Adelaide
Scheduled
Perth
Date
Course
City
Status
Thu 2-Apr-20
Power BI DAX
Perth
Confirmed
Mon 6-Apr-20
Power BI DAX
Perth
Scheduled
Fri 24-Apr-20
Power BI DAX
Perth
Scheduled
Thu 30-Apr-20
Power BI DAX
Perth
Confirmed
Fri 22-May-20
Power BI DAX
Perth
Confirmed
Fri 12-Jun-20
Power BI DAX
Perth
Scheduled
Fri 17-Jul-20
Power BI DAX
Perth
Scheduled
Fri 31-Jul-20
Power BI DAX
Perth
Scheduled
Mon 31-Aug-20
Power BI DAX
Perth
Scheduled
Fri 30-Oct-20
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
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - April 30.** Resuming L10, 333 Adelaide Street, Brisbane QLD 4000 thereafter
microsoft_gold

Power BI DAX Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - April 30.** Resuming Level 3, 37 Pitt Street, Sydney NSW 2000 thereafter
microsoft_gold

Power BI DAX Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - April 30.** Resuming Level 3, 90 Phillip Street, Parramatta NSW 2150 thereafter
microsoft_gold

Power BI DAX Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - April 30.** Resuming Level 3, 466 Little Lonsdale St, Melbourne VIC 3000 thereafter
microsoft_gold

Power BI DAX Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - April 30.** Resuming Ethos House, Level 1, 28 Ainslie Place, Canberra ACT 2601 thereafter
microsoft_gold

Power BI DAX Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - April 30.** Resuming Level 3, 97 Pirie Street, Adelaide SA 5000 thereafter
microsoft_gold

Power BI DAX Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Manuals
Provided
Training Computer
Provided
CPD Hours
6 hours
Address
**All courses REMOTE from April 1 - April 30.** Resuming Level 4, 220 St Georges Tce, Perth WA 6000 thereafter
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
  • 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
5423 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 20017 Reviews
Ken, is a very qualified professional. I am very keen to start doing my own developments and get ready for the next level. Thanks to Nexacu for organizing the course online in this hard times. -Power BI Beginner Melbourne
Vanessa - Power BI Beginner, .
I found this course highly valuable, with excellent coverage across a range of PowerBI functions I can see myself using in my day-to-day work. Ken was a fantastic facilitator, and the change to online delivery (due to COVID-19) didn't prove to be an impediment at all. -Power BI Beginner Melbourne
Dean - Power BI Beginner, .
Ken was great! Would love to see him in future courses that I complete. -Power BI Beginner Melbourne
Tracey - Power BI Beginner, .
Ken is good - would like to have have him as trainer in the future -Power BI Beginner Melbourne
Luis - Power BI Beginner, .
Great -Excel Intermediate Sydney
Liz - Excel Intermediate, .
Instructor was very knowledgeable, course content was excellent. -Excel Intermediate Sydney
Louise - Excel Intermediate, .
very engaging for long online session -Excel Intermediate Sydney
cecelia - Excel Intermediate, .
Great instruction from David! The content was easy to follow, went at a manageable pace and he was accommodating to questions that were not in the course content. I have learnt some very valuable new skills, thank you David! -Excel Advanced Perth
Holly - Excel Advanced, .
Excellent course, very well explained and learned a the CORRECT way to operate in excel. Thanks for your patience Dave -Excel Advanced Perth
Russell - Excel Advanced, .
Excellent session. Very informative and enjoyable. Learnt heaps in a friendly environment. Thank you Dave -Excel Advanced Perth
Hans - Excel Advanced, .
good presentation skills kept it entertaining despite the remoteness -Power BI Intermediate Perth
oliver - Power BI Intermediate, .
Excellent course and Dom is superb as usual. -Power BI Intermediate Perth
Chandra - Power BI Intermediate, .
Domenic has been a good solid instructor with excellent knowledge of the product and great at problem-solving. Thanks Dom! -Power BI Intermediate Perth
Louie - Power BI Intermediate, .
Once again fantastic course, very helpful and easy to learn. No issues using remote learning for the first time. -Power BI Intermediate Perth
Alissa - Power BI Intermediate, .
N/A -Power BI Intermediate Perth
Ehsan - Power BI Intermediate, .
Great course, very interesting and informative! -Power BI Desktop Beginner Canberra
Mel - Power BI Desktop Beginner, .
The beginner Power BI course was very informative and well run. -Power BI Desktop Beginner Canberra
L - Power BI Desktop Beginner, .
Content was explained thoroughly and in an entertaining way. Very knowledgeable trainer and was able to and demonstrate all answers to questions. -Power BI Desktop Beginner Canberra
Tess - Power BI Desktop Beginner, .
Thank you, for the fantastic course. Learnt a lot that I can use for work. -Power BI Desktop Beginner Canberra
MH - Power BI Desktop Beginner, .
Great course, very interactive. Well laid out and presented. -Power BI Desktop Beginner Canberra
Sarah - Power BI Desktop Beginner, .

Trusted by Business

Procured by Government

Map of Australia