Introduction to MDX–Training–London

if you are looking to work with Analysis Services then you need to learn MDX and there is no better person to learn it from than Chris Webb

Chris is a Microsoft MVP and a leading expert on MDX. He is the co-author of two books, "MDX Solutions" (second edition) and "Expert Cube Development with SQL Server Analysis Services 2008", and blogs about Microsoft BI topics at http://cwebbbi.wordpress.com/

Chris is doing an introduction to MDX course Wednesday, 26 October 2011 to Friday, 28 October 2011

To register for the Introduction to MDX course or get more details click here

 

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

Day 3

  • MDX Script Assignments: making scoped assignments, understanding how assignments affect aggregation, using assignments with calculated members
  • MDX for Reporting Services
  • Performance Tuning and Troubleshooting: using Profiler, building aggregations, functions to avoid

Cost £749 + VAT

Published 05 October 2011 18:24 by simonsabin

Comments

05 October 2011 19:34 by SimonS Blog on SQL Server Stuff

# Introduction to MDX–Training–London

if you are looking to work with Analysis Services then you need to learn MDX and there is no better person

14 October 2011 10:54 by MattcoG

# re: Introduction to MDX–Training–London

Definitely a course worth investing time and money in.