Introduction To MDX - October 2011

London

Wednesday, 26 October 2011

Introduction To MDX - October 2011

Wednesday, 26 October 2011 09:30 - Friday, 28 October 2011 17:00 (GMT)

Progressive Training Centre
15-19 Risborough Street
Southwark
London
SE1 0HG
United Kingdom
020 313 73958

Tel: 07976877845 Email Us

Sorry, the event you wish to register for is currently full.

Start Your Registration

Email Address:
Verify Email Address:
Enter a discount code:
You can also register a group. Learn More

You will have the opportunity to add additional group members later in the registration process. If there are fees associated with this event, the total fees for all registrants in the group will be charged to the first person in the group. If members of the group are paying individually (for example, with different credit cards), please create separate registrations for each.
Group discounts are available.

When 3 or more people register, a discount of 20% off is applied to all registrants on all items.

Instructor
This course will be taught by Chris Webb of Crossjoin Consulting (http://www.crossjoin.co.uk/). 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/

Course 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

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