Learn the fundamentals of DAX on our One-Day Course

laptop

Filter and Rank

browser-4

Relationships and Tables

analytics-4

Contexts

analytics-2

Functions


SydneyMelbourneBrisbanePerthAdelaideParramattaCanberra

BOOK NOW

Course Details

  • Price: $605
  • 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

Course Content

PDFPower BI DAX
Students should have attended our Power BI Advanced course. Our Power BI DAX course builds upon the skills taught in Advanced.
Upcoming Dates
Tue 28-May-19 Power BI DAX Sydney Course confirmed to run. Trainer has been allocated.
Wed 05-Jun-19 Power BI DAX Sydney Course has been scheduled to run but has not been confirmed.
Tue 25-Jun-19 Power BI DAX Sydney Course has been scheduled to run but has not been confirmed.
Fri 05-Jul-19 Power BI DAX Sydney Course has been scheduled to run but has not been confirmed.
Wed 24-Jul-19 Power BI DAX Sydney Course has been scheduled to run but has not been confirmed.
Tue 06-Aug-19 Power BI DAX Sydney Course has been scheduled to run but has not been confirmed.
Thu 29-Aug-19 Power BI DAX Sydney Course has been scheduled to run but has not been confirmed.
Mon 16-Sep-19 Power BI DAX Sydney Course has been scheduled to run but has not been confirmed.
Tue 01-Oct-19 Power BI DAX Sydney Course has been scheduled to run but has not been confirmed.
Wed 16-Oct-19 Power BI DAX Sydney Course has been scheduled to run but has not been confirmed.
Thu 07-Nov-19 Power BI DAX Sydney Course has been scheduled to run but has not been confirmed.
Wed 20-Nov-19 Power BI DAX Sydney Course has been scheduled to run but has not been confirmed.
Thu 05-Dec-19 Power BI DAX Sydney Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details

  • Price: $605
  • 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

Course Content

PDFPower BI DAX
Students should have attended our Power BI Advanced course. Our Power BI DAX course builds upon the skills taught in Advanced.
Upcoming Dates
Tue 21-May-19 Power BI DAX Melbourne Course confirmed to run. Trainer has been allocated.
Fri 21-Jun-19 Power BI DAX Melbourne Course has been scheduled to run but has not been confirmed.
Fri 05-Jul-19 Power BI DAX Melbourne Course has been scheduled to run but has not been confirmed.
Wed 24-Jul-19 Power BI DAX Melbourne Course has been scheduled to run but has not been confirmed.
Tue 06-Aug-19 Power BI DAX Melbourne Course has been scheduled to run but has not been confirmed.
Thu 29-Aug-19 Power BI DAX Melbourne Course has been scheduled to run but has not been confirmed.
Mon 16-Sep-19 Power BI DAX Melbourne Course has been scheduled to run but has not been confirmed.
Tue 01-Oct-19 Power BI DAX Melbourne Course has been scheduled to run but has not been confirmed.
Wed 16-Oct-19 Power BI DAX Melbourne Course has been scheduled to run but has not been confirmed.
Thu 07-Nov-19 Power BI DAX Melbourne Course has been scheduled to run but has not been confirmed.
Wed 20-Nov-19 Power BI DAX Melbourne Course has been scheduled to run but has not been confirmed.
Thu 05-Dec-19 Power BI DAX Melbourne Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details

  • Price: $605
  • 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

Course Content

PDFPower BI DAX
Students should have attended our Power BI Advanced course. Our Power BI DAX course builds upon the skills taught in Advanced.
Upcoming Dates
Mon 10-Jun-19 Power BI DAX Brisbane Course has been scheduled to run but has not been confirmed.
Fri 21-Jun-19 Power BI DAX Brisbane Course has been scheduled to run but has not been confirmed.
Fri 05-Jul-19 Power BI DAX Brisbane Course has been scheduled to run but has not been confirmed.
Wed 24-Jul-19 Power BI DAX Brisbane Course has been scheduled to run but has not been confirmed.
Tue 06-Aug-19 Power BI DAX Brisbane Course has been scheduled to run but has not been confirmed.
Thu 29-Aug-19 Power BI DAX Brisbane Course has been scheduled to run but has not been confirmed.
Mon 16-Sep-19 Power BI DAX Brisbane Course has been scheduled to run but has not been confirmed.
Tue 01-Oct-19 Power BI DAX Brisbane Course has been scheduled to run but has not been confirmed.
Wed 16-Oct-19 Power BI DAX Brisbane Course has been scheduled to run but has not been confirmed.
Thu 07-Nov-19 Power BI DAX Brisbane Course has been scheduled to run but has not been confirmed.
Wed 20-Nov-19 Power BI DAX Brisbane Course has been scheduled to run but has not been confirmed.
Thu 05-Dec-19 Power BI DAX Brisbane Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details

  • Price: $605
  • 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

