SQL Server 2008 BI End-to-End Online - Integration Services
Page Content
2 Days (BI-BIE2E08-201-EN-ONL1)
DescriptionBusiness
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
| 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 |
CourseOutline
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