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
What you'll learn
This course explains how to develop Analysis Services databases, beginning with the dimensional modeling process and continuing with the development of dimensions and cubes. It also covers the integration of business logic into the cube by adding calculations, named sets, and key performance indicators. This course explains how to deploy and process Analysis Services databases and how to implement security for both users and administrators. The features and demonstrations in this course focus on the SQL Server 2008 R2 release, although most topics also apply to earlier versions of Analysis Services.
Table of contents
- Dimensional Model Development Overview 1m
- Data Sources 3m
- Demo: Creating a Data Source 5m
- Top Down versus Bottom Up Design 2m
- Top Down Design: Cube Wizard 3m
- Top Down Design: Dimensions 2m
- Demo: Using the Cube Wizard with Top Down Design 8m
- Demo: Desigining Dimensions with Top Down 4m
- Schema Generation Wizard 2m
- Demo: Using the Schema Generation Wizard 4m
- Data Source View 2m
- Demo: Reviewing and Modifying a Top Down Data Source View 2m
- Demo: Creating a New Data Source View from the Bottom Up 5m
- Named Calculations 1m
- Demo: Creating Named Calculations 3m
- Named Queries 1m
- Demo: Creating a Named Query 3m
- Summary 4m
- Dimension Development Overview 1m
- Dimension Wizard 1m
- Demo: Using the Dimension Wizard to Create a Standard Dimension 6m
- Dimension Designer 2m
- Attributes 1m
- Demo: Browsing a Dimension 2m
- Demo: Combining Tables for Snowflake Dimension (Top Down Design) 2m
- Demo: Using the Dimension Wizard to Create a Snowflake Dimension 3m
- Demo: Using the Dimension Wizard to Create a Date Dimension (Bottom Up Design) 2m
- Demo: Using the Dimension Wizard to Create a Date Dimension (Top Down Design) 3m
- Demo: Comparing Top Down to Bottom Up Date Dimensions 2m
- Unknown Member 2m
- Demo: Working with the Unknown Member 4m
- Basic Attribute Properties 3m
- Demo: Configuring Attribute Properties 6m
- Summary 4m
- Dimension Development 2 Overview 1m
- Date Dimension Properties 2m
- Demo: Setting Properties for the Date Dimension 6m
- Best Practice Warnings 1m
- User Hierarchies 3m
- Demo: Creating User-Defined Hierarchies 2m
- Demo: Working with Best Practice Warnings 5m
- Parent-child Hierarchy 2m
- Demo: Creating a Parent-child Hierarchy 6m
- Attribute Relationships 3m
- Demo: Working with Attribute Relationships 5m
- Translations 1m
- Demo: Adding Translations to a Dimension 4m
- Dimension Development Tasks 1m
- Summary 3m
- Cube Development Overview 1m
- Cube Wizard 2m
- Demo: Using the Cube Wizard to Create a Cube 4m
- Cube Designer 2m
- Measure Properties 1m
- Aggregate Functions 4m
- Demo: Configuring Measure Properties 3m
- Role-Playing Dimension 2m
- Demo: Reviewing the Cube Dimensions 2m
- Demo: Deploying and Browsing the Cube 7m
- Additional Measures 1m
- Demo: Adding Measures and Dimensions to an Existing Cube 6m
- Dimension Usage 4m
- Demo: Changing Dimension Usage 5m
- Summary 1m
- Overview 2m
- Calculation Designer 2m
- Calculation Tools: Metadata 2m
- Demo: Understanding Formulas 2m
- Demo: Creating a Calculation to Sum Measures 5m
- Demo: Testing a Calculation 2m
- Calculation Tools: Functions 3m
- Demo: Creating a Growth Calculation 6m
- Demo: Testing the Growth Calculation 2m
- Calculation Tools: Templates 1m
- Demo: Creating a Ratio Calculation 6m
- Color and Font Expressions 2m
- Demo: Using Color and Font Expressions with Calculations 5m
- Summary 2m
- Overview 1m
- BIDS Deployment 2m
- Project Properties 3m
- Demo: Understanding the Deployment Process 7m
- Deployment Wizard 5m
- Demo: Using the Analysis Services Deployment Wizard 7m
- Storage Modes 4m
- Effect of Updates 2m
- Demo: Configuring the Storage Mode 2m
- Processing 2m
- Process Options 6m
- Demo: Processing a Cube 5m
- Summary 2m
- Overview 1m
- User Security 1m
- Dimension Security 3m
- Demo: Applying Dimension Security 8m
- Demo: Testing Dimension Security 2m
- Demo: Applying Dimension Security 1m
- Demo: Working with Multiple Roles 6m
- Demo: Working with a Default Member 2m
- Cell Security 2m
- Demo: Defining Cell Security 5m
- Administrator Security 2m
- Demo: Configuring Administrator Security 2m
- Service Account Configuration 2m
- Summary 2m
About the author
Stacia Misner Varga is an instructor, author, and principal consultant of Data Inspirations. Her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, she has provided consulting and education services for Microsoft’s data platform and authored or co-authored many books covering this topic. In addition, Stacia has been a frequent speaker over the years at technology conferences worldwide.