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
- Evaluation Contexts and Relationships
- Querying Tabular
- The Vertipaq Engine
- 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.
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
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.
LocationLMG Training and Development
15 Risborough Street
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.