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

SQL Server 2008 End-to-End Business Intelligence Workshop

Choose your own date

INFORMATION COURSE OUTLINE

5-Day (BI-BIE2E08-201-EN)

Description

Audience

Prerequisites

Course Objectives

Course Outline

Download a PDF of this Outline

Other Versions of this Course:
SQL Server 2008 End-to-End Business Intelligence Workshop - Online

Description

Business intelligence solution 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 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 interested in learning how to implement Business Intelligence solution 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:

Describe the process of building a business intelligence solution and identify where and how SSAS fits into the process.

Create effective SSAS cubes complete with calculations, actions, aggregations, and more.

Design solutions in SSAS that are both scalable and secure.
Successfully manage and deploy SSAS cubes in a development/test/production environment.

Day 1

Module Intro 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 PracticeComponents an 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 Intro 02: Preparing Data for AnalyticsThis module provides and 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 NeedDimensional ModelingDimensional Modeling Concepts

Module SSIS 01: Introduction to SSISThis module introduces the various high-level features of SQL Server Integration Services and also introduces the development environment for SSIS.The NeedSSIS ComponentsChanges in SQL Server 2008Package ComponentsData Sources and ConnectionsLAB SSIS 01A: Creating a simple package

Module SSIS 02: 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 NeedPrimary Package Objects

Tasks, Containers and Precedence Constraints

VariablesSSIS ExpressionsLASB SSIS 02A: Implementing Workflows in Microsoft SSIS

Day 2

Module SSIS 03: 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 NeedData Flow components: Source and destination adapters, transformations, data flow paths.Highlight: ADO.NET supportBuilding data flowsHighlight: Lookup TransformLAB SSIS 03A: Processing Data using SSIS

Module SSIS 04: Loading Dimension Tables using SSISThis module covers the specific components of the data flow that are used to implements ETL processes to load dimension tables. The NeedSlowly changing Dimension ConceptHighlight: Slowly Changing Dimension TransformOther Dimension Load TypesHighlight: MERGE statement supportLAB SSIS 04A: Creating Dimension Load Packages

Module SSIS 05: Loading Fact Tables using SQL Server Integration ServicesThis module cover 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 SSIS 05A: Creating fact Load Packages

Module SSIS 06: Managing SQL Server Integration Services PackagesThis module covers management and deployment aspects of SSIS packages.LoggingConfiguration ManagementDeployingLAB SSIS 06A (Optional): Deploying and Scheduling SSIS Packages

Day 3

Module SSAS 01: Introduction to SQL Server Analysis ServicesThis module introduces key concepts and features in SQL server Analysis Services and OLAP technologies. As the end of this module, attendees will learn how to build a basic cube and understand the power that it provides for analysis.

The NeedIntroduction to OLAP FundamentalsThe UDM and BenefitsAnalysis Services FundamentalsBasic Component of the UDM: Data Sources, Data Source Views, cubes, DimensionsComponents of a SQK server Analysis Services DatabaseBuilding a basic cubeDeployment and processingLAB SSAS 01A: Building a cube

Module SSAS 02: Customizing the UDMThrough the module, attendees will understand the various customization options that enhance usability and performance of the UD; and allow them to extend the usefulness of the data analysis via a “single-version of the truth”.The NeedIntroduction to the SSAS designerNew design features in SSAS 2008Dimension customization: Dimension properties, attributes and hierarchies (Customization scenario/how-to approach)Cube customization: Cubes, cube dimensions, measure groups, measures (Customization scenario/how-to approach)Advanced SSAS database components: dimension relationships, Calculation, KPI’sLAB SSAS 02A: Customizing the UDM

Day 4

Module SSAS 03: Advanced Features of SSAS UDMThis module covers some of the afvanced administrative and security features for managing SSAS

Data Processing and StorageMeasure Groups PartitionsProactive CachingAggregation and Usage Based Optimization (UBO)Role-based Security

Module SSAS 04: Introduction to MDXThis module provide and introduction to the Multi-Dimensional Expression (MDX) language for writing custom calculation and queries and building custom members.Overview of MDXLearning MDX

MDX ConstructsMember FunctionsMDX Query Syntax

Module SSAS 05: [Optional]: Introduction to Data MiningThis module introduces Data Mining and provides and understanding of the business uses of data mining and also provides an overview of the data mining process.The NeedData Mining ProcessData Mining AlgorithmsChanges in SQL Server 2008Data Mining adds-ins in Excel 2007LAB SSAS 05A [Optional]: Building a Data Mining Model

Module SSRS 01: Introduction to SQL Server Reporting ServicesThis module will introduce the Reporting services, the architecture and components of SSRS. Additionally, we will look at the components of a Report and understand the features and functionality including new features in SSRS 2008.The NeedSSRS 2008Report FeaturesSSRS ArchitectureCore Components of SSRSReport Design ProcessReport ProcessingDeployment ScenarioReporting Services Security

Day 5

Module SSRS 02: Defining Reports using SQL Server Reporting ServicesThis module will familiarize people with the design tools for designing reports and explain features available to customize report look and functionality.

Report DesignerData Sources and DatasetsQuery and Report ParametersReport Objects

Data Regions

LAB SSRS 02A: Build a Simple Report

Module SSRS 03: Customizing SSRS ReportsThis module looks at advanced customization options for enhanced report interactivity and functionality.ExpressionsReport InteractivityReport FormattingAdvanced FunctionalityLAB SSRS 03A: Customizing Reports

Module SSRS 04: Ad-hoc Reporting with Report BuilderThis topic introduces the self-services capabilities in Reporting services using Report Models and Report Builder clients.Ad-hoc reportinReport Builder clientBuilding Report ModelsLAB SSRS 04A: Building a Report ModelLAB SSRS 04B: Creating a Report using Report Builder 2.0

Module SSRS 06: Tying it all togetherThis is a wrap-up module that does a very quick overview of the topics we covered in the class.Module SSRS 05: Advanced SSRS FeaturesThis module covers some of the management and security aspects of SSRSReport AccessLinked ReportsSubscriptions and DeliveryData CachingReport HistoryMonitoringSecurity ConsiderationsUpgrade Considerations

5-Day (BI-BIE2E08-201-EN)

Other Versions of this Course:SQL Server 2008 End-to-End Business Intelligence Workshop - Online

Description

Prerequisites

Other Versions of this Course:
SQL Server 2008 End-to-End Business Intelligence Workshop - Online