Introduction To MDX (Online)
Duration:
4 Days
Location:
Online
Training Course Sections
| Instructor |
Date/Time |
Cost |
Registration Link |
|
Dustin Ryan
|
09/23/13 - 09/26/13
9:00 AM - 12:00 PM EST
|
$995.00
|
Register Now!
|
Training Course Overview
During this 4-half day MDX virtual training course, you will learn how to use MDX for use with SSAS 2008 in your enterprise. This class starts 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 the class continues by explaining how to write MDX queries to retrieve data from an Analysis Services cube. This class also covers the following topics: common functions for creating sets and performing set-based operations, development of calculations that can be used as measures or as dimension member, addition of calculations and named sets to a cube for reusability, script assignments for complex calculations, MDX and cube security, and optimization techniques for queries.
IMPORTANT: When you purchase a seat in this class you also receive 2 hours of our BI Virtual Mentor service for assistance with YOUR project work. This remote service lets you work ONE on ONE with our BI mentors to accelerate YOUR project and further improve YOUR skills. Your Virtual Mentor hours can be used during business hours anytime during the 12 months following your class. To set up a session, download this simple questionaire, fill it out, and send it as an attachment to mentor@pragmaticworks.com. This unique Pragmatic Works offering insures that your training will translate into real world success for YOUR projects.
Training Course Prerequisites
The target of this class is developers, architects or IT professionals who have some experience with Analysis Services.
System Requirements
- Windows XP Professional, Windows Server 2003, Windows Vista, Windows Server 2008, Windows 7, Windows Server 2012, Windows 8 or Windows RT
- GHz CPU (recommended 2 GHz or faster)
- 1 GB of available RAM (recommended 4 GB or more)
- SQL Server 2008 Developer Edition, Standard Edition or Enterprise Edition with client tools, SSRS and SSAS
- Adventure Works DW 2008 database installed on an accessible instance of SQL Sever
- Adventure Works DW 2008 SQL Server Analysis Services Project
Terms & Conditions
Class Recordings
A class recording will be available via the web for a limited time for students who missed a session. Recordings are copyright protected and may not be distributed to others.
One Student Per Seat
We limit the number of students in each class to maintain a proper student to instructor ratio. Each purchased seat in a Virtual Training class is for use by one student only.
Cancellation/Rescheduling Policy
Students must provide at least 14 days’ notice to reschedule or withdraw from a class. In the case of withdrawal a credit will be issued for another Virtual Training class of similar value. Cancellation/reschedule with less than 14 days’ notice is subject to a fee of 100% of the total price.
We reserve the right to cancel or reschedule a class up to 2 weeks prior to the start date. Any students in a cancelled or rescheduled class have the option of a refund or credit to be used for another Virtual Training class of similar value.
Training Course Outline
Day 1 – Introduction to MDX
- Getting Started with MDX
- Comparing MDX with T-SQL
- Thinking about Multidimensional Space
- Exploring Options for Using MDX
- Building MDX Queries
- Understanding the MDX Query Editor
- Building Basic MDX Queries
- Adding Sets to a Query
- Hands-on Lab: Creating Simple Queries
Day 2 – Sets and Calculations
- Defining Sets
- Creating Sets with Functions
- Using Functions for Set Operations
- Working with Hierarchical Sets
- Hands-on Lab: Developing Queries based on Set Evaluation
- Adding Calculations to a Query
- Building Calculated Members
- Exploring MDX Functions
- Using Time Functions
- Hands-on Lab: Developing Queries with Calculations
Day 3 – Cube Enhancements
- Creating Calculations in a Cube
- Creating Calculated Measures and Custom Members
- Defining Named Sets
- Creating KPIs
- Hands-on Lab: Adding Calculations to a Cube
- MDX Scripting
- Introducing MDX Script Functions
- Adding Calculations to the MDX Script
- Debugging an MDX Scripts
- Hands-on Lab: Creating a Weighted Allocation Calculation
Day 4 – Advanced MDX
- Implementing Security with MDX Expressions
- Defining Dimension Security
- Configuring Cell-Level Security
- Implementing Dynamic Security
- Hands-on Lab: Defining Security
- Optimizing MDX Queries
- Using SQL Server Profiler to Analyze Queries
- Optimizing Queries for the Formula Engine
- Optimizing Queries for the Storage Engine
- Hands-on Lab: Tuning a Query