Home > Business Intelligence > The Advanced MDX Course – Performance, Optimization, and the MDX Script

The Advanced MDX Course – Performance, Optimization, and the MDX Script

I have just completed writing SolidQ’s new 2-day Advanced MDX course.

There’s one module on Advanced Functions, which covers a whole variety of functions which are less commonly used – drilldown functions, statistical functions, etc.

There’s also a module on Advanced Sets, which covers the Generate function in detail as well as how to reference the hierarchies the user places on the axes.

I have two modules on using MDX scripting, with one of those modules covering date calculation hierarchies. This is one of my favorite topics. The ability to create date calculation hierarchies is a wonderful feature of Analysis Services cubes and most developers don’t come close to taking advantage of the possibilities it offers.

And finally I have 4 modules on MDX performance and optimization. One of those modules is on block computation. Another module covers subcubes and subselects. I wrote this Advanced MDX course using Analysis Services in SQL Server 2012. Almost all the information is relevant for SSAS 2008 and even SSAS 2005. But there are some performance surprises in SSAS2012 which haven’t been documented by Microsoft yet.

I am hoping to normally offer the new beginning SolidQ MDX course (MDX for Business Logic) together with the Advanced Course, so that students can come to either the 2-day Business Logic course by itself, the 2-day Advanced Course by itself, or attend all four days for a comprehensive understanding of MDX.

Here is the course outline for the Advanced Course.

Categories: Business Intelligence
  1. November 23, 2012 at 11:47 am

    Being a MSBI trainer, I really liked the course content. I have just got an Advanced MDX training requests but I myself was not aware what to teach there. This course content has given me an insight into it. Thanks a lot Tim!

  2. November 23, 2012 at 11:48 am

    I wish to attend your Advanced MDX session in future…

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: