Public MDX Course: London, 12th-13th May 2011

I’ve finally got round to organising a two-day public MDX course, to be held in the UK, in central London on the 12th and 13th of May. It’s the standard ‘Introduction to MDX’ course that I’ve been teaching for several years now as a private course (indeed I’ve given it five or six times already this year) and aims to take you from the point of being a complete beginner with no previous knowledge of MDX up to the point where you can write 90% of the MDX calculations and queries you’ll ever need to write.

Here’s the agenda:

Day 1

  • What is MDX and why should I use it?
  • Understanding the structure of a cube: recognizing cubes, measure groups, dimensions and hierarchies
  • Understanding the concepts of members, tuples and sets
  • Writing simple queries: using SQL Management studio to write SELECT statements
  • Creating simple calculated members: when to use query, session and cube-scoped calculations, using simple MDX expressions and functions

Day 2

  • Standard Calculations: looking at the best ways to implement common calculations, such as time series, market shares and rankings
  • Using set functions: using common MDX functions such as Crossjoin, Filter, Order, Generate to create more complex queries
  • Advanced concepts: autoexists, solve order and subselects
  • MDX Script Assignments: making scoped assignments, understanding how assignments affect aggregation, using assignments with calculated members

The cost is £499 plus VAT, including lunch and drinks/snacks. There will be some practical exercises but to do them you’ll need to bring your own laptop with SSAS and Adventure Works on – I’m not providing any PCs.

Here’s the link to register:

UPDATE I’m running the same course on October 26th-28th 2011 in London:

UPDATE #2 – I’m now running all my public MDX and SSAS training courses through my new company, Technitrain. Check out the website for more details:


11 responses

  1. Hi Chris,

    I wish you were nearest. I can’t travel to London… come to teach to Mexico some day please!!!

  2. Hi Chris,

    I wish one day you could come to Sydney to host a training session.

    Anyway, is remote via Skype is an option?


  3. Pingback: MDX Course from Chris Webb | Rich's Business Intelligence Blog

  4. Hello Chris,
    As I cannot find you contact details, I’ll do it this way… Is there still a place left for another trainee in your May 12-13 MDX class?
    Thanks, Edgar Walther

  5. Hi Chris,

    I am attending tomorrow. Just wanted to know what to have on my laptop. I currently has the AW2008 Enterprise cube and db’s. Is this correct?

  6. Pingback: Public MDX Course–London–October 26 to 28 2011 « Chris Webb's BI Blog

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: