Microsoft Certified Solutions Expert: Business Intelligence 2008 Training

• Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
• Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
• Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

• Use SQL Server Analysis Services to create, query, customize, implement, and maintain multidimensional analysis solutions
• Implement a Data Mining solution
• Use SQL Server Integration Services and its tools to create, debug,  manage, and implement Integration Services package
• Implement  security in an Integration Services package by providing checkpoints and transactions
• Use SQL Server Reporting Services to create, enhance, and administer reporting Services report
• Configure and implement custom Reporting Services applications

• Database Professionals
• Business Intelligence Developers/Professionals
• Data Analysts
• ETL Professionals
• Reporting Engineers

• Basic understanding of OLAP solutions
• Exposure to create reports in MS Access, Crystal Reports, or another third party reporting products
• Hands-on enterprise data import and export scenarios
• Practical knowledge on the Microsoft Windows Server environment, Microsoft SQL Server, and Windows services (starting and stopping)

Course 6234: Implementing and Maintaining Microsoft® SQL Server™ 2008 Analysis Services

• 1. Introduction to Microsoft SQL Server Analysis Services
  • Overview of Data Analysis Solutions
  • Overview of SQL Server Analysis Services
  • Installing SQL Server Analysis Services
• 2. Creating Multidimensional Analysis Solutions
  • Developing Analysis Services Solutions
  • Creating Data Sources and Data Source Views
  • Creating a Cube
• 3. Working with Cubes and Dimensions
  • Configuring Dimensions
  • Defining Attribute Hierarchies
  • Sorting and Grouping Attributes
• 4. Working with Measures and Measure Groups
  • Working With Measures
  • Working with Measure Groups
• 5. Querying Multidimensional Analysis Solutions
  • MDX Fundamentals
  • Adding Calculations to a Cube
• 6. Customizing Cube Functionality
  • Implementing Key Performance Indicators
  • Implementing Actions
  • Implementing Perspectives
  • Implementing Translations
• 7. Deploying and Securing an Analysis Services Database
  • Deploying an Analysis Services Database
  • Securing an Analysis Services Database
• 8. Maintaining a Multidimensional Solution
  • Configuring Processing
  • Logging, Monitoring, and Optimizing an Analysis Services Solution
  • Backing Up and Restoring an Analysis Services Database
• 9. Introduction to Data Mining
  • Overview of Data Mining
  • Creating a Data Mining Solution
  • Validating Data Mining Models

Course 6235: Implementing and Maintaining Microsoft® SQL Server™ 2008 Integration Services

• 1. Introduction to SQL Server 2008 Integration Services
  • Overview of SQL Server Integration Services
  • Using Integration Services Tools
• 2. Developing Integration Services Solutions
  • Creating an Integration Services Solution
  • Using Variables
  • Building and Running a Solution
• 3. Implementing Control Flow
  • Control Flow Tasks
  • Control Flow Precedent Constraints
  • Control Flow Containers
• 4. Implementing Data Flow
  • Data Flow Sources and Destinations
  • Basic Data Flow Transformations
  • Advanced Data Flow Transformations
  • Data Flow Paths
• 5. Implementing Logging
  • Overview of Integration Services Logging
  • Enabling and Configuring Logging
• 6. Debugging and Error Handling
  • Debugging a Package
  • Implementing Error Handling
• 7. Implementing Checkpoints and Transactions
  • Implementing Checkpoints
  • Implementing Transactions
• 8. Configuring and Deploying Packages
  • Package Configurations
  • Deploying Packages
• 9. Managing and Securing Packages
  • Managing Packages
  • Securing Packages

Course 6236: Implementing and Maintaining Microsoft® SQL Server™ 2008 Reporting Services

• 1. Introduction to Microsoft SQL Server Reporting Services
  • Overview of SQL Server Reporting Services
  • Installing Reporting Services
  • Reporting Services Tools
• 2. Authoring Basic Reports
  • Creating a Basic Table Report
  • Formatting Report Pages
  • Calculating Values
• 3. Enhancing Basic Reports
  • Interactive Navigation
  • Displaying Data
• 4. Manipulating Data Sets
  • Defining Report Data
  • Using Parameters and Filters
  • Using Parameter Lists
• 5. Using Report Models
  • Creating Report Models
  • Using Report Builder
• 6. Publishing and Executing Reports
  • Publishing Reports
  • Executing Reports
  • Creating Cached Instances
  • Creating Snapshots and Report History
• 7. Using Subscriptions to Distribute Reports
  • Introduction to Report Subscriptions
  • Creating Report Subscriptions
  • Managing Report Subscriptions
• 8. Administering Reporting Services
  • Reporting Server Administration
  • Performance and Reliability Monitoring
  • Administering Report Server Databases
  • Security Administration
  • Upgrading to Reporting Services 2008
• 9. Programming Reporting Services
  • Querying for Server Information Using a Web Service
  • Automating Report Management
  • Rendering Reports
  • Creating Custom Code