Skip to main content
Get a Quote
Course Enquiry
Contact Us

Details

Both Microsoft (R) Power BI and Excel Power Pivots use DAX (Data Analysis eXpression Language) in order to analyze and transform data. To become a power user of either platform a functional knowledge of DAX is essential.

This course will build on your knowledge of either Power BI or Power Pivot creating more advanced formulas for your reports and dashboards.  In this course you will learn to:

  • Understand the structure of a DAX formula.
  • Use different types of DAX functions.
  • Understand the role of the Calendar table and use advanced time-intelligence functions.
  • Understand context in DAX both row and filter and the effect of relationships.
  • Use variables to improve the performance and readability of your formulas.
  • Use DAX to enforce Row Level Security on your reports in Power BI.

Base Cost

$383.00

Calculate Discount

  I will bring my own PC (less $33.00)
  I will book and pay 10 business days before the course (less $38.30)

Total

$
If you are currently resident in South Africa you will need to pay VAT at 15%.

Duration:

1 day

Brochure:

Download Brochure


Information may change without notice.

Delivery Method

Instructor Led classroom based training. Scheduled classes are normally held in Woodmead - near to Sandton in Johannesburg, Gauteng, South Africa. Stationary and textbook included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Contact hours are between 9am to 4pm.

Audience

This course is intended for people who have been working with:

  • Power BI,
  • Excel Power Pivot
  • SSAS Tabular

 

Pre-Requisites

Some knowledge of one of the following:

  • Power BI,
  • Excel Power Pivot
  • SSAS Tabular

 

One should at the very least have experimented with DAX in the past.

 

Course Outline / Curriculum

  • Introduction to DAX
    • Data types and operators
    • Types of DAX Functions
    • Measures, calculated columns and calculated tables
    • Variables in DAX
    • DAX functions
      • Logical functions
      • Information functions
      • Mathematical functions
      • Text functions
      • Date and time functions
      • Rational functions
      • Table functions
        • FILTER
        • COUNTROWS
        • ALL and ALL EXCEPT
        • VALUES and DISTINCT
        • TOPN
        • ADDCOLUMN
        • SUMMARIZE
      • Statistical functions
  • Understanding evaluation context
    • Row and filter context
    • EARLIER
    • CALCULATE and CALCULATETABLE
    • USERELATIONSHIP
  • Time Intelligence
    • Understanding time intelligence
    • Working with data tables
    • Year-to-date and month to date calculations
    • Same period as last year calculations
    • Moving averages
    • Working with semi additive measures in DAX

Schedule Dates and Booking

To apply for a booking, click on the relevant "Book Now" button below.
Note: places are only fully secured once payment has been made.

Start Date Branch Duration  
Fri 17 Jan 2020 Woodmead 1 day Book Now
Fri 14 Feb 2020 Woodmead 1 day Book Now
Fri 13 Mar 2020 Woodmead 1 day Book Now
Thu 9 Apr 2020 Woodmead 1 day
Thu 9 Apr 2020 Woodmead 1 day
Fri 15 May 2020 Woodmead 1 day
Fri 12 Jun 2020 Woodmead 1 day
Fri 17 Jul 2020 Woodmead 1 day
Fri 14 Aug 2020 Woodmead 1 day
Fri 11 Sep 2020 Woodmead 1 day
Fri 16 Oct 2020 Woodmead 1 day
Fri 13 Nov 2020 Woodmead 1 day
Fri 11 Dec 2020 Woodmead 1 day