COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
Classroom training -  DAX

Classroom Training

DAX

Classroom training course - online version also available

£795 + VAT for most venues (£950 + VAT for London)

2 days

This course will teach you how to create calculated columns and measures using DAX, including how to understand complicated DAX functions like CALCULATE, VALUES and EARLIER.  The course also covers writing DAX queries to interrogate databases. 

During the course you'll pick up lots of clever techniques for building data models, including ways to model multiple calendars, cope with different financial year-ends and apply dynamic security. 

The training uses Power BI Desktop for editing measures, but is just as useful if you're using PowerPivot or SQL Server Analysis Services (tabular model).  This course is definitely more difficult than our two-day Introduction to Power BI course, and is complementary to our two-day Advanced Power BI course (there is virtually no overlap between the two).

Course details

  • Locations for DAX coursesPossible locations:London, Manchester, Online
  • Next DAX course locationNext classroom course:Thu 03 December 2020
  • DAX course timesTime:10.00-16.30

Course Contents

The contents of this course are as follows:

Ways to edit DAX

  • Power BI
  • PowerPivot
  • SSAS Tabular
  • DAX Studio

Data model basics

  • Linking to data
  • Creating a data model

Calculated columns

  • Creating calculated columns
  • IF and SWITCH
  • Showing RELATED data
  • Dealing with blanks

Basic measures

  • Creating measures
  • Understanding filter context
  • Using a measures table
  • AggregateX functions

The CALCULATE function

  • Filter context revisited
  • Removing and replacing context
  • Context transition

The VALUES function

  • The HASONEVALUE function
  • Listing single values
  • Parameter tables

Dynamic measures

  • The ISFILTERED function
  • The ALLSELECTED FUNCTION
  • Dynamic titles

The FILTER function

  • Row context
  • Iterator functions
  • Applying criteria

Understanding EARLIER

  • How it works
  • Banding using EARLIER
  • Ranking using EARLIER

Variables

  • Creating variables
  • Using for debugging

Calendars and dates

  • Creating a calendar
  • Date-based functions

Advanced date functions

  • Multiple relationships
  • Moving averages

Covered if time allows If time

Parent-child hierarchies

  • The PATH functions
  • Displaying different levels
  • Making the results neater

DAX queries

  • Evaulating data
  • Summarising data
  • Filtering data
  • Adding columns

You should be familiar with Excel pivot tables.  This course also requires a high degree of numeracy!  You can get an idea of what the course is like by having a look at our series of articles on DAX on the excellent Simple Talk website.

Why Choose Us?

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"The trainer was very helpful."

Kevin Whipps (NHS NEL CSU)

"(Intro Power BI course) Excellent pace for 2 days. Plenty of interaction and humour. Great lunch breaks. (DAX course) Excellent course. Very well delivered on a "tricky" topic which could have sent me slightly mad. Great pace of delivery. This is the first time I felt I could do the same course again! (Advanced Power BI course) Excellent delivery of a new course. Quick measures were very useful after the DAX course (a good compliment)."

John Pelan (Coloplast Ltd)

"Excellent course! Beginner to user straight in 2 days. Really enjoyed."

Fraser Dear (Marley Ltd)

"Very useful well delivered course. The recommendation came from colleagues."

Danielle Ryan (Ministry of Housing, Communities and Local Government)

"Really good pace and coverage of topics. Very happy, thank you."

Marie Woltman (Devon County Council)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Scheduled DAX training dates

Here are the classroom DAX courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Thu/Fri 03-04 December 2020 2 £795 Book places
Tue/Wed 12-13 January 2021 2 £950 Book places
Tue/Wed 02-03 February 2021 2 £795 Book places
Thu/Fri 04-05 March 2021 2 £950 Book places
Tue/Wed 13-14 April 2021 2 £795 Book places
Thu/Fri 13-14 May 2021 2 £950 Book places
Tue/Wed 25-26 May 2021 2 £795 Book places
Thu/Fri 01-02 July 2021 2 £795 Book places
Tue/Wed 20-21 July 2021 2 £950 Book places
Tue/Wed 17-18 August 2021 2 £795 Book places
Date(s) Venue
03/12
12/01
02/02
04/03
13/04
13/05
25/05
01/07
20/07
17/08

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite Power BI training at your offices (we'll even provide and set up the computers).

Related Courses

Introduction to Power BI

Introduction

2 day course

PowerPivot / Excel Power BI

Introduction

2 day course

Advanced Power BI

Intermediate

2 day course

Other Power BI training resources

Power BI exercises

Power BI exercises

View Power BI Desktop, DAX or Power Apps exercises

Power BI videos

Power BI videos

View Power BI videos

Power BI skills assessment

Power BI skills assessment

View Power BI skills skills assessment tests

Power BI blogs

Power BI blogs

View Power BI blogs

This page has 0 threads Add post