WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 482 reviews for our classroom and online training
Classroom training -  DAX

Classroom Training

DAX

Classroom training course - online version also available

£950 + VAT for most venues (£1,095 + 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!

Course details

  • Locations for DAX coursesPossible locations:London, Manchester, Online
  • Next DAX course locationNext classroom course:Mon 27 June 2022
  • DAX course timesTime:09:30-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

Covered if time allows If time

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

  • Evaluating 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).

"As this (DAX) was a very difficult subject to teach, I found the training to be ideally suited. I certainly benefited from it being one to one and face to face allowing it to run at my own pace. The files and documents will be hugely valuable for future reference too. After meeting one of the trainers at a conference, Wise Owl is the first place I looked to be fair. I wasn't aware of any other training providers that were so well specialised in Power BI / Power Platform courses. The content was clearly stated on the website too and covered all the points, in which I felt I needed proper training."

Matthew Collinge (Dugdale Nutrition)

"I was a bit wary at first of doing this course online, but it was fantastic. Very well planned before the course date, a Wise Owl team member called via teams to make sure we were set up for online training, the excellent training material arrived in plenty of time (just like to add the best training material I've seen for Dax), on the day it was easy to connect to remote desktops for the practical work, and the trainer was able to see all of our screens and see what we were doing and could advise accordingly. We had a fantastic trainer and thoroughly enjoyed the 2 day Dax course, he is very funny and extremely knowledgeable and was able to explain some of the complexities of Dax in a very simple way. Online training also had the benefit of us having time to discuss our working power BI issues. Greatly recommend this course for anyone wanting to learn more about DAX. I was struggling a bit with DAX and had so far learnt what I knew from Google, so it was time to find a Dax course. My manager found this one and we both attended online together, and so glad we chose Wise Owl (as we went to another firm for our Power BI beginners course) and it was no way near the standard of Wise Owl."

Geeta Hirani (Montagu Private Equity LLP)

"The training provided was excellent and exceeded my expectations. The pace and content of the training was ideal and has given me many new ideas to enhance what my team does that will improve the experience of our Power BI users. The approach and style of the trainer was also excellent and certainly contributed to the training. Have used WiseOwl in the past and have always found the training to be excellent."

Paul Horwood (BUPA)

"I really liked the approachability and friendliness in the communication coming up to the course. During the course the instructor quickly adjusted to the pace I was able to go at and so we had a chance to cover a lot of content with good understanding. I really feel like I not only learnt some DAX formulas but also understood the underlying context and the way the DAX language operates. The course was very insightful, demanding but fun as well. I'd recommend it to anyone. I really appreciated the ability to run the course face to face amid all other restrictions and other schools cancelling their courses. The course content was very relevant to what I needed and the course itself didn't disappoint at all."

Justyna Wolczyk (Atos)

"Thoroughly enjoyed the course. Our trainer, was lovely. He kept a really good pace and was very approachable and friendly (hard to get this across over Teams sometimes as well!). The content was brilliant, and left with some great ideas for how what we learnt could be used in our job. Already had completed some training with Wise Owl in the past, which was equally brilliant."

Ellie Richardson (BUPA)

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
Mon/Tue 27-28 June 2022 2 £950 Book places
Wed/Thu 20-21 July 2022 2 £950 Book places
Date(s) Venue
27/06
20/07

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

Advanced Power BI Reports

Advanced

2 day course

Advanced Power BI Data

Advanced

2 day course

Other Power BI training resources

Power BI exercises

Power BI exercises

View Power BI Desktop or DAX exercises

Power BI videos

Power BI videos

View Power BI or DAX for 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, Power Apps or Power Automate blogs

This page has 0 threads Add post