Computer Data, Inc.

This course includes two days of exclusive content, including hands-on labs where you will learn to implement a full end-to-end Business Intelligence Solution. You will learn how to leverage other Microsoft products, including Excel, Reporting Services, Report Builder, and SharePoint.

What You'll Learn

• How SQL Server Analysis Services can be used to implement analytical solutions
• Create multidimensional analysis solutions with SQL Server Analysis Services
• Implement dimensions and cubes in an Analysis Services solution
• Implement measures and measure groups in an Analysis Services solution
• Query a multidimensional Analysis Services solution
• Customize an Analysis Services cube
• Deploy and secure an Analysis Services database
• Maintain a multidimensional Analysis Services solution
• Implement a Data Mining solution
• Tune SSAS cubes
• Design SSAS for performance
• Load Data Warehouse solutions using SSIS
• Create and implement Reporting Solutions using SQL Server Reporting Services
• Integrate SSAS with Microsoft Excel
• Create Excel Reports against cubes
• Expose cubes in a Sharepoint environment

Course Outline

1. Introduction to Microsoft SQL Server Analysis Services

• Overview of Data Analysis Solutions
• Overview of SQL Server Analysis Services
• Installing SQL Server Analysis Services

2. Creating Multidimensional Analysis Solutions

• Developing Analysis Services Solutions
• Creating Data Sources and Data Source Views
• Creating a Cube

3. Working with Cubes and Dimensions

• Configuring Dimensions
• Defining Attribute Hierarchies
• Sorting and Grouping Attributes

4. Working with Measures and Measure Groups

• Working with Measures
• Working with Measure Groups

5. Querying Multidimensional Analysis Solutions

• MDX Fundamentals
• Adding Calculations to a Cube

6. Customizing Cube Functionality

• Implementing Key Performance Indicators (KPI)
• Implementing Actions
• Implementing Perspectives
• Implementing Translations

7. Deploying and Securing an Analysis Services Database

• Deploying an Analysis Services Database
• Securing an Analysis Services Database

8. Maintaining a Multidimensional Solution

• Configuring Processing
• Logging, Monitoring, and Optimizing an Analysis Services Solution
• Backing Up and Restoring an Analysis Services Database

9. Introduction to Data Mining

• Overview of Data Mining
• Creating a Data Mining Solution
• Validating Data Mining Models

10. Exclusive - Tuning SSAS

• Index Creation, Maintenance, and Tuning
• Using SQL Server Profiler against SSAS Cubes
• Proactive Caching Overview
• Benefits of Proactive Caching
• Implementing Proactive Caching
• Aggregation Design and Tuning

11. Exclusive - SQL Server Integration Services

• Overview of SSIS
• SSIS Designer
• Running SSIS Packages
• Populating a Data Warehouse with SSIS

12. Exclusive - Integrating SSAS and MS Excel

• Installing Microsoft Office 2007 Tools
• Connecting to SSAS Cubes
• Creating Pivot Tables and Charts against Cubes

13. Exclusive - Reporting Services

• Overview of Reporting Services
• Setting Up and Configuring Reporting Services
• Creating Reports using Business Intelligence Development Studio
• Creating Ad Hoc Reports using Report Builder

Labs

Lab 1: Using SQL Server Analysis Services

• Installing SQL Server Analysis Services
• Verifying Installation

Lab 2: Creating Multidimensional Analysis Solutions

• Creating a Data Source
• Creating and Modifying a Data Source View
• Creating and Modifying a Cube

Lab 3: Working with Cubes and Dimensions

• Configuring Dimensions
• Defining Relationships and Hierarchies
• Sorting and Grouping Dimension Attributes

Lab 4: Working with Measures and Measure Groups

• Configuring Measures
• Defining Dimension Usage and Relationships
• Configuring Measure Group Storage

Lab 5: Querying Multidimensional Analysis Solutions

• Querying a Cube by Using MDX
• Creating a Calculated Member
• Defining a Named Set

Lab 6: Customizing Cube Functionality

• Implementing a KPI
• Implementing an Action
• Implementing a Perspective
• Implementing a Translation

Lab 7: Deploying and Securing an Analysis Services Database

• Deploying an Analysis Services Database
• Securing an Analysis Services Database

Lab 8: Maintaining a Multidimensional Solution

• Configuring Processing
• Implementing Logging and Monitoring
• Backing Up and Restoring an Analysis Services Database

Lab 9: Introduction to Data Mining

• Creating a Data Mining Structure
• Adding a Data Mining Model
• Exploring Data Mining Models
• Validating Data Mining Models

Lab 10: Exclusive - Tuning SSAS

• Index Creation, Maintenance, and Tuning
• Using SQL Server Profiler against SSAS Cubes
• Implementing Proactive Caching
• Aggregation Design Tuning
• Aggregation Tools

Lab 11: Exclusive - SQL Server Integration Services

• Overview of SSIS
• SSIS Designer
• Running SSIS Packages
• Populating a Data Warehouse with SSIS

Lab 12: Exclusive - Integrating SSAS and MS Excel

• Installing Microsoft Office 2007 Tools
• Connecting to SSAS Cubes
• Creating Pivot Tables and Charts against Cubes

Lab 13: Exclusive - Reporting Services

• Setting Up and Configuring Reporting Services
• Creating Reports using Business Intelligence Development Studio
• Creating Ad Hoc Reports using Report Builder
• Deploying Reports to Report Manager