This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Find out more here                     
decoration
decoration
decoration

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
decoration

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.

decoration

Location

LMG Training and Development
15 Risborough Street
Southwark
SE1 0HG
decoration

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 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.

decoration
decoration decoration decoration decoration
decoration
decoration