Welcomes to eworldclasses - Microsoft Technologies - MSBI

HOME

ABOUT US

SERVICES

REGISTRATION

COURSES

ENQUIRY

PAYMENT

CONTACT US

LOGIN

Courses

Data Warehousing

SAP Technical

SAP Functional

SAP New Dimensional

Oracle

Testing Tools

Middleware Technologies

Siebel

Administration

Adobe Flex 3.0

Mainframes

Course :

Microsoft Technologies

Duration : 30 Hrs

Sub Course :

MS BI

Course Content :

MS BI

SSIS Objectives

Plan data transfer and staging solutions for an ETL operation
Plan an SSIS Solution
Design and implement data flows
Incorporate logging, error handling and reliability into a package
Optimize an SSIS Solution
Deploy an SSIS Solution

Contents:

Planning for ETL

Identifying Data Sources and Destinations
Evaluating Source Data
Identifying Staging Requirements
Lab: Planning an ETL Solution

Planning an SSIS Solution

Planning Packages
Planning Package Development
Designing Package Control Flow
Lab: Implementing SSIS Packages

Designing Data Flow

Understanding Data Flow
Designing Data Flow Operations
Handling Data Changes
Lab: Implementing Data Flow

Logging, Error Handling and Reliability

Logging ETL Operations
Handling Errors in SSIS
Implementing Reliable ETL Processes with SSIS
Lab: Implementing Reliable Packages

Optimizing an SSIS Solution

Monitoring SSIS Performance
Optimizing SSIS Packages
Scaling Out SSIS Packages
Lab: Optimizing Packages

Deploying and Operating an SSIS Solution

Deploying SSIS Packages
Operating an SSIS Solution
Lab: Optimizing Packages

SSAS Objectives:

Describe how SQL Server Analysis Services can be used to implement Analytical solutions
Create multidimensional analysis solutions with SQL Server Analysis Services
Implement dimensions in an Analysis Services solution
Implement measures and measure groups in an Analysis Services solution
Query a multidimensional Analysis Services solution
Customize an Analysis Services cube
Deploy and secure an Analysis Services database
Maintain a multidimensional Analysis Services solution
Implement Data Mining solution

Contents:

Introduction to Microsoft SQL Server 2005 Analysis Services

Overview of Data Analysis Solutions
Over of SQL Server 2005 Analysis Services
Installing SQL Server 2005 Analysis Services

Working with XML, Configuration, and HTTP Handlers

Describe XML and the Document Type Definition
Explain namespaces and schemas
Convert data to XML
Bind data with XML documents
Describe the ASP.NET configuration system
Explain the various configuration settings in ASP.NET
Describe HTTP handlers
Create HTTP handlers

Creating Multidimensional Analysis Solution

Developing Analysis Services Solutions
Data Sources and Data Source Views
Creating a Cube
Lab: Creating a Multidimensional Analysis Solution

Working with Dimensions

Configuring Dimensions
Defining Hierarchies
Sorting and Grouping Attributes
Lab: Defining Dimensions

Working with Measures and Measure Groups

Working with Measures
Working with Measure Groups
Lab: Configuring Measures and Measure Groups

Querying Multidimensional Analysis Solutions

MDX Fundamentals
Adding Calculations to a Cube
Lab: Querying a Cube

Customizing Cube Functionality

Implementing Key Performance Indicators
Implementing Actions
Implementing Perspectives
Implementing Translations
Lab: Customizing a Cube

Deploying and Securing an Analysis Services Database

Deploying an Analysis Services Database
Securing an Analysis Services Database
Lab: Deploying and Securing an Analysis Services Database

Maintaining a Multidimensional Solution

Configuring Processing Settings
Logging, Monitoring and Optimizing an Analysis Services Solution
Backing Up and Restoring an Analysis Services Database
Lab: Maintaining an Analysis Services Database

Introduction to Data Mining

Overview of Data Mining
Creating a Data Mining Solution
Validating Data Mining Models
Lab: Implementing Data Mining

SSRS Objectives

Describe SQL Server Reporting Services and its components
Create a Reporting Services report
Enhance a Reporting Services report
Create and implement data sets
Use report models to implement reporting for business users
Configure report publishing and execution settings
Implement subscriptions for reports
Implement custom Reporting Services applications

Contents:

Introduction to Microsoft SQL Server Reporting Services

Overview of SQL Server Reporting Services
Reporting Services Tools
Lab: Using Reporting Services Tools

Authoring Basic Reports

Creating a Basic table Report
Formatting Report Pages
Calculating Values
Lab: Creating a Simple Report

Enhancing Basic Reports

Interactive Navigation
Displaying Data
Lab: Enhancing a Report

Manipulating Data Sets

Defining Report Data
Using Parameters and Filters
Using Parameter Lists
Manipulating Data Sets

Publishing and Executing Reports

Executing Reports
Creating Cached Instances
Creating Snapshots and Report History
Lab: Publishing and Executing Reports

Using Subscriptions to Distribute Reports

Introduction to Report Subscriptions
Creating Report Subscriptions
Managing Report Subscriptions
Lab: Implementing Subscriptions