SSAS Training

INTRODUCTION TO SSAS

Introduction to SSAS

Understand the Cube Structure

Deploy and View a Sample Cube

View a Cube by using Excel

View a Cube by using SQL Reporting Services

OLAP MODELLING

Understand Basic OLAP Modeling(star schema)

Understand Dimensional Modeling (stars and snowflakes)

Understand Measure (Fact) and Cube Modeling

Model with SQL Server Business Intelligence

Development Studio (BIDS)

USING SSAS IN BIDS

Understand the Development Environment

Create Data Source

Create Data Source Views

Create Cubes by using the Cube Wizard

INTERMEDIATE SSAS

Learn how to Create Key Performance Indicators(KPIs)

Discover how to Create Perspectives

See how to Create Translations for Cubes and Dimensions

Review the three SSAS Action Object Types: Regular, Drillthrough, and Reporting

INTRODUCTION TO DATA MINING

Understand Data Mining Concepts

Review the Algorithms that SSAS Includes

Consider Data Mining Clients

Understand Mining Structure Processing

ADVANCED SSAS

Work with Multiple Fact Tables and the Dimension usage Subtab in BIDS

Explore Advanced Dimension Types

Learn how to use the Business Intelligence Wizard

Understand Writeback in Dimensions

Review Semi-Additive Measures in OLAP Cubes

CUBE STORAGE AND AGGREGATION

View Aggregation Designs

Customize Aggregation Designs

Implement Proactive Caching

Use Relational and SSAS Partitions

Customize Cube and Dimension Processing

INTRODUCTION TO MDX QUERIES

Understand Basic MDX Syntax

Use the MDX Query Editor in SSMS

Understand Common MDX Functions and Tasks

Review MDX Functions New to SSAS 2008

MDX EXPRESSIONS

Understand the Calculation Subtab

Learn how to add Calculated Members

Explore how to add MDX Script Commands

Discover how to add .NET Assemblies