Thank you to our sponsors:


  

www.microsoft.com

 

Intro to MDX

 


Presenter: Stacia Misner, Data Inspirations

 

Session 07: September 15 at 18:00 GMT

 

Session Details

“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!

 

Copyright 2013 by PASS | Terms of Use | Privacy | Login