Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

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

with 11 comments

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:


Written by Chris Webb

March 16, 2011 at 8:34 pm

Posted in Events

11 Responses

Subscribe to comments with RSS.

  1. Hi Chris,

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

    Diana Luz

    March 16, 2011 at 10:35 pm

  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?


    George Qiao

    March 16, 2011 at 11:53 pm

    • I might get round to doing an online course one day, but even if I did the time difference between London and Sydney would be a big problem!

      Chris Webb

      March 17, 2011 at 5:05 am

  3. […] renowned SSAS consultant and blogger Chris Webb will be running a two day MDX training course in London in May. If you want to learn MDX from a real expert, this is your […]

  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

    Edgar Walther

    May 2, 2011 at 2:47 pm

  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?

    Paul Harris

    May 11, 2011 at 9:08 am

  6. Hi Chris
    I’d love to attend a future SSAS and / or MDX course in London.


    June 22, 2011 at 5:47 pm

  7. […] on from my first, sold-out public MDX course earlier this year, I’ve now organised another run in London from October 26th to 28th. After […]

Leave a Reply

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

You are commenting using your 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


Get every new post delivered to your Inbox.

Join 4,001 other followers

%d bloggers like this: