power bi courses nexacu

Power BI DAX Training Course

Learn the fundamentals of DAX on our One-Day Course

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.

Brisbane
Sydney
Parramatta
Melbourne
Canberra
Adelaide
Perth
Upcoming Courses:
Brisbane
Date
Course
City
Status
Wed 20-Nov-19
Power BI DAX
Brisbane
Scheduled
Thu 5-Dec-19
Power BI DAX
Brisbane
Scheduled
Thu 9-Jan-20
Power BI DAX
Brisbane
Scheduled
Fri 28-Feb-20
Power BI DAX
Brisbane
Scheduled
Thu 2-Apr-20
Power BI DAX
Brisbane
Scheduled
Fri 24-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
Sydney
Date
Course
City
Status
Thu 7-Nov-19
Power BI DAX
Sydney
Scheduled
Wed 20-Nov-19
Power BI DAX
Sydney
Scheduled
Thu 5-Dec-19
Power BI DAX
Sydney
Scheduled
Thu 9-Jan-20
Power BI DAX
Sydney
Scheduled
Fri 28-Feb-20
Power BI DAX
Sydney
Scheduled
Thu 2-Apr-20
Power BI DAX
Sydney
Scheduled
Fri 24-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
Parramatta
Date
Course
City
Status
Fri 15-Nov-19
Power BI DAX
Parramatta
Scheduled
Thu 12-Dec-19
Power BI DAX
Parramatta
Scheduled
Thu 9-Jan-20
Power BI DAX
Parramatta
Scheduled
Fri 21-Feb-20
Power BI DAX
Parramatta
Scheduled
Mon 6-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
Wed 20-Nov-19
Power BI DAX
Melbourne
Few Seats
Thu 9-Jan-20
Power BI DAX
Melbourne
Scheduled
Fri 28-Feb-20
Power BI DAX
Melbourne
Scheduled
Thu 2-Apr-20
Power BI DAX
Melbourne
Scheduled
Fri 24-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
Canberra
Date
Course
City
Status
Tue 22-Oct-19
Power BI DAX
Canberra
Scheduled
Fri 29-Nov-19
Power BI DAX
Canberra
Scheduled
Thu 12-Dec-19
Power BI DAX
Canberra
Scheduled
Thu 9-Jan-20
Power BI DAX
Canberra
Scheduled
Fri 21-Feb-20
Power BI DAX
Canberra
Scheduled
Mon 6-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 9-Jan-20
Power BI DAX
Adelaide
Scheduled
Fri 21-Feb-20
Power BI DAX
Adelaide
Scheduled
Mon 6-Apr-20
Power BI DAX
Adelaide
Scheduled
Thu 30-Apr-20
Power BI DAX
Adelaide
Scheduled
Fri 12-Jun-20
Power BI DAX
Adelaide
Scheduled
Perth
Date
Course
City
Status
Fri 15-Nov-19
Power BI DAX
Perth
Few Seats
Thu 12-Dec-19
Power BI DAX
Perth
Confirmed
Thu 9-Jan-20
Power BI DAX
Perth
Scheduled
Fri 21-Feb-20
Power BI DAX
Perth
Scheduled
Mon 6-Apr-20
Power BI DAX
Perth
Scheduled
Thu 30-Apr-20
Power BI DAX
Perth
Scheduled
Fri 12-Jun-20
Power BI DAX
Perth
Scheduled
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.
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
Level 10 333 Adelaide St Brisbane QLD, 4000
microsoft_gold
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
Level 3 37 Pitt Street Sydney NSW, 2000
microsoft_gold
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
Level 3 90 Phillip Street Parramatta NSW, 2150
microsoft_gold
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
Level 3 466 Little Lonsdale St Melbourne VIC, 3000
microsoft_gold
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
Level 1 28 Ainslie Place Canberra ACT, 2601
microsoft_gold
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
Level 3 97 Pirie Street Adelaide SA, 5000
microsoft_gold
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
Level 1 140 St Georges Tce Perth CBD, WA, 6000
microsoft_gold
Course structure
  • Power BI Beginner
  • Power BI Intermediate
  • Power BI Advanced
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
  • Microsoft PowerPoint Training Courses
  • Microsoft Word Training Courses

Skills Test

Try our short skills test and find out which course is right for you.

 skills test

 

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.
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
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

Why choose Nexacu?

Valued by Individuals

4.8/5
Over 15764 Reviews
Great trainer and very helpful with my questions. -Power BI Beginner Parramatta
Tamara - Power BI Beginner, .
Great Power Bi Beginner course, very well structured. -Power BI Beginner Parramatta
Theresa - Power BI Beginner, .
Great content - wish I had done this ages ago -Power BI Beginner Parramatta
Kimberley - Power BI Beginner, .
Excellent course with a highly knowledgeable facilitator. I can certainly see the application in my workspace with benefits of enhanced data interpretation and presentation at a faction of the time it's currently taking us. -Power BI Beginner Canberra
Sophie - Power BI Beginner, .
Thanks for a great course today -Excel Advanced Perth
Annabelle - Excel Advanced, .
Very well presented & easy to follow
Annabelle - Excel Advanced, .
Very informative and understandable delivery.
Sara - Excel Advanced, .
Domenic was a great trainer. The worksheets and exercises were easy to follow and the content from the Excel Advanced course will be very useful at my workplace.
Cassandra - Excel Advanced, .
Amazing course
Josh - Excel Intermediate, .
Great course, well set out.
Gary - Project Intermediate, .
Great beginner course, learnt a lot!
Josh - Excel Beginner, .
Good course, covered plenty of content.
Brent - Project Intermediate, .
Lots of informative content
Conor - Project Intermediate, .
Great course.
Todd - Project Intermediate, .
Greg did very well. it was totally new learning for me.
Musi - Power BI Intermediate, .
Overall I enjoyed learning about Power BI. Greg was a great instructor and very approachable. I would suggest for the course to go at slightly slower pace, there were times I missed key information and steps.
CF - Project Intermediate, .
Thank you.
Susan - SharePoint Site Owner, .
Good course - in-depth and relevant content. Trainer is excellent, entertaining and engaging. Would highly recommend.
Nick - Power BI Intermediate, .
Presenter had great skills and knowledge. Would be good to have pen and paper provided for note taking and doodling (sometimes helps me think).
Bon - Power BI Intermediate, .
Was a great lesson. Definitely learnt heaps. It is a lot to take in for one day. Ken was a good teacher.
Paul - Project Beginner, .

Trusted by Business

Procured by Government

Map of Australia