MS-BI

Microsoft – BI

Planning for ETL:

· Source Identify Data Sources and Destinations

· Evaluating Data

· Identify Staging Requirements

Lab: Planning an ETL Solutions

Planning SSIS Solutions:

· 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 Process 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

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.

Creating Multidimensional Analysis Solution

· Developing Analysis Service Solutions.

· Data Sources and Data Sources 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 Measure and Measure Groups

· Working with Measure.

· Working with Measure Groups.

Lab: Configuring Measure and Measure Groups

· 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 Service 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:

1. Describe SQL Server Reporting Services and its Components.

2. Create a Reporting Services report.

3. Enhance a Reporting Service report.

4. Create and manipulate data sets.

5. Use report models to implement reporting for business users.

6. Configure report publishing and execution settings.

7. Implementing subscription for reports.

8. Implement custom Reporting Services applications.