Module 1: The Microsoft Business Intelligence Stack

• What Business Intelligence can do for your organization
• What to watch out for in implementation
• The Scope and what types of tools address each?
• Lab: The Microsoft Business Intelligence Stack

Module 2: Getting Started with MDX. We walk then run. Learn this and you won’t trip.

• MultiDimensional VS Tabular Space
• Data Warehouse Data Mart
• MDX Introduction
• The Editors
• Lab: Getting Started with MDX. We walk then run. Learn this and you won’t trip.

Module 3: The all-important Dimensions. The bearers of truth.

• Dimensions
• Dimension Attributes
• Hierarchies
• Referencing Members
• Tuples
• Cells
• Sets
• Set Functions
• Lab: The all-important Dimensions. The bearers of truth.

Module 4: Navigation and the secrets of relatives!

• Navigation in reporting
• Relatives
• Navigational Functions
• Controlling Sorting
• Filtering the results
• How to combine a set
• Lab: Navigation and the secrets of relatives!

Module 5: MDX Calculations.

• Expressions
• Calculated members
• Formatting output through the With clause
• Dynamic Expressions
• IIF function
• Statistical Functions
• Determining which tuples satisfy a parameter in a report
• Lab: MDX Calculations.

Module 6: Working with Time. Multiple calendars, divergent horizons.

• 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
• Lab: Working with Time. Multiple calendars, divergent horizons.

Module 7: Business Insights. Now let’s put it to work and get some situational answers.

• 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
• Lab: Business Insights. Now let’s put it to work and get some situational answers.

Module 8: Where else will MDX work? SQL Reports

• 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)
• Lab: Where else will MDX work? SQL Reports

Module 9: KPIs and MDX in the Business Intelligence Development Studio Editor

• Use Business Intelligence Development Studio to create a named calculation in the cube
• Use Business Intelligence Development Studio to create KPIs
• Lab: PerformancePoint Services