MSBI Online Training

SSIS

Module 1: Introduction to SQL Server 2005

Integration Services

This module introduces the role that Integration Services plays in extracting,

transforming, and loading data. This module also describes the tools that you can use to

build and manage Integration Services solutions.

• Overview of Integration Services Solutions

• Integration Services Tools

Module 2: Developing Integration Services

Solutions

This module provides an overview of the development tasks that are involved in

creating an Integration Services package. After completing this module, you will be able to

create a basic package.

• Creating an Integration Services

Solution

• Using Variables

• Building and Running a Solution

Module 3: Implementing Control Flow This module introduces the tasks and

precedence constraints that you can use to implement control flow in an Integration

Services package.

• Control Flow Tasks

• Control Flow Precedence Constraints

• Control Flow Containers

Module 4: Implementing Data Flow

This module describes the data flow sources, transformations, and destinations that you can use to implement a data flow task in an Integration Services control flow. It also explains how to use data flow paths to direct valid and invalid rows through the data flow.

• Data Flow Sources and Destinations

• Data Flow Transformations

• Data Flow Pipeline

Module 5: Implementing Logging

This module discusses how to use logging in an Integration Services package, and explains how to configure and use logging providers to generate information about a package’s execution.

• Overview of Integration Services Logging

• Implementing Logging

Module 6: Debugging and Error Handling

This module describes how to debug Integration Services packages by using the debugging tools in Business Intelligence Development Studio. It then explains how to implement error-handling logic in an Integration Services package.

• debugging a Package

• Implementing Error Handling

Module 7: Implementing Checkpoints and

Transactions

This module explains what checkpoints are and how to implement them. It then discusses

transactions, and describes how you can implement transactional data access logic in an

Integration Services package.

• Implementing Checkpoints

• Implementing Transactions

Module 8: SSIS Administration.

This module discusses how to create Package Configurations and how to deploy Integration

Services packages to production servers. Package Configurations

• Deploying Packages

• Managing Packages

• Securing Packages

Scheduling a Package

SSRS

Module 1: Introduction to Microsoft SQL

Server Reporting Services This module introduces the role that Reporting Services plays in an organization’s reporting life cycle, the key features offered by Reporting Services, and the components that make up the Reporting Services architecture.

Overview of SQL Server Reporting Services

Installing Reporting Services Reporting Services Tools

Module 2: Authoring Reports

This module introduces the fundamentals of report authoring, including

configuring data sources and data sets, creating tabular reports, summarizing data,

and applying basic formatting.

 Creating a Basic Table Report

 Formatting Report Pages

Calculating Values

Interactive Navigation

Displaying Data

Module 3: Manipulating Data Sets

This module explores data sets to a greater depth, including the use of alternative data sources and interacting with a data set through the use of parameters. Students learn how to dynamically modify the data set underlying a data region by allowing parameters to be sent to the underlying query. They also learn to use best practices to implement static and dynamic parameter lists when interacting with queries and stored procedures.

 Defining Report Data

 Using Parameters and Filters

 Using Parameter Lists

Module 4: Using Report Models

This module describes how to create a report model so that business users can create their own reports without using the full Report Designer development environment. Students also learn how to use Report Builder to create a report from a report model.

Creating Report Models Using Report Builder

Module 5: Publishing and Executing Reports This module explains the various options you can use to publish reports to the report server and execute them.

Publishing Reports

Executing Reports

Creating Cached Instances

Creating Snapshots and Report History

Module 6: Using Subscriptions to Distribute

Reports

This module describes how to implement subscriptions so that you can distribute reports either automatically by e-mail or by publishing reports to a shared folder.

Introduction to Report Subscriptions

Creating Report Subscriptions

Managing Report Subscriptions

Module 7: SSRS Administration

This module discusses how to administer the Reporting Services server, how to monitor and

optimize the performance of the report server, how to maintain the Reporting Services

databases, and how to keep the system secure.

 Server Administration

 Performance and Reliability Monitoring

 Administering Report Server Databases

 Security Administration

Module 8: Programming Reporting Services

[.NET APP]

This module explains how to query Reporting Services information programmatically and how to automate report management tasks.

Students also learn how to render reports without relying on Report Manager, and how you

can extend the feature set of a report server by creating custom code.

Querying for Server Information Using a

Web Service Automating Report Management

Rendering Reports Creating Custom Code

SSAS

MODULE 1:

Introduction to Analysis Services

This module introduces the role that Analysis Services plays in an organization’s, the

key features offered by Analysis Services, and the components that make up the Analysis Services architecture

 OLTP, DWH

 OLAP TYPES

 SSAS Architecture

 Dimension Tables

 Fact tables

 Cubes

 Analysis Services Tools

MS – BI

Module 2:

Cube Design process and Concepts This module introduces the role that Cube plays

in Analysis Services, and the components that make up the Analysis Services Cube.

 Dimensions

 Measure Groups

 Creating simple calculations

 Aggregations and

Hierarchies

 Dimension Relationships

 Translations

 Perspectives

Module 3:

Advanced Cube Design Process This module introduces Advanced Methods like KPI,

Actions and Write back that make up the Analysis Services Cube.

 MDX introduction and Queries

 Implementing KPI

 Implementing Actions

 Using Write back

Module 4:

SSAS Administration

This Module provides understanding of production management activities like

security, deploying, processing and scheduling Analysis tasks

 Applying Security Roles

 Levels of Security

 VLDB with partitioning

 OLAP Processing

 Monitoring Cube Activity

 Deployment and Scheduling

 Planning for Disaster and Recovery

 Performance Tuning SSAS