SQL Server 2008 MDX Training: Introduction to SQL Server 2008 MDX

Course Number: SQL-230
Duration: 3 days
view class outline

Looking for SQL Server 2012 MDX training?

SQL Server 2008 MDX Training Overview

Accelebrate's SQL Server 2008 MDX training teaches attendees the core techniques for using MDX with Analysis Services to deliver high-performance business intelligence solutions.

Note: This course can also be taught using SQL Server 2008 R2.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=category&page=mssql.

SQL Server 2008 MDX Training Prerequisites

All SQL Server 2008 MDX training attendees should have prior experience with SQL Server 2008.

Hands-on/Lecture Ratio

This SQL Server 2008 MDX training class is 50% hands-on, 50% lecture, with the longest lecture segments lasting for 20 minutes.

SQL Server 2008 MDX Training Materials

All SQL Server 2008 MDX training students receive a copy of Microsoft Press's Microsoft SQL Server 2008 MDX Step by Step.

Software Needed on Each Student PC

SQL Server 2008, including Analysis Services.
The AdventureWorks 2008 database

Note: If you have purchased this course, please contact us for a detailed setup sheet.

SQL Server 2008 MDX Training Objectives

All attendees will learn to:

Construct and execute MDX queries
Work with tuples and sets
Build calculated members
Work with multiple functions in a single query
Build complex sets to retrieve the exact data users need
Perform aggregation functions and navigate data hierarchies
Assemble time-based business metrics

SQL Server 2008 MDX Training Outline

Welcome to MDX

The Business Intelligence Landscape
The Dimensional Model
Implementing the Dimensional Model
The MDX Language

Using the MDX Query Editor

SQL Server Management Studio
The MDX Query Editor
Building a Simple MDX Query
Exploring the Step-by-Step Cube
Building a More Complex Query

Understanding Tuples

N-dimensional Space
Cube Space
Accessing Data with Tuples
Understanding Cells
Working with Partial Tuples
Building Tuples with User-Hierarchies

Working with Sets

Set Basics
Understanding the SELECT Statement
Building Sets with Functions
Limiting Sets

Working with Expressions

Expression Basics
Calculated Members
Building Dynamic Expressions
Resolving Contextual Conflicts
Building Complex Expressions

Building Complex Sets

Assembling Ordered Sets
Retrieving the First or Last Tuples of a Set
Filtering Sets
Combining Sets
Performing Advanced Set Construction

Performing Aggregation

Performing Summation
Calculating Averages
Identifying Minimum and Maximum Values
Counting Tuples in Sets

Navigating Hierarchies

Accessing Immediate Relatives
Accessing Extended Relatives
Navigating within a Level

Working with Time

Understanding the Time Dimension
Calculating an Accumulating Total
Performing Period-over-Period Analysis
Combining Time-Based Metrics

Enhancing the Cube (Optional)

Understanding the MDX Script
Constructing Calculated Members
Assembling Named Sets

Building Reports (Optional)

Getting Started
Connecting to Analysis Services
Designing the Dataset
Adding Parameters to the Dataset
Presenting the Data in the Report

Conclusion

VB.NET, C#, ASP, & ASP.NET Training

Java Training

SQL Server Training
SharePoint Training

Adobe Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.