WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
Wise Owl Training
See 479 reviews for our classroom and online training

# DAX Training Courses

Learn to program in DAX on a Wise Owl online or classroom training course, with at most 5 people per class (DAX is the formula language embedded within Power BI Desktop).

## DAX classroom training

We run a course devoted to DAX, and also teach it as part of our Power BI and SSAS Tabular courses:

See details of our classroom training, or why not organise your own onsite DAX course?

## Online DAX training

You can also learn how to program in DAX online with Wise Owl:

Or see how our online courses work (probably better than you think!).

## Which is the right DAX course for you?

Before considering which is the right DAX course, perhaps it's worth stepping back and explaining what DAX is!

The short answer to that it stands for Data Analysis eXpressions (sort of), and allows you to create formulae in PowerPivot, Power BI Desktop and Analysis Services (Tabular Model).

Suppose you have a pivot table showing sales by quarter and region.  You want to show total sales as a multiple of sales for the London region.  To do this you might create the following measure:

=SUM([Quantity]) /

CALCULATE(

SUM([Quantity]),

tblRegion[RegionName]="London"

)

For each data point in a pivot table, matrix or chart, this will calculate the ratio between two values:

Value What is calculated
Numerator Total sales for the current combination of row and column values, together with any other constraints.
Denominator Total sales for the same combination of constraints, but for the London region.

For those who can't remember their GCSE maths (fourth grade?), in a ratio A/B the numerator is the thing you're dividing (A) and the denominator is the thing you're dividing by (B).  The language in which this formula is written is called DAX - to begin with it looks like the Excel formula language, but you'll soon find out that it's quite different!

## Courses including DAX

Wise Owl run the following courses which include DAX (presented here in order of how much is covered):

Course DAX coverage
DAX A thorough look at DAX, including understanding some of the more complicated functions like VALUES and EARLIER.
Fast-track DAX and Power BI Combining our Introduction to Power BI and Introduction to DAX courses in three intensive days.
Analysis Services (Tabular) Calculated columns and basic to intermediate measures, including date-based formulae.
PowerPivot for Excel Calculated columns and measures (the level will depend on the delegates on the course)

For even more help on what you can hope to learn on one of our DAX courses, see this DAX help page.

## 10 things our DAX courses include

Each of our scheduled courses (whether classroom or online) includes:

1. Small course sizes - we have a maximum of 6 people on each classroom or online course.
2. A trainer! And not just anyone - our courses are only ever given by full-time Wise Owls.
3. Full colour courseware and exercises of oustanding quality.
4. A no cancellation guarantee (once you've booked and confirmed your training course, it will run).
5. A one gigabyte USB stick, containing course files, answers to exercises and (by the end of the course) your answers too, together with a nice pen.
6. Unofficial help after the course (although we don't have a dedicated post-course support line, in practice trainers will be happy to answer the odd ad hoc question after a course has taken place).
7. A certificate sent out digitally or in paper form (your choice) after each course, together with (for tailored courses) the trainer's thoughts on how the course went.

In addition, our classroom courses also include:

1. A computer for each delegate (obviously).
2. Lunch out each day at a local restaurant (chosen on the day of the course, after discussion!).
3. Unlimited refreshments during the day, including Tassimo or Nespresso coffee and a range of biscuits and snacks to keep you going through those dark afternoon hours.

Still not convinced? You can read hundreds of testimonials to the quality of our training (all attributed and added in the last 3 years.

There will be at most 5 delegates on any of our scheduled DAX courses, and each personally (naturally) will have his or her own computer to use (we can also do onsite DAX training, although we will never train more than 8 people at a time).

## Other DAX training resources

There are many ways in which we can help you learn DAX, as the list below shows.

## Blogs on DAX

We've published a full online tutorial on SSAS Tabular, as well as blogs on DAX within PowerPivot and Power BI Desktop.

## DAX training venues

We teach DAX onsite anywhere in the UK, and also at our Wise Owl training centres.

## Videos on DAX

Our online training videos include tutorials on creating calculated columns and measures using DAX.