SQL Server 2008 Training, Bi Training, SQL Server 2008 BI, Online Training... - Course

SQL Server 2008 End-to-End Business Intelligence Workshop - Online

Choose your own date

6-Day (BI-BIE2E08-201-EN-ONL)

Description
AudiencePrerequisitesCourse ObjectivesCourse Format and AgendaIntroduction Pre-recordedAgenda

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. This 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.

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 Objectives Upon completion of this course, the student will be able to:

Understand dimensional design and key Business Intelligence concepts
Design a simple data mart
Use SSIS to build a simple ETL process to load the data mart from various source systems
Develop and customize a UDM for implementing basic usability features
Use SSRS to develop and customize reports
Understand other ways to consume data from the UDM

Course Format and Agenda

This course will be delivered in an online format over 6 days following the agenda below.

In addition to the live modules, students will be given access to two pre-recorded introduction modules.

Students can register to each 2-day section seperately or to the full 6-day course.

Introduction - Pre-recorded.

Section 1 - Week 1 - Integration Services: 12-13 Sep     29-30 Nov     13-14 Mar 2012
Section 2 - Week 2 - Analysis Services:     19-20 Sep     6-7 Dec        20-21 Mar 2012
Section 3 - Week 3 - Reporting Services:    26-27 Sep    13-14 Dec     27-28 Mar 2012

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 Minutes	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 Intelligence This 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 PracticeComponents of a BI solutionsMS BI stackIntro to the MS SQL BI PlatformHighlight some major changes between SQL Server 2005 and 2008Client 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

Day 1Section 1 - Integration Services

Module 03: Introduction to SSIS This 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 Services This 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 NeedPackage ComponentsTasks, Containers and Precedence ConstraintsVariablesSSIS ExpressionsLAB: Implementing workflows in Microsoft SSIS

Module 05: Processing data using SQL Server Integration Services High level review of business intelligence architecture and dimension modeling basics, including dimension tables and fact table descriptionsThe Need Data Flow Components: Source and destination adapters, transformations, data flow pathsHighlight: ADO.Net supportBuilding data flows Hightlight: Lookup TransformLAB: Processing Data using SSIS

Day 2

Module 06: Loading Dimension Tables using SQL Server Integration Services This module covers the specific components of the data flow that are used to implement ETL processes to load dimension tables.The NeedSlowly Changing Dimension Concept Highlight: Slowly Changing Dimension Transform Other Dimension Load TypesHighlight: MERGE statement supportLAB: Creating Dimension Load Package

Module 07: Loading FactTables using SQL Server Integration Services This module covers the specific components of the data flow that are used to implement ETL processes to load fact tables.The NeedLoading Fact Tables using SSIS TransformationsAnalysis Services IntegrationLAB: Creating Fact Load Package

Module 08: Managing SQL Server Integration Services Packages This module covers management and deployment aspects of SSIS packages. LoggingConfiguration DeploymentLAB: Deploying and scheduling SSIS Packages

Day 3 Section 2 - Analysis Services

Module 09: Introduction to SQL Server Analysis Services This module introduces key concepts and features in SQL Server Analysis Services and OLAP technologies. At the end of this module, attendees will learn how to build a basic cube and understand the power that it provides for analysis. The Need Introduction to OLAP Fundamentals The UDM and Benefits Analysis Services Fundamentals Basic Components of the UDM: Data Sources, Data Source Views, Cubes, Dimensions Components of a SQL Server Analysis Services Database Building a basic cube Deployment and processingLAB: Building a cube

Module 10A: Customizing the UDM Through this module, attendees will understand the various customization options that enhace usability and performance of the UDM and allow them to extend the usefulness of the data analysis via a "single-version of the truth". The Need Introduction to the SSAS designer New design features in SSAS 2008 Dimension customization: Dimension properties, attributes and hierarchies (Customization scenario/how-to approach) Cube customization: Cubes, measure groups, measures (Customization scenario/how-to approach) Advanced SSAS database components: Dimension relationships, Calculations, KPI’s, LAB: Customizing the UDM

Module 10B: Customizing the UDM - Continued.

Day 4

Module 11A: Advanced Features of SSAS UDM This module covers some of the advanced administrative and security features for managing SSAS databases.Data ProcessingMeasure Group PartitionsProactive CachingAggregation and Usage Based Optimization (UBO)Role-based Security

Module 11B: Advanced Features of SSAS UDM - Continued

Module 12: Introduction to MDX This module provides and introduction to dhe Multi-Dimensional Expression (MDX) language for writing custom calculation and queries and building custom members.Overview of MDXLearning MDXMDX ConstructsMembers FunctionsMDX Query Syntax

Day 5Section 3 - Reporting Services

Module 13: Defining Reports in SQL Server Reporting Services This module will familiarize people with the design tools for designing reports and explain features available to customize report look and functionality. The NeedSSRS 2008 DesignerWhat’s New in SSRS 2008 for Report designReport Queries and ParametersReport layout and customizationReport InteractivityCharts and GraphsExtending Report FunctionalityLAB: Building a Simple Report

Module 14A: Customizing SSRS Reports This module looks at advanced customization options for enhanced report interactivity and funcionality.ExpressionsReport InteractivityReport FormattingAdvanced FunctionalityLAB: Customizing Reports

Module 14B: Customizing SSRS Reports - Continued

Day 6

Module 15: Adhoc Reporting with Report Builder This topic introduces the self-services capabilities in Reporting Services using Report Models and Report Builder clients.Ad-hoc reportingReport Builder ClientBuilding Report ModelsLAB: Building a Report ModelLAB: Creating a Report using Report Builder 2.0

Module 16: Advanced SSRS Features This module covers some of the management and security aspects of SSRS.Report AccessLinked ReportsSubscription and DeliveryData CachingReport HistoryUpgrade Considerations

Module 17: SSRS SharePoint Integration This module will review the reporting services integration with SharePoint including:Using the SharePoint SSRS web partsInstalling SSRS in SharePoint integrated modeDeploying reports and data sources to SharePointWorking with report parameters and security in SharePointReport Builder V3 integration with SharePoint