MSBI Training @Bangalore

we are providing Complete Hands on training with Examples on SQL Server 2008 Business Intelligence[MSBI]

Module 1 – Introduction to ETL Techniques using Sql Server Integration Services

• Reviewing ETL Fundamentals
• Data Integration
• Business Scenarios
• SQL Server 2008 Data Integration
• Populating Dimension Tables
• Populating Fact Tables
• Introducing SSIS Components
• Architecture
• The Package
• Connection Manager
• Control Flow
• Containers
• Tasks
• Data Flow
• Data Preparation
• Process Communication
• SQL Server
• Analysis Services
• Database Maintenance
• Scripting
• Precedence constraints
• Variables

Module 2 – Developing a Query Driven E-mail Delivery System

• Data Flow
• Data Flow Sources
• Data Flow Destinations
• Data Flow Transformations
• Row
• Rowset
• Split and Join
• Business Intelligence (BI)
• Script
• Other

Module 3
Loading and Integrating Data from Multiple Sources
Module 4 – Designing ETL Packages

• Orchestrating the ETL Process
• Populating Dimension Tables
• Populating Fact Tables
• Slowly Changing Dimension Transformation

Module 5 –Important Features of Sql Server Analysis Services

• Solving Business Problems with SSAS 2005
• Introduction to Unified Dimension Model (UDM)
• Analysis Services components Overview
• Analysis Services components Demo
• Defining a data source view within an Analysis Services project by using BI Development Studio.
• Defining and Deploying a Cube
• Modifying Measures, Attributes and Hierarchies
• Named Queries and Named Calculations
• Storage options with SSAS 2005
• Defining Advanced Attribute and Dimension Properties
• Defining Relationships Between Dimensions and Measure Groups
• Defining Key Performance Indicators (KPIs)
• Defining Actions
• Defining Perspectives and Translations
• Defining Administrative Roles

Module 6 – SQL Server Reporting Services

• Introducing Reporting Services
• Who uses reports and why?
• Installing reporting services.
• Designing reports.
• Reporting Services Architecture
• Reporting Service lifecycle
• Reporting Services features – New features in SQL 2005
• Reporting Services Components
• Data Processing Extensions
• Reporting Services Web Services
• Report Designer
• Report Services Tools
• Designing Reports
• Using the Report Wizard
• Importing Reports
• Plan for Extensibility
• Report Items and Data Regions
• Subtotals
• Formatting
• Pagination Control
• Printing Considerations
• Designing Data Access
• Reporting for Relational Data
• Query Basics
• Filtering Techniques
• Advanced Report Design
• Designing a tabular report using table.
• Link and Drill Down/Through Reports.
• Charting
• Custom Fields
• Conditional Expressions
• Using Custom Code
• Designing for Mobility

Module 7 – Managing and Using the Report Manager

• Viewing Reports
• Searching and browsing for specific reports
• Configuring report viewing security
• Creating schedules and subscriptions
• Launching Report Builder for ad hoc reports
• Managing Reports Using Programs
• Professional SQL Reporting Service Manager
• Building the Visual Interface
• Adding a reference to the Web Service
• Filling the Treeview
• Credentials
• Displaying the Folder Contents
• Adding/Updating Folders
• Deleting an Item From a Folder
• Importing Report Definition Files
• Managing Security
• Report Scripting
• Command Line Utilities
• Automating Server and Report Management
• Reporting Services RS Utility
• Script Deployment
• Building a Script Development Harness
• Accessing Server Items
• Retrieving Reports
• Deploying Reports
• Logging Events
• URL Access and Programmatic Rendering
• Accessing Reporting Services Objects
• Reporting Services URL Parameters
• Passing Report Information through the URL
• Rendering through Windows
• Rendering to the Web
• Report Caching and Subscriptions
• Report Delivery
• Configuration Credentials for Data Sources
• Configuring Cached Reports
• Subscriptions

Module 8 – Report Definition Language

• What is RDL?
• Creating RDL
• Extending Reporting Services
• Security Extensions
• Rendering Extensions
• Extensible Report Designer Classes
• Common Extension Interfaces
• Creating a Custom Data Processing Extension
• Deployment Strategies
• Architecture Review
• Reporting Services Deployment Scenario
• System Requirements and Prerequisites
• Installation and Configuration
• Administrative Issues
• Approaching Solution Design
• Define the Business Program
• Solution Design
• Transactional and Decision Support Data
• Business Intelligence Process Lifecycle
• Architecting BI Solutions
• Reporting Solution Design
• Reporting Solution Development Environment

After Complettion of the Course :

• Interview Guidance Provided
• Mock Tests Conducted
• Mock Interviews
• Resume Preparation as per the standards
• Guidance for Microsoft Certification Exam

Fees Structure :

Rupees : 18,000/-

Duration : 15days [40 hours]