SQL Server 2005-2008 Analysis Services

CLASS DATE(s):
11/29/2010 - 12/1/2010

COURSE LENGTH: 3 Days

COURSE COST: $1,495.00*

COURSE TIMES: 8:30am - 4:00pm


print
register

COURSE OVERVIEW

In this course, you will learn how to use Microsoft SQL Server 2008 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2008 developer the tools to build data cubes and forecasting solutions. This course also provides information on end-user tools including Microsoft Excel 2007, Office Visio 2007 Professional Edition, SQL Server Business Intelligence Development Studio (BIDS) Microsoft SQL Server 2005/2008 Integrated Services and Reporting Services.

*Course Cost does not include books. Please contact a VTEC Account Manager for details.

This course does not require any prior experience with Analysis Server 2008. It is assumed that students have working experience with SQL Server 2005 or 2008; basic relational database concepts (e.g., tables, queries, and indexing); data transformation services; Excel 2007; and SharePoint Server 2007.

In this course, you will:

• Learn to define what Business Intelligence is and how it applies to a database.
• Understand how the cube structure works for viewing data information.
• View cubes using Excel 2007 and SQL Reporting Services.
• See how to create cube models using SQL Server Business Intelligence Development Studio (BIDS).
• Create Data Source, Data Source Views and then create cubes with the Cube Wizard.
• Learn how to create key performance indicators (KPIs).
• Work with changing and advanced dimension types.
• Use relational and SSAS partitions.
• Understand how to use MDX syntax for queries, functions and tasks.
• Learn data mining concepts and mining structure processing.
• Implement security, XMLA scripts, backups and restores for SSAS.

COURSE TOPICS:

Define Business Intelligence

Understand the Cube Structure

Deploy and View a Sample Cube

View a Cube by using Excel

View a Cube by using SQL Reporting Services

Understand Basic OLAP Modeling (star schema)

Understand Dimensional Modeling (stars and snowflakes)

Understand Measure (fact) and Cube Modeling

Model with SQL Server Business Intelligence Development Studio (BIDS)

Understand the Development Environment

Create Data Sources

Create Data Source Views

Create Cubes by using the Cube Wizard

Learn how to Create Key Performance Indicators (KPIs)

Discover how to Create Perspectives

See how to Create Translations for Cubes and Dimensions

Review the three SSAS Action Object Types: Regular, Drillthrough, and Reporting

Work with Multiple Fact Tables and the Dimension Usage Subtab in BIDS

Explore Advanced Dimension Types

Learn how to use the Business Intelligence Wizard

Understand Writeback in Dimensions

Review Semi-Additive Measures in OLAP Cubes

View Aggregation Designs

Customize Aggregation Designs

Implement Proactive Caching

Use Relational and SSAS Partitions

Customize Cube and Dimension Processing

Understand Basic MDX Syntax

Use the MDX Query Editor in SSMS

Understand Common MDX Functions and Tasks

Review MDX Functions New to SSAS 2008

Understand the Calculation Subtab

Learn how to add Calculated Members

Explore how to add MDX Script Commands

Discover how to add .NET Assemblies

Understand Data Mining Concepts

Review the Algorithms that SSAS Includes

Consider Data Mining Clients

Understand Mining Structure Processing

Implement SSAS Security

Implement XMLA Scripts in SSMS

Deploy and Synchronize Databases

Understand SSAS Database Backup and Restore

Implement SSIS to Manage SSAS Datbases

Explore Clustering

Explore Scalability Options

Understand Performance Tuning and Optimization

Design Reports using Reporting Services

Design Reports by using Report Builder

Implement Excel 2007 Pivot Tables and Charts

Use Excel 2007 as a Data Mining Client

Review Microsoft Office SharePoint Server 2007