Sql Server Analysis Services Course

by Vibrant Technologies & Computers

Module

Title

Contents

Module 1:

Defining a Data Source View within an Analysis Services Project

Creating an Analysis Services Project
Defining a Data Source
Defining a Data Source View
Modifying Default Table Names

Module 2:

Defining and Deploying a Cube

Defining a Dimension
Defining a Cube
Adding Attributes to Dimensions
Reviewing Cube and Dimension
Properties
Deploying an Analysis Services Project
Browsing the Cube

Module 3:

Working with Dimensions

Configuring Dimensions
Defining Hierarchies
Sorting and Grouping Attributes
Browsing the Deployed Cube

Module 4:

Working with Measures and Measure Groups

Configuring Measures
Defining Dimension Usage and Relationships
Configuring Measure Group Storage

Module 5:

Querying Multidimensional Analysis Solutions

MDX Fundamentals
Adding Calculations to a Cube

Module 6:

Defining Key Performance Indicators (KPIs)

Defining and Browsing KPIs

Module 7:

Defining Actions

Defining and Using a Drill through Action

Module 8:

Defining Perspectives and Translations

Defining and Browsing Perspectives
Defining and Browsing Translations

Module 9:

Defining Administrative Roles

Granting Process Database Permissions