Introduction to MDX - Chris Webb
Location: BT Training Centre, Dublin 1
Dates: April 29th & 30th 2010
Cost: €1,299
This level 300 course is targeted at BI Developers who have at least three months experience of working with SQL Server Analysis Services. The course assumes no previous knowledge of MDX. Attendees will learn how to implement many common types of calculations and queries.
Register Now
Over the course of two intense days, Analysis Services guru, Chris Webb will work with participants in a hands-on class-room set up. Places on the course are limited to only 20 delegates to ensure you derive the maximum benefit from the course. The agenda for the course is as outlined below.
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
Register Now