Business Intelligence: A Data Analysis Foundation

• Introducing Business Intelligence
• Multidimensional Data Analysis
• Understanding a Dimensional Data Warehouse
• Multidimensional OLAP

Understanding OLAP and Analysis Services

• Understanding OLAP
• Understanding Analysis Services
• Analysis Services and the Microsoft Business Intelligence Platform
• Analysis Services Tools

Accessing Source Data

• Creating a Business Intelligence Solution
• Creating a Data Source
• Creating a Data Source View

Creating Dimensions

• Previewing Dimension Data
• Creating a Standard Dimension
• Creating a Time Dimension
• Creating a Parent-Child Dimension

Creating a Cube

• Previewing Cube Data
• Using the Wizard to Create a Cube
• Deploying and Browsing a Cube
• Using the Cube Designer to Modify a Cube

Creating Advanced Measures and Calculations

• Using Aggregate Functions
• Using MDX to Retrieve Values from a Cube
• Creating Calculated Members
• Calculation Scripting
• Creating KPIs

Advanced Dimension Design

• Dimension Usage
• Creating Reference Dimensions
• Creating a Fact Dimension
• Creating a Many-to-Many Dimension

Working with Account Intelligence

• Designing a Financial Analysis Cube
• Working with Account Intelligence
• Creating an Account Dimension

Currency Conversion and Multiple Languages

• Supporting Foreign Currency Conversion
• Supporting Foreign Language Translation

Interacting with a Cube

• Implementing Actions
• Using Writeback to Modify Analysis Services Data

MDX Fundamentals

• What is Business Intelligence?
• 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 with T-SQL

• Understanding the MDX Script
• Constructing Calculated Members
• Assembling Named Sets

Implementing Dynamic Security

• Understanding Dynamic Security
• Implementing Attribute-Hierarchy Restrictions
• Implementing Cell-Level Restrictions

Building Reports

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

Tuning Considerations

• Statement optimization
• Performance monitoring
• Tools for tuning

Implementing Security

• Understanding Roles
• Securing Administrative Access
• Securing Data Access

Designing Aggregations

• Understanding Aggregation Design
• Using the Aggregation Design Wizard
• Using the Usage-Based Optimization Wizard

Managing Partitions and Database Processing

• Working with Storage
• Managing Analysis Services Processing
• Working with Partitions

Managing Deployment

• Deployment Overview
• Deployment Mechanics
• Deployment Using Business Intelligence Development Studio
• Deployment Using the Deployment Wizard
• Understanding Deployment Scripts
• Migrating Databases and Disaster Recovery

Advanced Monitoring and Management Tools

• Monitoring Analysis Services Using Windows Reliability And Performance Monitor
• Monitoring Analysis Services Using SQL Server Profiler
• Analysis Services Dynamic Management Views

Advanced MDX Topics (as many as time allows)

• Iterating on a set using recursion
• Dissecting and debugging MDX queries
• Using NON_EMPTY_BEHAVIOR
• Optimizing MDX queries using the NonEmpty() function
• Implementing logical AND on members from the same hierarchy
• Combining two hierarchies into one
• Forecasting using the linear regression
• Forecasting using the periodic cycles
• Allocating the non-allocated company expenses to departments
• Calculating the number of days from the last sales to identify the slow-moving goods
• Analyzing fluctuation of customers
• Displaying members without children (leaves)
• Displaying members with data in parent-child hierarchies
• Implementing the Tally table utility dimension
• Displaying random values
• Displaying a random sample of hierarchy members
• Displaying a sample from a random hierarchy
• Performing complex sorts
• Using recursion to calculate cumulative values