Intro to MDX
Presenter: Stacia Misner, Data Inspirations
Session 07: September 15 at 18:00 GMT
“Everyone” says MDX is hard—so what’s the point of learning it? Quite simply, some answers are easier to get from your data by using multidimensional queries instead of relational queries. Sure, it’s possible to write pages of T-SQL code to do things like period-over-period analysis, cumulative results such as month-to-date and year-to-date comparisons, or trending calculations for Key Performance Indicators. But in this session, you’ll learn how much easier you can perform these calculations by using MDX (after you put your data into a cube, of course!), not to mention how much faster MDX queries execute compared to their relational counterparts.
To help you get started with MDX, I’ll explain how to think about multidimensional space, how to create basic queries, which functions to learn first, and how to construct simple, but useful, calculations. In my PASS Summit 2010 session, “Demystifying MDX in Reporting Services,” I’ll then show you how to apply these concepts to queries in Reporting Services and how to adapt queries that return multidimensional results to the two-dimensional dataset structure required by Reporting Services.
About the Speaker
Stacia Misner is a consultant, educator, mentor, and author specializing in Business Intelligence solutions since 1999. With more than 25 years of experience in IT, she is the author or co-author of eight books about BI. Her most recent books include Microsoft SQL Server 2008 Reporting Services Step by Step and Introducing SQL Server 2008 R2. Stacia provides consulting and custom education services through Data Inspirations, writes about her experiences with BI at blog.datainspirations.com, and tweets as @StaciaMisner.
Register now for 24 Hours of PASS!