This course will cover how to use SQL Server Integration Services 2008 (SSIS) to manage an Extract, Transform, and Load (ETL) process. We will start by looking at the fundamental components that make up SSIS and then move onto designing packages using Business Intelligence Development Studio. We will look at solutions to common ETL challenges such as slowly changing dimensions. Topics covered are:

• Reviewing ETL Fundamentals

• Introducing SSIS Components

• Designing ETL Packages

• Slowly Changing Dimension Transformation

This course will act as an introduction to SQL Server Reporting Services 2008 (SSRS). We will start by covering the SSRS architecture and then move onto designing and deploying reports using Business Intelligence Development Studio, Report Builder, and Report Designer. We will also look at new SSRS 2008 features. Topics covered are:

• Reporting Fundamentals

• Introducing SSRS

• Basic SSRS Report Design

• Introducing Report Interactivity

• Extending Reports with Custom Logic

This course provides an overview of the Unified Dimensional Model. We will discuss how the UDM is beneficial to us when creating aggregations and reports to be deployed into various environments.

This course provides an overview of SQL Server Analysis Services 2008. We will look at core new features and also do comparisons between SSAS 2005 and SSAS 2008.

This course provides an overview of data mining. We will look at common scenarios when using data mining is useful. We will also cover the basics for how to use SSAS 2008 data mining tools.

This course will act as an introduction to dimensional modeling techniques. We will look at common practices for creating scalable data warehouses and discuss how to solve common challenges such as slowly changing dimensions.

This course will focus on common ETL challenges. We will look at how having an understanding of ETL and how to implement best practices is important when building a successful data warehouse

This course will cover the basics for how to best load data into your data warehouse in an efficient manner.

This course will cover the basics of how to design both operational and non-operational reports using your data warehouse environment. We will introduce how SQL Server reporting services can help you design, manage and deploy reports.

This course will look at common challenges that a lot of organizations face with reporting, data aggregation, performance management, and collaboration. We will discuss how the Microsoft BI platform can help you solve these problems.