• 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

• Introduction to Microsoft SQL Server 2008 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

• 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 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:  
• Describe SQL Server Reporting Services and its Components.
• Create a Reporting Services report.
• Enhance a Reporting Service report.
• Create and manipulate data sets.
• Use report models to implement reporting for business users.
• Configure report publishing and execution settings.
• Implementing subscription for reports.
• Implement custom Reporting Services applications.