4-Day (BI-SSAS005-301-EN)
Description
During this 4-day course, you will learn to design, develop, and deploy an analytical solution using SQL Server 2005 Analysis Services (SSAS). This course demonstrates design and development best practices as you build a fully working analytical solution.
SQL Server 2005 Analysis Services (SSAS) enables IT Professionals to rapidly build and deploy powerful analytical solutions that enable business users to analyze business data and achieve competitive advantage. SSAS enables rapid application development, increases performance and functionality, and reduces the costs and complexity of operation. This course focuses on teaching IT professionals the skills and best practices required to design and develop a well performing and success analytical solution using SQL Server 2005 Analysis Services.
Target Audience
This course is intended for IT Professionals that are responsible for designing, developing, and deploying business intelligence solutions. The target audience for this course is database warehouse, decision support, and business intelligence solution architects, IT professionals, and business intelligence developers who want to learn the details of how to use the new capabilities provided by SSAS to build analytical applications
Prerequisites
Before attending this course, it is recommended that students have the following skills:
- While this course is targeted at database professionals with some experience with data warehouse solutions, this workshop requires no prior experience with SQL Server 2000 Analysis Services.
Course Objectives
After completing this course, the student will be able to:
- Define Data Source Views
- Define and Deploy Cubes
- Modify Measures, Attributes and Hierarchies
- Define Advanced Attribute and Dimension Properties
- Define Relationships Between Dimensions and Measure Groups
- Define Calculations and Key Performance Indicators
- Define Storage Modes and Utilize Partitions
- Deploy an Analytical Solution to Production
- Define Analysis Services Aggregations
- Utilize SQL Server Profiler to Tune Performance
Course Outline
Section A: Overview
Introduction 01: SQL Server 2005
- Microsoft's Business Intelligence Vision
- Introduction to SQL Server 2005 Business Intelligence Components
Introduction 02: Dimensional Modeling
- Introduction to BI Architecture
- Introduction to Dimensional Modeling
Introduction 03: Getting Familiar with SQL Server 2005 Development and Management Tools
- Business Intelligence Developer Studio
- SQL Server Management Studio
- Other Tools
Section B: Analysis Services (SSAS)
Module 1: Overview of Analysis Services
- Understanding Analysis Services Projects
- Understanding the Unified Dimensional Model (UDM) and the Solution Architecture
- Introducing Dimensions and Measures
- Introducing Processing, Storage Modes and Aggregations
- LAB 1: Defining and Creating an Analysis Services Database
Module 2: Data Sources and Data Source Views
- Defining Data Sources
- Defining Data Source Views
- LAB 2: Defining a Data Source and a Data Source View
Module 3: Defining Dimensions
- Defining Database and Cube Dimensions
- Defining Dimension and Attribute Properties
- Defining Attribute Relationships
- Defining User Hierarchies
- LAB 3 - Defining the Date Dimension
- LAB 4 - Defining and Creating the Product and Customer Dimensions
Module 4: Defining Cube and Measure Properties
- Using the Cube Wizard
- Defining Cube Properties
- Defining Measure Groups and Properties
- Defining Measure Properties
- LAB 5: Define and Deploy a Simple Sales Cube
Module 5: Defining Dimension and Measure Group Relationships
- Defining Dimension Usage
- Defining Regular Relationships
- Defining Referenced Relationships
- Defining Fact Relationships
- Defining Many-to-Many Relationships
- LAB 6: Add Reseller Sales to Simple Sales Cube
Module 6: Defining Calculations and KPIs
- Using MDX Calculation Scripts
- Defining Key Performance Indicators
- LAB 7: Add Sales Quotas to Simple Sales Cube
- LAB 8: Add Calculations and KPIs to the Simple Cube
Module 7: Using Advanced Cube Options
- Actions
- Perspectives
- Translations
Module 8: Defining Cube Storage, Aggregations and Processing
- Defining Cube and Dimension Storage Modes
- Partitions Multiple Partitions
- Defining Aggregations
- Processing SSAS Objects
- Utilizing Proactive Caching
- LAB 9: Working with Partitions and Aggregations
- LAB 10: Updating Dimension and Cube Data
Module 9: Security Roles
- Understanding SSAS Security
- Understanding Administrative Access Roles
- Understanding User Access Roles
Module 10: Deployment and Management
- Using the Analysis Services Deployment Wizard
- Server Synchronization
- Backup and Restore
- Object Scripting
- Server-level Properties