Course Content

PDFPower BI DAX
Students should have attended our Power BI Advanced course. Our Power BI DAX course builds upon the skills taught in Advanced.
Upcoming Dates
Wed 12-Jun-19 Power BI DAX Perth Course has been scheduled to run but has not been confirmed.
Fri 05-Jul-19 Power BI DAX Perth Course has been scheduled to run but has not been confirmed.
Thu 25-Jul-19 Power BI DAX Perth Course has been scheduled to run but has not been confirmed.
Mon 12-Aug-19 Power BI DAX Perth Course has been scheduled to run but has not been confirmed.
Thu 05-Sep-19 Power BI DAX Perth Course has been scheduled to run but has not been confirmed.
Wed 25-Sep-19 Power BI DAX Perth Course has been scheduled to run but has not been confirmed.
Tue 22-Oct-19 Power BI DAX Perth Course has been scheduled to run but has not been confirmed.
Fri 15-Nov-19 Power BI DAX Perth Course has been scheduled to run but has not been confirmed.
Thu 12-Dec-19 Power BI DAX Perth Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details

  • Price: $605
  • 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

Course Content

PDFPower BI DAX
Students should have attended our Power BI Advanced course. Our Power BI DAX course builds upon the skills taught in Advanced.
Upcoming Dates
Wed 12-Jun-19 Power BI DAX Adelaide Course has been scheduled to run but has not been confirmed.
Fri 05-Jul-19 Power BI DAX Adelaide Course has been scheduled to run but has not been confirmed.
Thu 25-Jul-19 Power BI DAX Adelaide Course has been scheduled to run but has not been confirmed.
Mon 12-Aug-19 Power BI DAX Adelaide Course has been scheduled to run but has not been confirmed.
Thu 05-Sep-19 Power BI DAX Adelaide Course has been scheduled to run but has not been confirmed.
Wed 25-Sep-19 Power BI DAX Adelaide Course has been scheduled to run but has not been confirmed.
Tue 22-Oct-19 Power BI DAX Adelaide Course has been scheduled to run but has not been confirmed.
Fri 15-Nov-19 Power BI DAX Adelaide Course has been scheduled to run but has not been confirmed.
Thu 12-Dec-19 Power BI DAX Adelaide Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details

  • Price: $605
  • 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

Course Content

PDFPower BI DAX
Students should have attended our Power BI Advanced course. Our Power BI DAX course builds upon the skills taught in Advanced.
Upcoming Dates
Fri 05-Jul-19 Power BI DAX Parramatta Course has been scheduled to run but has not been confirmed.
Thu 25-Jul-19 Power BI DAX Parramatta Course has been scheduled to run but has not been confirmed.
Mon 12-Aug-19 Power BI DAX Parramatta Course has been scheduled to run but has not been confirmed.
Thu 05-Sep-19 Power BI DAX Parramatta Course has been scheduled to run but has not been confirmed.
Wed 25-Sep-19 Power BI DAX Parramatta Course has been scheduled to run but has not been confirmed.
Tue 22-Oct-19 Power BI DAX Parramatta Course has been scheduled to run but has not been confirmed.
Fri 15-Nov-19 Power BI DAX Parramatta Course has been scheduled to run but has not been confirmed.
Thu 12-Dec-19 Power BI DAX Parramatta Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details

  • Price: $605
  • 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

Course Content

PDFPower BI DAX
Students should have attended our Power BI Advanced course. Our Power BI DAX course builds upon the skills taught in Advanced.
Upcoming Dates
Thu 16-May-19 Power BI DAX Canberra Course has been scheduled to run but has not been confirmed.
Fri 14-Jun-19 Power BI DAX Canberra Course has been scheduled to run but has not been confirmed.
Fri 05-Jul-19 Power BI DAX Canberra Course has been scheduled to run but has not been confirmed.
Thu 25-Jul-19 Power BI DAX Canberra Course has been scheduled to run but has not been confirmed.
Mon 12-Aug-19 Power BI DAX Canberra Course has been scheduled to run but has not been confirmed.
Thu 05-Sep-19 Power BI DAX Canberra Course has been scheduled to run but has not been confirmed.
Wed 25-Sep-19 Power BI DAX Canberra Course has been scheduled to run but has not been confirmed.
Tue 22-Oct-19 Power BI DAX Canberra Course has been scheduled to run but has not been confirmed.
Fri 15-Nov-19 Power BI DAX Canberra Course has been scheduled to run but has not been confirmed.
Thu 12-Dec-19 Power BI DAX Canberra Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

Improve your Power BI modelling know-how
student

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.

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.

tasks

Learning Outcomes – Power BI DAX

On completion of this course you should be able to

  • 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 Details
  • circular-clockCourses will run from 9am – 4pm (approx.)
  • network-1Classes limited to approx 10 people
  • Power BI DAX costs $605
  • book-2Reference Manuals provided
  • maps-and-flags-1Central city locations
