Power BI Training
DAX Training Course
£795 + VAT for most venues (£950 + VAT for London)
2 days
We have other courses which show how to create basic DAX measures as part of other applications, but this is the DAX course for hard-core programmers! Learn how to create calculated columns and measures using DAX, and how to write DAX queries to interrogate databases. On the way 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 course uses PowerPivot for editing measures, but the techniques learnt apply equally well to Power BI and Analysis Services (tabular model).
Course details
Locations:Manchester, London
Next course:Tue 18 September 2018
Time:09.30-16.30
Course Contents
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
Filtering
- The CALCULATE function
- Removing and replacing context
- The FILTER function
- VALUES: editing filter context
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
If time
Creating a periods table
- Creating the table and measures
- The HASONEVALUE function
Advanced date functions
- Multiple relationships
- Moving averages
Dynamic titles
- Showing filter choices
- The ISFILTERED function
If time
Dynamic security
- Creating a permissions table
- Dynamic roles
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
Why Choose Us?
No more than 6 people per class- Proper restaurant lunch included
- 533 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
Barry Stanworth (9Brand Foods Limited)
Mark McArdle (BAE Systems)
David Byrne (Department for Education)
Dan Hooper (The AA)
Sue McGrath (SuperBreak)
There are lots more where these came from (or just refresh this page to change the quotes shown).
You should be familiar with Excel pivot tables. This course also requires a high degree of numeracy!
Scheduled DAX training dates
Here are the DAX courses we have scheduled for the next 3 months:
| Dates | Days | Venue | Price | Booking |
|---|---|---|---|---|
| Tue/Wed 18-19 September 2018 | 2 | Manchester | £795 | Book places |
| Tue/Wed 16-17 October 2018 | 2 | London | £950 | Book places |
| Thu/Fri 25-26 October 2018 | 2 | London | £950 | Fully booked |
| Tue/Wed 20-21 November 2018 | 2 | Manchester | £795 | Book places |
| Date(s) | Venue |
|---|---|
| 18/09 | Manchester |
| 16/10 | London |
| 25/10 | London |
| 20/11 | Manchester |
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).
