Microsoft SQL Server 2008 Business Intelligence

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

Module 10: Introduction to SQL Server 2008 Integration Services

• Overview of SQL Server Integration Services
• Using Integration Services Tools

Module 11: Developing Integration Services Solutions

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

Módulo 12: Implementing Control Flow

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

Módulo 13: Implementing Data Flow

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

Módulo 14: Implementing Logging

• Overview of Integration Services Logging
• Enabling and Configuring Logging

Módulo 15: Debugging and Error Handling

• Debugging a Package
• Implementing Error Handling

Module 16: Implementing Checkpoints and Transactions

• Implementing Checkpoints
• Implementing Transactions

Module 17: Configuring and Deploying Packages

• Package Configurations
• Deploying Packages

Module 19: Managing and Securing Packages

• Managing Packages
• Securing Packages

Module 20: Introduction to Microsoft SQL Server Reporting Services

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

Module 21: Authoring Basic Reports

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

Module 22: Enhancing Basic Reports

• Interactive Navigation
• Displaying Data

Module 23: Manipulating Data Sets

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

Module 24: Using Report Models

• Creating Report Models
• Using Report Builder

Module 25: Publishing and Executing Reports

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

Module 26: Using Subscriptions to Distribute Reports

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

Module 27: Administering Reporting Services

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

Module 28: Programming Reporting Services

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