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

Power BI DAX Training Course

Learn Power BI DAX from our experienced trainers in our remote courses, live online.
RM 1,790
10 max
1 day

Kuala Lumpur

Upcoming Courses:
Kuala Lumpur
Date
Course
City
Status
Wed 10 Jul 24
Wed
10
Jul
Power BI Advanced
Kuala Lumpur
Status: Confirmed
Confirmed
Thu 8 Aug 24
Thu
8
Aug
Power BI Advanced
Kuala Lumpur
Status: Sold Out
Sold Out
Tue 27 Aug 24
Tue
27
Aug
Power BI Advanced
Kuala Lumpur
Status: Scheduled
Scheduled
Thu 5 Sep 24
Thu
5
Sep
Power BI Advanced
Kuala Lumpur
Status: Scheduled
Scheduled
Fri 4 Oct 24
Fri
4
Oct
Power BI Advanced
Kuala Lumpur
Status: Scheduled
Scheduled
Wed 16 Oct 24
Wed
16
Oct
Power BI Advanced
Kuala Lumpur
Status: Confirmed
Confirmed
Thu 14 Nov 24
Thu
14
Nov
Power BI Advanced
Kuala Lumpur
Status: Confirmed
Confirmed
Wed 11 Dec 24
Wed
11
Dec
Power BI Advanced
Kuala Lumpur
Status: Scheduled
Scheduled
Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Power BI DAX Course Details

Price
RM 1,790
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
Address
N/A
microsoft_gold
deloite_logo

Power BI Course Outlines

  • Power BI Beginner
    RM 1,190
  • Power BI Intermediate
    RM 1,790
  • Power BI Advanced
    RM 1,790
  • DA-100 Power BI Certification
Course Rating
Microsoft Power BI Training Courses

4.72 5 Microsoft Power BI Training Courses
4.72 out of 5
70672 Student Reviews

Skills Test

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

Skills Test

 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.

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

Contact Us

Why Nexacu? 

Valued by Individuals

4.72 / 5
Over 70672 Reviews

Trusted by Business

Awards and Accreditations

Follow us