Microsoft Office training -  DAX

Power BI Training

DAX Training Course

£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, parent-child hierarchies and 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 coursesLocations:Manchester, London
  • Next DAX course locationNext course:Tue 28 January 2020
  • DAX course timesTime:09.30-16.30

Course Contents

The content of this course are as follows:

Ways to edit DAX

  • Training topicPower BI
  • Training topicPowerPivot
  • Training topicSSAS Tabular
  • Training topicDAX Studio

Data model basics

  • Training topicLinking to data
  • Training topicCreating a data model

Calculated columns

  • Training topicCreating calculated columns
  • Training topicIF and SWITCH
  • Training topicShowing RELATED data
  • Training topicDealing with blanks

Basic measures

  • Training topicCreating measures
  • Training topicUnderstanding filter context
  • Training topicUsing a measures table
  • Training topicAggregateX functions

The CALCULATE function

  • Training topicFilter context revisited
  • Training topicRemoving and replacing context
  • Training topicContext transition

The VALUES function

  • Training topicThe HASONEVALUE function
  • Training topicListing single values
  • Training topicParameter tables

Dynamic measures

  • Training topicThe ISFILTERED function
  • Training topicThe ALLSELECTED FUNCTION
  • Training topicDynamic titles

The FILTER function

  • Training topicRow context
  • Training topicIterator functions
  • Training topicApplying criteria

Understanding EARLIER

  • Training topicHow it works
  • Training topicBanding using EARLIER
  • Training topicRanking using EARLIER

Variables

  • Training topicCreating variables
  • Training topicUsing for debugging

Calendars and dates

  • Training topicCreating a calendar
  • Training topicDate-based functions

Advanced date functions

  • Training topicMultiple relationships
  • Training topicMoving averages

Covered if time allows If time

Parent-child hierarchies

  • Training topicThe PATH functions
  • Training topicDisplaying different levels
  • Training topicMaking the results neater

DAX queries

  • Training topicEvaulating data
  • Training topicSummarising data
  • Training topicFiltering data
  • Training topicAdding 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?

View full list of benefits View full list of benefits

Sample customer feedback

"(Intro Power BI) Excellent pace for 2 days. Plenty of interaction and humour. Great lunch breaks. (DAX) 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) Excellent delivery of a new course. Quick measures were very useful after the DAX course (a good compliment.)"

John Pelan (Coloplast Ltd)

"Fantastic courses with an engaging trainer. Content and pace was perfect."

Andrew Witt (Coloplast Ltd)

"Manual is amazing. The trainer was really helpful, explained each topic thoroughly and went above and beyond to show extra steps. Definitely one of the best courses I have been on."

Sehrish Aslam (Trident Building Consultancy)

"Great content. Great trainer. Thoroughly enjoyed how trainer engaged with us. Exercises helped cement course knowledge."

Hazem Hawwash (RPC Group plc)

"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 DAX courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Tue/Wed 28-29 January 2020 2 £950 Book places
Tue/Wed 11-12 February 2020 2 £795 Book places
Tue/Wed 10-11 March 2020 2 £950 Book places
Thu/Fri 26-27 March 2020 2 £795 Book places
Tue/Wed 21-22 April 2020 2 £950 Book places
Thu/Fri 07-08 May 2020 2 £795 Book places
Thu/Fri 11-12 June 2020 2 £795 Book places
Tue/Wed 23-24 June 2020 2 £950 Book places
Tue/Wed 28-29 July 2020 2 £795 Book places
Tue/Wed 25-26 August 2020 2 £950 Book places
Thu/Fri 03-04 September 2020 2 £795 Book places
Tue/Wed 13-14 October 2020 2 £795 Book places
Tue/Wed 03-04 November 2020 2 £950 Book places
Thu/Fri 26-27 November 2020 2 £795 Book places
Tue/Wed 15-16 December 2020 2 £950 Book places
Date(s) Venue
28/01
11/02
10/03
26/03
21/04
07/05
11/06
23/06
28/07
25/08
03/09
13/10
03/11
26/11
15/12

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 Tools training resources

Power BI exercises

Power BI exercises

View Power BI Desktop 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