22nd March 2017 - 24th March 2017
Who is it for?
This three-day course is aimed at BI professionals, analysts and Excel users who want to learn the DAX language, as used by Power BI, Analysis Services Tabular and Power Pivot for Excel.
What you will learn
- DAX Basics
- Table Functions
- Evaluation Contexts and Relationships
- Time Intelligence Calculations
- DAX as a Query Language
- Calculations over Hierarchies
- Parent / Child Hierarchies
- Advanced Relationships and DAX functions
The course will include hands-on labs.
The goal of the course is to teach all the features of the DAX language, providing the knowledge to write formulas for common and advanced business scenarios. All the attendees will receive a copy of the book “The Definitive Guide to DAX”.
This course is run in association with SQLBI.Cost: £1490 until February 17 2017, £1790 after that +VAT
Alberto Ferrari is a Business Intelligence consultant. Alberto has helped several software houses to build complex BI solutions, from the OLTP system to the final OLAP cubes, providing planning hints throughout the development lifecycle. He is an author too, having worked on "Expert Cube Development with Microsoft SQL Server 2008" with Marco Russo and Chris Webb, and "Microsoft PowerPivot for Excel 2010: Give Your Data Meaning" and "The Definitive Guide To DAX" with Marco Russo.
Aldersgate House, 135-137 Aldersgate Street, EC1A 4JA
Cancellations must be submitted in writing, either via email or by post. Registrants whose cancellations are received at least 2 weeks before the beginning of the course are entitled to a full refund minus a £80 processing fee plus any credit card charges incurred. No refunds will be given to registrants who cancel less than 2 weeks before the beginning of the course or who fail to attend.
In the extraordinary case where the course is cancelled a full refund will be given to all paid registrants. Crossjoin Consulting will not refund any other amount paid by registrants to other companies, including travel expenses and hotel reservations.
Chris Webb's Introduction to MDX course was well-run, informative and good value. It gave me a good understanding of the key principles and ideas and how to apply them to real world situations. It was great environment to learn in, with Chris giving excellent practical exercises and having the depth of knowledge to answer to any group questions.