Class Info

Online Course: Introduction to MDX

Get Full Access for Only $49.00  

Course Overview

In a partnership agreement with Pragmatic Works, SSWUG.ORG’s virtual class will provide you with the skills to use MDX with SQL Server Analysis Services in your enterprise.

Stacia Misner, course instructor and SQL Server MVP, will start by explaining the basic concepts related to multidimensional expressions and how they are used to enhance cubes with calculations, as well as to query cubes to retrieve data for reports. Then, she will continue by explaining how to write MDX queries to retrieve data from an Analysis Services cube.

Sessions

Session 1 – Getting Started with MDX –

  • What MDX is
  • Comparing MDX to T-SQL
  • Thinking about Multidimensional Space
  • Exploring Options for Using MDX

Session 02 – Building MDX Queries –

  • Understaning the MDX Query Editor
  • Building MDX Queries
  • Adding Sets to a Query

Session 03 – Defining Sets –

  • Creating Sets with Functions
  • Using Functions for Set Operations
  • Working with Hierarchial Sets

Session 04 – Adding Calculations to a Query –

  • Understanding Types of Calculations
  • Building Calculated Members
  • Exploring More MDX Functions

Session 05 – Creating Calculations in a Cube –

  • Creating Calculated Measures and Custom Members
  • Defining Named Sets
  • Creating KPIs

Session 06 – MDX Scripting –

  • Introducing the MDX Script
  • Adding Calculations to the MDX Script
  • Debugging a MDX Script

Session 07 – Implementing Security with MDX Expressions –

  • Configuring User Access
  • Defining Dimension Security
  • Configuring Cell-level Security
  • Implementing Dynamic Security

Session 08 – Optimizing MDX Queries –

  • Using SQL Server Profiler to Analyze Queries
  • Optimizing Queries for the Formula Engine
  • Optimizing Queries for the Storage Engine

 

Speaker


SMisner-pic1-webStacia Misner
is a Business Intelligence consultant, trainer, author and SQL Server MVP. She has authored or co-authored 10 books on business intelligence topics and has several articles p
ublished in SQL Server Magazine and TechNet Magazine.

Stacia has more than 12 years of experience in business intelligence and provides training on the complete Microsoft business intelligence stack. She is also a frequent speaker at PASS and SQL Connections, and has presented for SQL Server User Groups across the US, including her local user group (SSSOLV) in Las Vegas, NV.

 

Facebooktwittergoogle_plusredditpinterestlinkedinmail