MDX with Microsoft Analysis Services: How to ask questions and get accurate answers from your Data

What to watch out for in implementation

The Scope and what types of tools address each?

Examine and run a prebuilt SQL Integration Services Package that performs an Extract Transform and Load into a Data mart.

This is the Hello World experience in MDX. This is where you will learn why you can get an answer without really asking a question. And this is where you say goodbye to SQL habits.

What you will get out of this module:

* The difference between multidimensional and flat or tabular space

* The importance of schemas in SQL Server Analysis Services

* Basic syntax of MDX

MultiDimensional VS Tabular Space

Data Warehouse Data Mart

MDX Introduction

The Editors

Familiarization with the SQL Server Management Studio Query Editor

Familiarization with the Business Intelligence Development Studio Query Editor

SQL Profiler

Basic MDX

What you will get out of this module:

* Working knowledge of Dimensions

* The ability to explain what a tuple does

* Why SSAS cells are important and their properties

* How to construct a MDX Set

* Utilize built in Set Functions

Dimensions

Dimension Attributes

Hierarchies

Referencing Members

Tuples

Cells

Sets

Set Functions

Dimension Properties

Dimension Attributes

Single Dimension Hierarchies

Multidimensional Hierarchies

The All Member

The Members function

Referencing Members

Syntax errors

Partial Tuple references

Multiple Axis

Crossjoin

Auto-Exists

Exists

Removing Duplicate Tuples

What you will get out of this module:

* Importance of Navigation to reporting

* How to locate a cells relatives

* How to use Navigational Functions in reporting

* Controlling Sorting of reports

* Filtering the results of a report

* How to combine a sets

Navigation in reporting

Relatives

Navigational Functions

Controlling Sorting

Filtering the results

How to combine a set

Navigating a Hierarchy

Locating Immediate relatives

Using the members function effectively

Hierarchize Function

What you will get out of this module:

* How to utilize expressions

* How to use MDX functions in Calculations

* Variances through the With clause

* How to use sets in expressions

* How to work with statistical functions

Expressions

Calculated members

Formatting output through the With clause

Dynamic Expressions

IIF function

Statistical Functions

Determining which tuples satisfy a parameter in a report

Explore variations of the With Clause

Create Members

Calculate Percentages

Advanced Formatting

What you will get out of this module:

* Understanding of time in SSAS

* How to perform time based calculations

* Navigating Time Dimensions

* How to use a calculated measure in a time Dimension

* How to Sum and Aggregate data over time

Time Dimension

Multiple calendars

Time based Functions

ParallelPeriod

OpeningPeriod

ClosingPeriod

LastPeriod

Year-To-Date

Calculated Measures and a time Dimension

Comparing Periods

Sum Function

Aggregate Function

Max and Min Function in Time

ParallelPeriod

OpeningPeriod

ClosingPeriod

LastPeriod

Year-To-Date

Calculated Measures and a time Dimension

Comparing Periods

Sum Function

Aggregate Function

Max

Min

Use Crossjoin and ParallelPeriod

What you will get out of this module:

* This module combines techniques from the other modules and expands where necessary.

* You should develop an understanding of how to approach and solve MDX problems.

Or logic

And Logic

Combining Or and And logic from different hierarchies

Logical And with members from the Same

Using the NonEmpty function

Moving Averages

Last date with data

ParallelPeriod for Multiple Dates

Testing current context

Options of the Descendants function

Ranking Values

What you will get out of this module:

* How to use MDX in a SQL Server Reporting Services Report

* MDX in PerformancePoint Services 2010

Create a SSRS report

Create a connection into the cube

Create a MDX query with the query designer

Create a custom query

Pass a parameter

PerformancePoint Services Dashboard Designer (Not installed PowerPoint and Video demonstration)

Create a SSRS report

Create a connection into the cube

Create a MDX query with the query designer

Create a custom query

Pass a parameter

What you will get out of this module:

* How to use MDX in a Business Intelligence Development Studio Editor

* MDX in Calculations in Form view

* How to create KPIs

Use Business Intelligence Development Studio to create a named calculation in the cube

Use Business Intelligence Development Studio to create KPIs

Create a named calculation

Create a Leaf KPI

Create an Objective KPI

Utilize IIF logic in a KPI