DW MSBI Contents

MS-BI (SSIS,SSAS,SSRS)

SSIS Objectives

* Plan data transfer and staging solutions for an ETL operation
* Plan an SSIS Solution
* Design and implement data flows
* Incorporate logging, error handling and reliability into a package
* Optimize an SSIS Solution
* Deploy an SSIS Solution

Contents:

Planning for ETL

* Identifying Data Sources and Destinations
* Evaluating Source Data
* Identifying Staging Requirements
* Lab: Planning an ETL Solution

Planning an SSIS Solution

* Planning Packages
* Planning Package Development
* Designing Package Control Flow
* Lab: Implementing SSIS Packages

Designing Data Flow

* Understanding Data Flow
* Designing Data Flow Operations
* Handling Data Changes
* Lab: Implementing Data Flow

Logging, Error Handling and Reliability

* Logging ETL Operations
* Handling Errors in SSIS
* Implementing Reliable ETL Processes with SSIS
* Lab: Implementing Reliable Packages

Optimizing an SSIS Solution

* Monitoring SSIS Performance
* Optimizing SSIS Packages
* Scaling Out SSIS Packages
* Lab: Optimizing Packages

Deploying and Operating an SSIS Solution

* Deploying SSIS Packages
* Operating an SSIS Solution
* Lab: Optimizing Packages

SSAS Objectives:

* Describe how SQL Server Analysis Services can be used to implement Analytical solutions
* Create multidimensional analysis solutions with SQL Server Analysis Services
* Implement dimensions in an Analysis Services solution
* Implement measures and measure groups in an Analysis Services solution
* Query a multidimensional Analysis Services solution
* Customize an Analysis Services cube
* Deploy and secure an Analysis Services database
* Maintain a multidimensional Analysis Services solution
* Implement Data Mining solution

Contents:

Introduction to Microsoft SQL Server 2005 Analysis Services

* Overview of Data Analysis Solutions
* Over of SQL Server 2005 Analysis Services
* Installing SQL Server 2005 Analysis Services

Creating Multidimensional Analysis Solution

* Developing Analysis Services Solutions
* Data Sources and Data Source Views
* Creating a Cube
* Lab: Creating a Multidimensional Analysis Solution

Working with Dimensions

* Configuring Dimensions
* Defining Hierarchies
* Sorting and Grouping Attributes
* Lab: Defining Dimensions

Working with Measures and Measure Groups

* Working with Measures
* Working with Measure Groups
* Lab: Configuring Measures and Measure Groups

Querying Multidimensional Analysis Solutions

* MDX Fundamentals
* Adding Calculations to a Cube
* Lab: Querying a Cube

Customizing Cube Functionality

* Implementing Key Performance Indicators
* Implementing Actions
* Implementing Perspectives
* Implementing Translations
* Lab: Customizing a Cube

Deploying and Securing an Analysis Services Database

* Deploying an Analysis Services Database
* Securing an Analysis Services Database
* Lab: Deploying and Securing an Analysis Services Database

Maintaining a Multidimensional Solution

* Configuring Processing Settings
* Logging, Monitoring and Optimizing an Analysis Services Solution
* Backing Up and Restoring an Analysis Services Database
* Lab: Maintaining an Analysis Services Database

Introduction to Data Mining

* Overview of Data Mining
* Creating a Data Mining Solution
* Validating Data Mining Models
* Lab: Implementing Data Mining

SSRS Objectives

* Describe SQL Server Reporting Services and its components
* Create a Reporting Services report
* Enhance a Reporting Services report
* Create and implement data sets
* Use report models to implement reporting for business users
* Configure report publishing and execution settings
* Implement subscriptions for reports
* Implement custom Reporting Services applications

Contents:

Introduction to Microsoft SQL Server Reporting Services

* Overview of SQL Server Reporting Services
* Reporting Services Tools
* Lab: Using Reporting Services Tools

Authoring Basic Reports

* Creating a Basic table Report
* Formatting Report Pages
* Calculating Values
* Lab: Creating a Simple Report

Enhancing Basic Reports

* Interactive Navigation
* Displaying Data
* Lab: Enhancing a Report

Manipulating Data Sets

* Defining Report Data
* Using Parameters and Filters
* Using Parameter Lists
* Manipulating Data Sets

Publishing and Executing Reports

* Executing Reports
* Creating Cached Instances
* Creating Snapshots and Report History
* Lab: Publishing and Executing Reports

Using Subscriptions to Distribute Reports

* Introduction to Report Subscriptions
* Creating Report Subscriptions
* Managing Report Subscriptions
* Lab: Implementing Subscriptions