Please enable Javascript, which is required for this site.
ssas-basic

Analysis Services Fundamentals

This course is for business intelligence developers and database professionals responsible for preparing data for multidimensional analysis and assumes no prior experience with Analysis Services

Authored by: Stacia Misner
Duration: 6h 32m
Level: Beginner
Released: 8/22/2011
Course Rating:
You are currently not signed in. Please sign in to access subscriber-only content.
Currently using:  {{getCurrentPlayerName()}}  [Change]
expand all | collapse all Progress Duration
This module is unavailableIntroduction to Analysis Services
 You have not watched this Module. 00:16:18
Introduction to Analysis Services
You have not watched this Clip. 00:56
Business Intelligence Queries
You have not watched this Clip. 03:42
Architecture Options
You have not watched this Clip. 04:00
Database Development
You have not watched this Clip. 01:37
Development, Management, and Client Tools
You have not watched this Clip. 04:18
Summary
You have not watched this Clip. 01:45
This module is unavailableDimensional Model Development
 You have not watched this Module. 00:55:36
Dimensional Model Development Overview
You have not watched this Clip. 01:20
Data Sources
You have not watched this Clip. 03:02
Demo: Creating a Data Source
You have not watched this Clip. 04:54
Top Down versus Bottom Up Design
You have not watched this Clip. 01:39
Top Down Design: Cube Wizard
You have not watched this Clip. 03:39
Top Down Design: Dimensions
You have not watched this Clip. 02:32
Demo: Using the Cube Wizard with Top Down Design
You have not watched this Clip. 08:15
Demo: Desigining Dimensions with Top Down
You have not watched this Clip. 04:03
Schema Generation Wizard
You have not watched this Clip. 01:47
Demo: Using the Schema Generation Wizard
You have not watched this Clip. 03:52
Data Source View
You have not watched this Clip. 02:28
Demo: Reviewing and Modifying a Top Down Data Source View
You have not watched this Clip. 01:39
Demo: Creating a New Data Source View from the Bottom Up
You have not watched this Clip. 05:29
Named Calculations
You have not watched this Clip. 01:04
Demo: Creating Named Calculations
You have not watched this Clip. 02:33
Named Queries
You have not watched this Clip. 00:55
Demo: Creating a Named Query
You have not watched this Clip. 02:34
Summary
You have not watched this Clip. 03:51
This module is unavailableDimension Development I
 You have not watched this Module. 00:45:40
Dimension Development Overview
You have not watched this Clip. 01:19
Dimension Wizard
You have not watched this Clip. 01:26
Demo: Using the Dimension Wizard to Create a Standard Dimension
You have not watched this Clip. 06:20
Dimension Designer
You have not watched this Clip. 02:02
Attributes
You have not watched this Clip. 01:25
Demo: Browsing a Dimension
You have not watched this Clip. 01:43
Demo: Combining Tables for Snowflake Dimension (Top Down Design)
You have not watched this Clip. 02:03
Demo: Using the Dimension Wizard to Create a Snowflake Dimension
You have not watched this Clip. 02:56
Demo: Using the Dimension Wizard to Create a Date Dimension (Bottom Up Design)
You have not watched this Clip. 02:28
Demo: Using the Dimension Wizard to Create a Date Dimension (Top Down Design)
You have not watched this Clip. 02:49
Demo: Comparing Top Down to Bottom Up Date Dimensions
You have not watched this Clip. 02:28
Unknown Member
You have not watched this Clip. 01:54
Demo: Working with the Unknown Member
You have not watched this Clip. 03:56
Basic Attribute Properties
You have not watched this Clip. 02:53
Demo: Configuring Attribute Properties
You have not watched this Clip. 06:15
Summary
You have not watched this Clip. 03:43
This module is unavailableDimension Development 2
 You have not watched this Module. 00:45:37
Dimension Development 2 Overview
You have not watched this Clip. 00:52
Date Dimension Properties
You have not watched this Clip. 01:55
Demo: Setting Properties for the Date Dimension
You have not watched this Clip. 06:16
Best Practice Warnings
You have not watched this Clip. 01:16
User Hierarchies
You have not watched this Clip. 03:03
Demo: Creating User-Defined Hierarchies
You have not watched this Clip. 01:57
Demo: Working with Best Practice Warnings
You have not watched this Clip. 05:13
Parent-child Hierarchy
You have not watched this Clip. 01:43
Demo: Creating a Parent-child Hierarchy
You have not watched this Clip. 05:40
Attribute Relationships
You have not watched this Clip. 03:02
Demo: Working with Attribute Relationships
You have not watched this Clip. 05:12
Translations
You have not watched this Clip. 00:59
Demo: Adding Translations to a Dimension
You have not watched this Clip. 03:53
Dimension Development Tasks
You have not watched this Clip. 01:19
Summary
You have not watched this Clip. 03:17
This module is unavailableCube Development I
 You have not watched this Module. 00:44:34
