SQL Server 2008 BI Overview

• Understanding Business Intelligence and Data Warehousing

• Defining Business Requirements

• Designing the Business Process

• Introduction to SQL Server Integration Services

• Data Extraction with SSIS

• Dimension ETL with SSIS

• Fact Table ETL with SSIS

• Extending Package Functionality

• Deploying Packages

• Designing the SSAS OLAP Database

• Designing Dimensions

• Designing Measure Groups and Measures

• Reporting Services Architecture

• Designing Reports

• Designing Data Access

• Advanced Report Design

• Enhanced Authoring for Reporting Services