SQL Server 2008 BI End-to-End Online - Integration Services

Choose your own date

INFORMATION COURSE OUTLINE

2 Days (BI-BIE2E08-201-EN-ONL1)

Description
Audience
Prerequisites
Course Format and Agenda
Agenda

Description

Business intelligence solutions provide the infrastructure that enables users at all levels of a business to make better decisions based on more accurate and up-to-date information. The full 6-day BI End-to-End workshop focuses on teaching IT professionals the best practices and skills required to successfully design, build, deploy, and operate a business intelligence solution using SQL Server 2008 Integration Services, Analysis Services and Reporting Services.

This is the first section of the workshop covering Integration Services.

Audience This course is designed for IT professionals who are interesting in learning how to implement Business Intelligence solutions on the Microsoft SQL Server platform. Basic knowledge of BI concepts is assumed and some experience with SQL Server is required.

Prerequisites

Before attending this course, it is recommended that students have the following skills:

- Basic knowledge of Business Intelligence
- Knowledge of relational database systems
- Experience with SQL Server database
- Basic knowledge of windows security

Course Format and Agenda The full course will be delivered in an online format over 6 days following the agenda below.
Students can register to a 2-day section seperately or to the full 6-day course.
In addition to the live modules, students will be given access to two pre-recorded introduction modules.

Introduction - Pre-recorded.
Section 1 - Integration Services - Week 1, Mon-Tue
Section 2 - Analysis Services - Week 2, Mon-Tue
Section 3 - Reporting Services - Week 3, Mon-Tue

Online Agenda

Start Time	Duration	Description
7:00 AM PST	75 Minutes	Presentation
8:15 AM PST	15 Minutes	Break
8:30 AM PST	75 Minutes	Presentation
9:45 AM PST	75 Minutes	Break / Lab
11:00 AM PST	75 Minutes	Presentation
12:15 PM PST	15 Minute	Break
12:30 PM PST	90 Minutes	Lab / Lab Support
2:00 PM PST		Conclude

Course Outline

Introduction - Pre-Recorded Modules

Module 01: Introduction to Business IntelligenceThis module introduces BI and components of a BI solution and then discusses the various products that are available from Microsoft for implementing a BI solution and how those technologies fit into the BI component stack. We will then introduce in more detail the technologies that are part of the SQL Server BI Platform and also highlight some of the major changes in each of those technologies in 2008. We will also look at the various tools that are available for developing and managing the technologies.

BI Practice
Components of a BI solutions
MS BI stack
Intro to the MS SQL BI Platform
Highlight some major changes between SQL Server 2005 and 2008
Client Tools for development and management – also highlight differences from 2005

Module 02: Preparing Data for AnalyticsThis module provides an introduction to dimensional modeling and lays the foundation for more detailed topics covered over the next few modules. We will cover Dimensional Modeling concepts including Fact and Dimension tables and how to implement a dimensional model within your organization. We will also address the needs for implementing dimensional models and talk about Data Warehousing and Data Marts. We will also briefly discuss processes for loading data into these dimensional tables.

The Need
Dimensional Modeling
Dimensional Modeling Concepts

Section 1 - Integration Services

Day 1

Module 03: Introduction to SSISThis module introduces the various high-level features of SQL Serer Integration Services and also introduces the development environment for SSIS.

The Need
SSIS Components
Changes in SQL Server 2008
Package Components
Data Sources and Connections
LAB: Creating a simple package

Module 04: Implementing workflows using SQL Server Integration ServicesThis module provides an introduction to the components of SQL Server Integration Services and the package. It also highlights changes in 2008 for in the control flow environment and explains how to use the components and features of SSIS to build process workflows.

The Need
Package Components

Tasks, Containers and Precedence Constraints

Variables
SSIS Expressions
LAB: Implementing workflows in Microsoft SSIS

Module 05: Processing data using SQL Server Integration ServicesThis module highlights the various components of a data flow environment and then explains how to use these components and features to implement ETL processes. This module does not go into great details around the internals of SSIS Data Flow.

The Need
Data Flow Components: Source and destination adapters, transformations, data flow paths
Highlight: ADO.Net support
Building data flows
Hightlight: Lookup Transform
LAB: Processing Data using SSIS

Day 2

Module 06: Loading Dimension Tables using SQL Server Integration ServicesThis module covers the specific components of the data flow that are used to implement ETL processes to load dimension tables.

The Need

Slowly Changing Dimension Concept

Highlight: Slowly Changing Dimension Transform

Other Dimension Load Types

Highlight: MERGE statement support

LAB: Creating Dimension Load Package
Module 07: Loading FactTables using SQL Server Integration ServicesThis module covers the specific components of the data flow that are used to implement ETL processes to load fact tables.

The Need

Loading Fact Tables using SSIS Transformations

Analysis Services Integration

LAB: Creating Fact Load Package

Module 08: Managing SQL Server Integration Services PackagesThis module covers management and deployment aspects of SSIS packages.

Logging

Configuration

Deployment

LAB: Deploying and scheduling SSIS Packages