Introduction to Analysis Services
- 16m 18s
—Introduction to Analysis Services
0m 56s
—Business Intelligence Queries
3m 42s
—Architecture Options
4m 0s
—Database Development
1m 37s
—Development, Management, and Client Tools
4m 18s
—Summary
1m 45s
Dimensional Model Development
- 54m 52s
—Dimensional Model Development Overview
1m 20s
—Data Sources
3m 2s
—Demo: Creating a Data Source
4m 54s
—Top Down versus Bottom Up Design
1m 39s
—Top Down Design: Cube Wizard
3m 26s
—Top Down Design: Dimensions
2m 24s
—Demo: Using the Cube Wizard with Top Down Design
8m 0s
—Demo: Desigining Dimensions with Top Down
4m 3s
—Schema Generation Wizard
1m 47s
—Demo: Using the Schema Generation Wizard
3m 48s
—Data Source View
2m 24s
—Demo: Reviewing and Modifying a Top Down Data Source View
1m 39s
—Demo: Creating a New Data Source View from the Bottom Up
5m 29s
—Named Calculations
1m 4s
—Demo: Creating Named Calculations
2m 33s
—Named Queries
0m 55s
—Demo: Creating a Named Query
2m 34s
—Summary
3m 51s
Dimension Development I
- 45m 40s
—Dimension Development Overview
1m 19s
—Dimension Wizard
1m 26s
—Demo: Using the Dimension Wizard to Create a Standard Dimension
6m 20s
—Dimension Designer
2m 2s
—Attributes
1m 25s
—Demo: Browsing a Dimension
1m 43s
—Demo: Combining Tables for Snowflake Dimension (Top Down Design)
2m 3s
—Demo: Using the Dimension Wizard to Create a Snowflake Dimension
2m 56s
—Demo: Using the Dimension Wizard to Create a Date Dimension (Bottom Up Design)
2m 28s
—Demo: Using the Dimension Wizard to Create a Date Dimension (Top Down Design)
2m 49s
—Demo: Comparing Top Down to Bottom Up Date Dimensions
2m 28s
—Unknown Member
1m 54s
—Demo: Working with the Unknown Member
3m 56s
—Basic Attribute Properties
2m 53s
—Demo: Configuring Attribute Properties
6m 15s
—Summary
3m 43s
Dimension Development 2
- 45m 37s
—Dimension Development 2 Overview
0m 52s
—Date Dimension Properties
1m 55s
—Demo: Setting Properties for the Date Dimension
6m 16s
—Best Practice Warnings
1m 16s
—User Hierarchies
3m 3s
—Demo: Creating User-Defined Hierarchies
1m 57s
—Demo: Working with Best Practice Warnings
5m 13s
—Parent-child Hierarchy
1m 43s
—Demo: Creating a Parent-child Hierarchy
5m 40s
—Attribute Relationships
3m 2s
—Demo: Working with Attribute Relationships
5m 12s
—Translations
0m 59s
—Demo: Adding Translations to a Dimension
3m 53s
—Dimension Development Tasks
1m 19s
—Summary
3m 17s
Cube Development I
- 44m 34s
—Cube Development Overview
0m 57s
—Cube Wizard
2m 11s
—Demo: Using the Cube Wizard to Create a Cube
4m 10s
—Cube Designer
1m 55s
—Measure Properties
1m 16s
—Aggregate Functions
3m 46s
—Demo: Configuring Measure Properties
2m 53s
—Role-Playing Dimension
1m 42s
—Demo: Reviewing the Cube Dimensions
1m 49s
—Demo: Deploying and Browsing the Cube
6m 59s
—Additional Measures
0m 51s
—Demo: Adding Measures and Dimensions to an Existing Cube
5m 50s
—Dimension Usage
3m 30s
—Demo: Changing Dimension Usage
5m 25s
—Summary
1m 20s
Cube Development 2
- 24m 53s
—Cube Development 2 Overview
0m 59s
—Aggregations
4m 4s
—Demo: Using the Aggregation Wizard
6m 18s
—Demo: Viewing Aggregation Designs
3m 39s
—Perspectives
1m 35s
—Demo: Adding a Perspective
2m 21s
—Translations
0m 47s
—Demo: Adding Translations to a Cube
2m 15s
—Cube Development Tasks
1m 37s
—Summary
1m 18s
—Overview
1m 35s
—Calculation Designer
2m 12s
—Calculation Tools: Metadata
2m 2s
—Demo: Understanding Formulas
1m 58s
—Demo: Creating a Calculation to Sum Measures
4m 39s
—Demo: Testing a Calculation
2m 24s
—Calculation Tools: Functions
2m 45s
—Demo: Creating a Growth Calculation
5m 58s
—Demo: Testing the Growth Calculation
2m 9s
—Calculation Tools: Templates
1m 26s
—Demo: Creating a Ratio Calculation
6m 17s
—Color and Font Expressions
2m 18s
—Demo: Using Color and Font Expressions with Calculations
5m 16s
—Summary
2m 29s
—Overview
1m 0s
—Calculated Members of a Dimension
2m 28s
—Demo: Creating a Non-Measure Calculation
7m 14s
—Named Sets
1m 34s
—Demo: Creating a Named Set
4m 51s
—Key Performance Indicators
2m 59s
—Demo: Creating a Key Performance Indicators
4m 29s
—Summary
2m 20s
Database Processing
- 48m 17s
—Overview
0m 49s
—BIDS Deployment
1m 42s
—Project Properties
3m 10s
—Demo: Understanding the Deployment Process
6m 57s
—Deployment Wizard
4m 53s
—Demo: Using the Analysis Services Deployment Wizard
6m 39s
—Storage Modes
4m 29s
—Effect of Updates
2m 1s
—Demo: Configuring the Storage Mode
2m 20s
—Processing
2m 25s
—Process Options
5m 50s
—Demo: Processing a Cube
4m 48s
—Summary
2m 14s
—Overview
1m 9s
—User Security
1m 26s
—Dimension Security
3m 23s
—Demo: Applying Dimension Security
7m 43s
—Demo: Testing Dimension Security
2m 10s
—Demo: Applying Dimension Security
1m 19s
—Demo: Working with Multiple Roles
5m 47s
—Demo: Working with a Default Member
2m 14s
—Cell Security
2m 16s
—Demo: Defining Cell Security
5m 12s
—Administrator Security
1m 31s
—Demo: Configuring Administrator Security
2m 14s
—Service Account Configuration
2m 22s
—Summary
2m 13s