Advanced DAX

13th May 2013 - 15th May 2013

Who is it for?

This workshop is aimed at experienced PowerPivot and SSAS 2012 Tabular developers who already have a basic knowledge of DAX, but wish to deepen their knowledge and improve their skills in performance optimisation and advanced modelling techniques that involve DAX.

What you will learn

DAX Introduction
Evaluation Contexts Recap
- Filter Context
- Row Context
- CALCULATE
Evaluation Contexts and Relationships
Querying Tabular
The Vertipaq Engine
Advanced DAX
- Understanding Cross filters
- Internal materialization – monitor memory usage
Time Intelligence in DAX
Data Modeling in Tabular
- DAX Patterns
- Leveraging Calculated Columns
Moving business logic from ETL to Tabularmodel
Analyzing DAX Execution plan
Optimizations and Monitoring

The course will include hands-on labs, including exercises on creating queries, solving business problems and locating performance bottlenecks in DAX.

Key Benefits

Attendees will learn advanced DAX techniques direct from the world's leading expert on the language. After the course, attendees will be able to write complex DAX expressions and be able to tune DAX calculations and queries effectively.

This course is run in association with SQLBI, and will be the only date for this course in Europe in the first half of 2013!

Cost: £Ł1390 until April 26 2013, Ł1650 after that +VAT

Trainer

Marco Russo is a Business Intelligence consultant and mentor. His main activities are related to data warehouse relational and multidimensional design, but he is also involved in the complete development lifecycle of a BI solution. He has particular competence and experience in sectors like financial services (including complex olap designs in banking area), manufacturing, gambling and commercial distribution. Marco is also a book author and, apart from his BI-related publications, he also wrote some books about .NET programming. He is also a speaker in international conferences like PASS Summit, SQLRally and SQLBits. He achieved the unique SSAS Maestro certification and is also a Microsoft Certified Trainer with several Microsoft Certified Professional certifications.

Location

LMG Training and Development
15 Risborough Street
Southwark
SE1 0HG

legal disclaimer

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. No refunds will be given to registrants who cancel less than 1 week before the beginning of the course or who fail to attend. Substitutions for paid registrants may be made at any time. However, written notice is required and for complete accuracy must include all pertinent changes for the substituting attendee.

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.

Calvin Ferns

Consultant, Adatis

Chris has an incredible ability to explain even the most complex logic of Analysis Services and MDX in an easy and funny way. He is one of the best Microsoft Business Intelligence trainers I've ever met.