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:Manchester, London
Next course:Mon 06 January 2020
Time:09.30-16.30
Course Contents
The content 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
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?
No more than 6 people per class- Proper restaurant lunch included
- 503 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
John Pelan (Coloplast Ltd)
Alex Wallace (Manchester Metropolitan University)
Fraser Dear (Marley Ltd)
Edward Blankson (NEL CSU (NHS))
Glenn Turner (Ministry of Defence)
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 |
|---|---|---|---|---|
| Mon/Tue 06-07 January 2020 | 2 | Manchester | £795 | Book places |
| Tue/Wed 28-29 January 2020 | 2 | London | £950 | Book places |
| Thu/Fri 13-14 February 2020 | 2 | Manchester | £795 | Book places |
| Tue/Wed 10-11 March 2020 | 2 | London | £950 | Book places |
| Thu/Fri 26-27 March 2020 | 2 | Manchester | £795 | Book places |
| Tue/Wed 21-22 April 2020 | 2 | London | £950 | Book places |
| Thu/Fri 07-08 May 2020 | 2 | Manchester | £795 | Book places |
| Thu/Fri 11-12 June 2020 | 2 | Manchester | £795 | Book places |
| Tue/Wed 23-24 June 2020 | 2 | London | £950 | Book places |
| Tue/Wed 28-29 July 2020 | 2 | Manchester | £795 | Book places |
| Tue/Wed 25-26 August 2020 | 2 | London | £950 | Book places |
| Thu/Fri 03-04 September 2020 | 2 | Manchester | £795 | Book places |
| Tue/Wed 13-14 October 2020 | 2 | Manchester | £795 | Book places |
| Tue/Wed 03-04 November 2020 | 2 | London | £950 | Book places |
| Thu/Fri 26-27 November 2020 | 2 | Manchester | £795 | Book places |
| Tue/Wed 15-16 December 2020 | 2 | London | £950 | Book places |
| Date(s) | Venue |
|---|---|
| 06/01 | Manchester |
| 28/01 | London |
| 13/02 | Manchester |
| 10/03 | London |
| 26/03 | Manchester |
| 21/04 | London |
| 07/05 | Manchester |
| 11/06 | Manchester |
| 23/06 | London |
| 28/07 | Manchester |
| 25/08 | London |
| 03/09 | Manchester |
| 13/10 | Manchester |
| 03/11 | London |
| 26/11 | Manchester |
| 15/12 | London |
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).
