MSBI

Introduction to MSBI

What is BI and MSBI

Importance of MSBI in the current Enterprise

Installation Steps and requirements

ETL and OLAP Tools

Features of MSBI

SSIS – (SQL Server Integration Services)

What is SSIS and use in the enterprise?

SSIS Architecture

Control flow architecture

Data flow architecture

Data pipeline

Packages

Developing SSIS Solutions and Packages

SSIS Solution and Project Creation

SSIS Package Creation

Connection Managers and Shared Data Sources

Control Flow Tasks

Data Flow Task [ETL]

Variables and Expressions

.NET scripting in SSIS

Data Flow Tasks and Transformations

Objectives of Data Flow Tasks

Transformations

Aggregate Transformation

Merge Transformation

Merge Join Transformation

Union All Transformation

Multicast Transformation

Conditional Split Transformation

Lookup Transformation

Fuzzy Lookup Transformation

Derived Column Transformation

Copy Column Transformation

Data Conversion Transformation

Sort Transformation

Merge Vs. Union All

Control Flow Tasks

Working with Control Flow Tasks and Containers

For Each Loop

For Loop

File System Task

Execute SQL Task

Analytical Processing Task

Transfer Database Task

Backup Database Task

Sqlserver transformation Task

Agent Task

Script Task

Execute Package Task. Etc.

Errors and Debugging SSIS

Various ways of debugging SSIS Package

Data viewers

Configure Error output

Execution Logging

Logging, Events and Configurations

Various ways of Configuring SSIS Package

Using check points

Implementing Transactions

Logging ETL Operations and Log Providers

Various Events involved in the execution of Packages

Bottlenecks, Performance Tuning

Monitoring and Optimizing Packages

Various ways to identify bottlenecks

Tuning Source Tasks

Tuning Destination Tasks

Tuning in Package level and System Level

SSIS Administration

Various ways of Deploying SSIS Package

Configurations

Sql Server Deployment

Security

Manually Executing SSIS Package

Scheduling SSIS Package

Importing and Exporting Packages

SSAS – (SQL Server Analysis Services)

Dimensions

Facts

Data Sources

Data Source Views

Developing Cubes

Cube Designer

Partitions and Aggregations

Dimension Usage

Calculation and Kpis

Perspectives, Actions

Translations

Write-back feature

MDX Language

Axes, Slice

Tuple and Set

MDX Queries

MDX Expressions

MDX Scripts

SSAS Administration

Installation

Configuration

Deployment

Processing

Security

Backup and Restore

SSRS – (SQL Server Reporting Services)

What is SSRS, Need of Reporting Services

SSRS-2008 additional features

Enterprise Report Life Cycle

SSRS Administration and Management

Working with RS Configuration Tool

Report Manager/Server/Database Creation

Authenticating Manager/Server/Database

RS Server starting and stopping

Report Creation and Authoring

Working with various report facilities

Report Server Wizard

Report Server Project

Report Model Project

Report Builder

Creating different reports and managing

Table

Matrix

Chart

List

Gauge

Sub Report

Formatting

Map

Bar

Working with Reports Extensively

Creating a report by connecting to

OLAP cubes

RDMBS

XML Sources

Excel Sources

Stored Procedures

Creating Sub Report and using it

Working with

Sub Totals/Full Totals

Page Breaks

Page Footer/Header

Table Header/Footer

Sorting & Grouping

Applying Colors, Fonts etc

Working with Drill Down, Drill Through

Creating Drill Down & Through reports

Various ways to create and manipulate

Adhoc Reporting, Report Builder

Creating and working with report model

Report Builder and various options, features

Actions, Expressions & Variables

Implementing various Report Actions

Working with various expressions

Variables (Report and Group)

Calculated members, Query fields

Parameterised Reports

Passing Parameters

Non-Queried

Queried

Multivalued

Cascading Parameters

Publishing and Executing Reports

Executing the Reports

Creating cached Instances

Creating snapshots and report history

Creating Subscriptions & Optimization

Normal, Data Driven, Null Subscription

Email and File Share Delivery Tuning of SSRS, Components and Query