Cube Development Overview
You have not watched this Clip. 00:57
Cube Wizard
You have not watched this Clip. 02:11
Demo: Using the Cube Wizard to Create a Cube
You have not watched this Clip. 04:10
Cube Designer
You have not watched this Clip. 01:55
Measure Properties
You have not watched this Clip. 01:16
Aggregate Functions
You have not watched this Clip. 03:46
Demo: Configuring Measure Properties
You have not watched this Clip. 02:53
Role-Playing Dimension
You have not watched this Clip. 01:42
Demo: Reviewing the Cube Dimensions
You have not watched this Clip. 01:49
Demo: Deploying and Browsing the Cube
You have not watched this Clip. 06:59
Additional Measures
You have not watched this Clip. 00:51
Demo: Adding Measures and Dimensions to an Existing Cube
You have not watched this Clip. 05:50
Dimension Usage
You have not watched this Clip. 03:30
Demo: Changing Dimension Usage
You have not watched this Clip. 05:25
Summary
You have not watched this Clip. 01:20
This module is unavailableCube Development 2
 You have not watched this Module. 00:24:53
Cube Development 2 Overview
You have not watched this Clip. 00:59
Aggregations
You have not watched this Clip. 04:04
Demo: Using the Aggregation Wizard
You have not watched this Clip. 06:18
Demo: Viewing Aggregation Designs
You have not watched this Clip. 03:39
Perspectives
You have not watched this Clip. 01:35
Demo: Adding a Perspective
You have not watched this Clip. 02:21
Translations
You have not watched this Clip. 00:47
Demo: Adding Translations to a Cube
You have not watched this Clip. 02:15
Cube Development Tasks
You have not watched this Clip. 01:37
Summary
You have not watched this Clip. 01:18
This module is unavailableCalculations 1
 You have not watched this Module. 00:43:28
Overview
You have not watched this Clip. 01:35
Calculation Designer
You have not watched this Clip. 02:12
Calculation Tools: Metadata
You have not watched this Clip. 02:02
Demo: Understanding Formulas
You have not watched this Clip. 01:58
Demo: Creating a Calculation to Sum Measures
You have not watched this Clip. 04:39
Demo: Testing a Calculation
You have not watched this Clip. 02:24
Calculation Tools: Functions
You have not watched this Clip. 02:45
Demo: Creating a Growth Calculation
You have not watched this Clip. 05:58
Demo: Testing the Growth Calculation
You have not watched this Clip. 02:09
Calculation Tools: Templates
You have not watched this Clip. 01:26
Demo: Creating a Ratio Calculation
You have not watched this Clip. 06:17
Color and Font Expressions
You have not watched this Clip. 02:18
Demo: Using Color and Font Expressions with Calculations
You have not watched this Clip. 05:16
Summary
You have not watched this Clip. 02:29
This module is unavailableCalculations 2
 You have not watched this Module. 00:26:55
Overview
You have not watched this Clip. 01:00
Calculated Members of a Dimension
You have not watched this Clip. 02:28
Demo: Creating a Non-Measure Calculation
You have not watched this Clip. 07:14
Named Sets
You have not watched this Clip. 01:34
Demo: Creating a Named Set
You have not watched this Clip. 04:51
Key Performance Indicators
You have not watched this Clip. 02:59
Demo: Creating a Key Performance Indicators
You have not watched this Clip. 04:29
Summary
You have not watched this Clip. 02:20
This module is unavailableDatabase Processing
 You have not watched this Module. 00:48:17
Overview
You have not watched this Clip. 00:49
BIDS Deployment
You have not watched this Clip. 01:42
Project Properties
You have not watched this Clip. 03:10
Demo: Understanding the Deployment Process
You have not watched this Clip. 06:57
Deployment Wizard
You have not watched this Clip. 04:53
Demo: Using the Analysis Services Deployment Wizard
You have not watched this Clip. 06:39
Storage Modes
You have not watched this Clip. 04:29
Effect of Updates
You have not watched this Clip. 02:01
Demo: Configuring the Storage Mode
You have not watched this Clip. 02:20
Processing
You have not watched this Clip. 02:25
Process Options
You have not watched this Clip. 05:50
Demo: Processing a Cube
You have not watched this Clip. 04:48
Summary
You have not watched this Clip. 02:14
This module is unavailableSecurity
 You have not watched this Module. 00:40:59
Overview
You have not watched this Clip. 01:09
User Security
You have not watched this Clip. 01:26
Dimension Security
You have not watched this Clip. 03:23
Demo: Applying Dimension Security
You have not watched this Clip. 07:43
Demo: Testing Dimension Security
You have not watched this Clip. 02:10
Demo: Applying Dimension Security
You have not watched this Clip. 01:19
Demo: Working with Multiple Roles
You have not watched this Clip. 05:47
Demo: Working with a Default Member
You have not watched this Clip. 02:14
Cell Security
You have not watched this Clip. 02:16
Demo: Defining Cell Security
You have not watched this Clip. 05:12
Administrator Security
You have not watched this Clip. 01:31
Demo: Configuring Administrator Security
You have not watched this Clip. 02:14
Service Account Configuration
You have not watched this Clip. 02:22
Summary
You have not watched this Clip. 02:13