MS BI Course Contents

v Introduction to Microsoft Business Intelligence 2008

v Installing and using BI tools

v Configuring BI tools 

SSIS

Ø Introduction to SQL Server 2008 Integration Services

·       Over view of integration services solutions

·       Integration Services Tools

Ø Developing Integration Services Solutions

·       Creating an Integration Services Solution

·       Using Variables

·       Building And Running a Solution

Ø Implementing Control Flow

·       Control Flow Tasks

·       Control Flow Precedence Constraints

·       Control Flow Containers

Ø Implementing Data Flow

·       Data Flow Sources and Destinations

·       Data Flow Transformations

·       Data Flow Pipeline

Ø Implementing Logging

·       Overview of Integration Services Logging

·       Implementing Logging

Ø Debugging and Error handling

·       Debugging a Package

·       Implementing handling

Ø Implementing Checkpoints and Transactions

·       Implementing Checkpoints

·       Implementing Transactions

Ø SSIS Administration

·       Deploying Packages

·       Managing Packages

·       Securing Packages

·       Scheduling a Package

SSRS

Ø Introduction to Microsoft SQL Server Reporting Services

·       Over View of SQL Server Reporting Services

·       Installing Reporting Services Reporting Services Tools

Ø Authoring Reports

·       Creating a Basic Table Report

·       Formatting Report Pages

·       Calculating Values

·       Interactive Navigation

·       Displaying Data

Ø Manipulating Data Sets

·       Defining Report Data

·       Using parameters and Filters

·       Using Parameter Lists

Ø Publishing and Executing reports

Number of Views :