Publisher: Microsoft

Version: 2005/8
Length: 2 day s
Course-ID: SX684GRB

Course Overview

In this course you will learn how to create, manage and share online analytical processing (OLAP) cubes using a step by step development process.

Target student

Business analysts and users, developers and administrators.

Prerequisites

Previous exposure to any database system or spreadsheet data is assumed.


Analysis Services
  • Getting Started
Understanding Business Intelligence and Data Warehousing
  • Introducing Business Intelligence
  • Reviewing Data Warehousing Concepts
Understanding OLAP and Analysis Services
  • Understanding OLAP
  • Understanding Analysis Services
Building your first Cube
  • Exploring Business Intelligence Studio
  • Preparing to create a Cube
  • Generating a Schema
  • Processing and Browsing a Cube
Design Fundamentals
Designing Dimensions
  • The Data Warehouse structure
  • Building a Standard Dimension
  • Working with a Time Dimension
  • Creating a Parent-Child Dimension
Designing Measure Groups and Measures
  • Adding Measure Groups to a Cube
  • Aggregating Semi-Additive Measures
  • Calculating Distinct Counts
  • Simple Calculations
Working with a Finance Measure Group
  • Designing an Account Dimension
  • Designing Non-Additive Financial Measures
Designing Aggregations and Hierarchies
  • Aggregation Design
  • Designing User Hierarchies
  • Optimising Aggregations
Advanced Design
Using MDX
  • Creating Tuple-Based Calculated Members
  • Querying with MDX
  • Designing Custom Members
  • MDX Scripts
  • Key Performance Indicators
Special Features
  • Defining Dimension Relationships
  • Supporting Currency Conversions
  • Localising Cubes
  • Organising information with Folders and Perspectives
Interacting with Cubes
  • Implementing Actions
  • Using Writeback
Production Management
Implementing Security
  • Role based security
  • Applying security to a Dimension
  • Securing data at the Cell level
  • Setting Administration Security
Managing Partitions and Database Processing
  • Managing Very Large Databases
  • Working with Storage
  • Managing OLAP Processing
  • Monitoring Cube Activity
Managing Deployment
  • Deployment Options
  • Managing Database Objects programmatically
  • Automating Database Processing
  • Planning for Disaster and Recovery