Monday, March 12, 2012

MDX Training : Need review

Hi Gurus ...

Planning for a MDX Training for me and my development team ...
The following has been proposed for a training course spread over three days ...

I need to know whether this will be enough or should some more things be added on to the same (anything that has been missed)...

I have the option of removing and adding from the list.

Module 1: OLAP Review

OLAP Databases
OLAP Definitions
Warehouse Data Flow

Module 2: MDX Foundations

The Role of MDX
MDX Member Names
Using the Calculated Member Builder
Working with Calculated Members

Module 3: Using MDX Expressions

Displaying Member Information
Displaying Family Tree Relatives
Working with Member Properties
Using Conditional Expressions

Module 4: Retrieving Values from a Cube

Understanding Multidimensional Coordinates
Retrieving a Value from a Cube
Percent of Total Calculations
Growth Calculations

Module 5: Creating Simple MDX Queries

Understanding MDX Query Statements
Creating Simple MDX Query Statements

Module 6: Creating and Manipulating Sets

Using Set Creation Functions
Using Set Manipulation Functions
Using Subquery Set Functions
Working with Dimension Interactions

Module 7: Using Aggregation Functions

Understanding Aggregation Functions
Using Time Set Functions
Calculating a Trend

Module 8: Case Study - Implementing Budget Allocations

Allocating Values from a Grand Total
Allocating Values from a Subtotal
Allocating Values Across Multiple Dimensions

Module 9: Using Calculated Cells

Respose needed urgently since I have to get back to the training team by tomorrow morningWhat is MDX?|||he he .. nice joke|||Originally posted by Enigma
he he .. nice joke

I'm serious...

This?

http://www.mdxsoftware.com/|||You are serious ... :confused:

Worked on OLAP ... Analysis Server ?

MDX = Multi - Dimensional Expressions

MDX is query language used for querying OLAP Cubes|||Sorry...no warehouse tools...

Had to build them manually...

No magic....

What do you think you can do with analysis services that you can't do manually?

My Multi Billion $$ Company only bought standard edition...

I did find 1 box with Enterprise though...|||Hmm ...

It seems you havent used OLAP Cubes yet ...

I agree it can be done manually too ... but you too would love the power of analysis a Cube gives you (just like a pivot table in excel) ...|||Any way I can sneak into the back of the class? I don't think Microsoft has developed a course for MDX, as yet. Probably because they know their MDX implementation has a few kinks to work out...|||MS does have a course for mdx and it has been out for about 3 or 4 years.
you will find an outline at this link.
Course 2093: Implementing Business Logic with MDX in Microsoft SQL Server 2000 (http://www.microsoft.com/traincert/syllabi/2093AFinal.asp)

it is MOC (Microsoft Official Curriculum)
i have taught it a few times and it is pretty good.

it appears that someone is going to be using the same exact outline

No comments:

Post a Comment