Ms-BI course training institute ameerpet hyderabad

MS-BI Course Training Institute in ameerpet,Hyderabad

Microsoft Business Intelligence (MSBI)

Introduction to BI

Introduction to data warehouse and data mart

Why MSBI ?

Working with BIDS-Business Intelligence

development audio

 

SQL Server Analysis Services (SSAS) Objectives:

Developing Analysis Services Solutions

Create cube

Schema-Star and Snow flacks

Create face table

Create Dimension Table

Configuring Dimensions

Defining Hierarchies

 

Measurers and Measure Groups

Working with Measurers

Working with Measure Groups

Implement dimensions in an Analysis

Services solution

Implement measurers and measure groups

in an Analysis Services solution

Customize an Analysis Services cube

Deploy and secure an Analysis Services database

 

Cube deploment, Browsing cube

Multiple Face table

 

Enhance Cube Functionality

KPI

Actions

Perspectives

Translations

 

SQL Server Reporting Services (SSRS)

Objectives :

 

Reporting Services Tools and Architecture

Configure reporting service-IIS

Creating reports-using cube, data source

Matrix report, Chart

Drill down, drill-through reports

Creating report parameters, drop down

parameters

Creating expression

Creating Groups

Deploying reports and data source

Report Snap shots and subscription

Standard and data driven subscription

Managing subscription

Report using Microsoft Excel

 

SQL Server Integration Services (SSIS)

Objectives :

Introduction to SQL Server Integration

Service

 

Working with SSIS packages

The import and export wizard for DBA’s

using SQL Server Management Studio

SSIS Package designer

Control Flow

Data Flow

Understanding Data Flow

Designing Data Flow Operations

Handling Data Changes

 

Error Handling

Logging, Error Handling and Reliability

Logging ETL Operations

Handling Errors in SSIS

Implementing Reliable

ETL Processes with SSIS

Overview of SQL Server Reporting Services

 

Contents : Planning for ETL

 

Identifying Data Sources and Destinations

Evaluating Source Data

Identifying Staging Requirements

Planning Packages

Planning Package Development

Designing Package Control Flow

 

Deploying and Operating an SSIS Solution

Deploying SSIS Packages

Operating an SSIS Solution

 

Multidimensional Expressions (MDX)

Basic MDX,

MDX Function

 

This section for the people who does not have

the prior SQL server experience or knowledge.

Introduction to SQL Server 2008

 

Overview and Introducing SQL Server

Installation Microsoft SQL Server 2005 –

including SSAS, SSIS, SSRS

SQL Server Management Studio

Building a Database

Create and alter tables

Create and alter indexes

Relations

T-SQL Basics

SELECT clause

FROM clause

WHERE clause

Using Joins-Different types of joins

ORDER BY

GROUP BY and HAVING

TOP N and TOP N%

OVER

Full-text search

DELETE

TRUNCATE TABLE

UPDATE

INSERT

SELECT INTO

 

Views, Stored Procedures, and Functions

Partioning and Joining Tables with Views

Updateable Views

Indexed Views

Information Schema Views

Catalog Views

Create and alter stored procedures

Functions

 

Triggers

INSERT triggers

DELETE triggers

UPDATE triggers

 

Security and SQL Server

Security modes and authentication

Database user accounts

Permissions

Database roles