Each Student receives
  • book-1Reference Workbooks
  • e-Certificate of attendance
  • customer-service-2Complimentary post course training e-support
  • dart-boardTrained by a Microsoft Certified Expert
  • likeSatisfaction guarantee or repeat FREE within 6mths
Course Content

power-bi-icon_75Course Introduction

  • Overview of DAX
  • DAX in Power BI and elsewhere
  • Differences in DAX across products
  • DAX in PowerPivot
  • DAX in SSAS
  • DAX references
  • DAX best practices

power-bi-icon_75Recap of Contexts

  • Evaluation Contexts in DAX
  • The Filter Context
  • The Query Context and source of
  • An example of Filter Context
  • The Row Context
  • An example of Row Context
  • The CALCULATE function
  • The Rules of Evaluation
  • Filter modification
  • Filters applied to tables
  • Filters propagate through relationships
  • Using the CALCULATE function
  • CALCULATE in an iterator
  • Seeing the impact of CALCULATE in an iterator

power-bi-icon_75Relationships and Ranges

  • Introduction to relationships and ranges
  • Scenarios where ranges are used
  • How traditional apps use range relationships
  • Creating a combined key in the data model
  • Establish relationship on combined key
  • Disadvantage of combined key approach
  • Using ranges to define a relationship
  • Expressions to use for ranges

power-bi-icon_75Understanding FILTER

  • Recap of the FILTER function
  • Contexts in the FILTER function
  • Naked column references
  • Functions such as aggregators
  • Creating a simple FILTER example
  • Designing a custom time intelligence function
  • A more advanced custom function
  • The impact of clearing filters on a column with sort by
  • Seeing the incorrect result because of sort by
  • Adjusting the expression to fix the sort by implication
  • Wrap up of the FILTER function

power-bi-icon_75Nested Row Context

  • Introduction to nesting row context
  • The EARLIER function
  • The EARLIEST function
  • Other similar nesting functions
  • Using variables to reduce difficulty
  • Recommended best practise for dealing with nested row contexts

power-bi-icon_75Summary Table Functions

  • Introduction to Table functions
  • Summarising tables
  • Using SUMMARIZE alone
  • Disadvantage of using just SUMMARIZE
  • Combining SUMMARIZE with ADDCOLUMNS
  • Using SUMMARIZECOLUMNS as a better alternative
  • Difference between the two summary approaches (DAX versions)
  • Creating totals and sub-totals within SUMMARIZECOLUMNS
  • Handling totals and sub-totals in DAX summary tables

power-bi-icon_75Ranking

  • Overview of the RANKX function
  • Different definitions of ranking ties
  • Using RANKX in a column
  • Create a calculated column for ranking
  • Using RANKX in a measure
  • Create a measure for ranking
  • The 3rd ‘value’ argument of RANKX
  • Create own RANKX function using nested rows

power-bi-icon_75Common Calculations with DAX

  • Overview of common calculations
  • Determine ratios Finding percentages of
  • Finding the cumulative total
  • Alternative for sales per day
  • Comparing min / max to first / last for dates
  • Common Statistical and financial functions

 


power-bi-icon_75DAX Tools

  • Introduction to best tools
  • Introduction to DAX Studio
  • Basics of using DAX Studio
  • How DAX Studio connects to Power BI Desktop
  • How DAX Studio connects to Excel Power Pivot
  • Connect to Power BI Desktop
  • View data model information
  • View behind the scenes information
  • How to run queries
  • Create a simple table query
  • How to create a scalar query
  • Defining a measure

power-bi-icon_75DAX Performance

  • Introduction to optimisation of DAX
  • How to clear the cache
  • Steps to take to create efficient DAX
  • Finding a bottleneck in the storage engine example
  • Fixing the bottleneck in SE and reviewing the results
  • Finding a bottleneck in the formula engine
  • Fixing the bottleneck in FE and reviewing the results
  • Reducing CallBackID instances

power-bi-icon_75Query Plans

  • Introduction to the query plan
  • Overview of the engines
  • The formula engine
  • The storage engine
  • The datacache
  • The CallBackID function
  • Capturing a query from Power BI

power-bi-icon_75DAX Optimisation

  • Introduction to optimisation of DAX
  • Clearing the cache
  • Steps to take to create efficient DAX
  • Finding a bottleneck in the storage engine
  • Finding a bottleneck in the formula engine
  • Reducing CallBackID instances

 

student_sat

Average rating:  
 11888 reviews

Ken was an excellent teacher - Enthusiastic , patience and took time. I am walking away with better understanding of conditional formatting that will transform my project management skills. I am looking forward to implementing these new skills and hopefully complete the advance training in a few months. - Excel Intermediate Melbourne

Page 1 of 11888:
«
 
 
1
2
3
 
»
 
Download Course Content Here