MSBI Online Training – Job Guarantee!!

Hi All,

Write an email for further enquiry:



Write an eMail :-> msbimaster4u @gmail.com
   
  Value Ads:

Ø The best coaching & the best material

Ø Just 45 days

Ø 24 X 7 phone support

Ø Free guidance till placement

Ø Real time scenarios

Ø Preparation for interviews

Syllabus:

Datawarehouse

Introduction to Data Warehousing Concepts

i. What is Data Warehousing?

ii. Need for Data warehousing

iii. OLTP Databases Vs DW

iv. Multi-dimensionality

v. Star Schema

SSIS

Module 1: Introduction o SQL Server 2008 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: 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 7: 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

SSRS

Module 1: Introduction to Microsoft SQL Server Reporting Services

This module introduces the role tha t 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

Using web service

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 Service s

databases, and how to keep the system secure .

 Server Administration

 Performance and Reliability Monitoring

 Administering Report Server Databases

 Security Administration

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

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