Classroom training course - online version also available
£795 + VAT for most venues (£950 + VAT for London)
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, and is complementary to our two-day Advanced Power BI course (there is virtually no overlap between the two).
The contents of this course are as follows:
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.
Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).
Jack Huntington (The Keyholding Company)
Glenn Turner (Ministry of Defence)
Alex Wallace (Manchester Metropolitan University)
Sehrish Aslam (Trident Building Consultancy)
Edward Blankson (NHS NEL CSU)
There are lots more where these came from (or just refresh this page to change the quotes shown).
Here are the classroom DAX courses we have scheduled for the next 3 months:
|Thu/Fri 20-21 August 2020||2||Manchester||£795||Book places|
|Thu/Fri 03-04 September 2020||2||Manchester||£795||Book places|
|Thu/Fri 08-09 October 2020||2||London||£950||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|
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).