SQL Server 2008/R2 MSBI (SSRS, SSIS, SSAS)

OUTLINE:

SQL Server 2008/2008 R2 Integration Services

Module 1: Introduction to SQL Server 2008 Integration Services

• Overview of SQL Server Integration Services
• Using Integration Services Tools
• Using the Import and Export Wizard
• Running an Integration Services Package

Module 2: Developing Integration Services Solutions

• Creating an Integration Services Solution
• Using Variables
• Building and Running a Solution

Module 3: Implementing Control Flow

• Control Flow Tasks
• Control Flow Precedent Constraints
• Control Flow Containers

Module 4: Implementing Data Flow

• Data Flow Sources and Destinations
• Basic Data Flow Transformations
• Advanced Data Flow Transformations
• Data Flow Paths

Module 5: Implementing Logging

• Overview of Integration Services Logging
• Enabling and Configuring Logging

Module 6: Debugging and Error Handling

• Debugging a Package
• Implementing Error Handling

Module 7: Implementing Checkpoints and Transactions

• Implementing Checkpoints
• Implementing Transactions

Module 8: Configuring and Deploying Packages

• Package Configurations
• Deploying Packages

Module 9: Managing and Securing Packages

• Managing Packages
• Securing Packages

SQL Server 2008/2008 R2 Analysis Services

Module 1: Introduction to Microsoft SQL Server Analysis Services

• Overview of Data Analysis Solutions
• Overview of SQL Server Analysis Services
• Installing SQL Server Analysis Services

Module 2: Creating Multidimensional Analysis Solutions

• Developing Analysis Services Solutions
• Creating Data Sources and Data Source Views
• Creating a Cube

Module 3: Working with Cubes and Dimensions

• Configuring Dimensions
• Defining Attribute Hierarchies
• Sorting and Grouping Attributes

Module 4: Working with Measures and Measure Groups

• Working With Measures
• Working with Measure Groups

Module 5: Querying Multidimensional Analysis Solutions

• MDX Fundamentals
• Adding Calculations to a Cube

Module 6: Customizing Cube Functionality

• Implementing Key Performance Indicators
• Implementing Actions
• Implementing Perspectives
• Implementing Translations

Module 7: Deploying and Securing an Analysis Services Database

• Deploying an Analysis Services Database
• Securing an Analysis Services Database

Module 8: Maintaining a Multidimensional Solution

• Configuring Processing
• Logging, Monitoring, and Optimizing an Analysis Services Solution
• Backing Up and Restoring an Analysis Services Database

Module 9: Introduction to Data Mining

• Overview of Data Mining
• Creating a Data Mining Solution
• Validating Data Mining Models

Microsoft SQL Server 2008/2008 R2 Reporting Service

Module 1: Introduction to Microsoft SQL Server Reporting Services

• Overview of SQL Server Reporting Services
• Installing Reporting Services
• Reporting Services Tools

Module 2: Authoring Basic Reports

• Creating a Basic Table Report
• Formatting Report Pages
• Calculating Values

Module 3: Enhancing Basic Reports

• Interactive Navigation
• Displaying Data

Module 4: Manipulating Data Sets

• Defining Report Data
• Using Parameters and Filters
• Using Parameter Lists

Module 5: Using Report Models

• Creating Report Models
• Using Report Builder

Module 6: Publishing and Executing Reports

• Publishing Reports
• Executing Reports
• Creating Cached Instances
• Creating Snapshots and Report History

Module 7: Using Subscriptions to Distribute Reports

• Introduction to Report Subscriptions
• Creating Report Subscriptions
• Managing Report Subscriptions

Module 8: Administering Reporting Services

• Reporting Server Administration
• Performance and Reliability Monitoring
• Administering Report Server Databases
• Security Administration
• Upgrading to Reporting Services 2008

Module 9: Programming Reporting Services

• Querying for Server Information Using a Web Service
• Automating Report Management
• Rendering Reports
• Creating Custom Code