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

·       Publishing reports

·       Executing reports

·       Creating Cached instances

·       Creating Snapshots and Report History

Ø Using Subscriptions to Distribute Reports

·       Introduction to Report Subscriptions

·       Creating Report Subscriptions

·       Managing Report Subscriptions

Ø SSRS Administration

·       Server Administration

·       Performance and Reliability monitoring

·       Administering Report Server Databases

·       Security Administration

SSAS

Ø Introduction to Analysis Services

·       OLTP,DWH

·       OLAP TYPES

·       SSAS Architecture

·       Dimension Tables

·       Fact tables

·       Cubes

·       Analysis Services Tools

Ø Cube Design Process and Concepts

·       Dimensions

·       Measure groups

·       Creating Simple Calculations

·       Aggregations and Hierarchies

·       Dimensions Relationships

·       Transactions

·       Perspectives

Ø Advanced Cube Design Process

·       MDX introduction and Queries

·       Implementing KPI

·       Implementing Actions

·       Using Write back

Ø SSAS Administration

·       Apply Security Roles

·       Levels of Security

·       VLDB with partitioning

·       OLAP Processing

·       Monitoring Cube activity

·       Deployment and Scheduling

·       Planning for Disaster Recovery

·       Performance Tuning SSAS

Courses Offered in Our Training Institute:

Ø IBM Lotus Notes Domino Server Administration

Ø IBM Lotus Notes Development

Ø IBM Web Sphere Application Server Administration

Ø IBM Web Sphere Process Server Administration

Ø IBM Web Sphere MQ Administration

Ø Oracle Apps R12 HRMS

Ø Oracle Apps R12 HRMS  - Project

Ø Oracle Apps R12 Finical

Ø Oracle Fusion SOA, SOB,B2B

Ø Oracle DBA

Ø Obiee 11g

Ø Informatica

Ø Micorsoft Dynamics CRM

Ø Hyperion

Ø Android

Ø Sql Server DBA

Ø Tibco

Ø Tibco I Process

Ø Webmethods

Ø Siebel CRM, EAI

Ø Microstrategy

Ø PHP

Ø Oracle Apps R12 Technical

Ø SAP  Business Objects   & SD

Ø MS  Business Objects

www.futurepointtech.com