This Boot Camp will prepare qualified Microsoft professionals to earn the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008 Business Intelligence certification. This program is truly dual purpose: for cutting-edge skills development, we provide you with expert instruction and our Intense School brand of hands-on Labs that are accelerated and based on real-world scenarios; for test-preparation, you will practice sample question and take simulated exams using Intense Schools time-test proprietary practice exams.

• Describe how SQL Server Analysis Services can be used to implement analytical solutions.
  
• Implement logging in an Integration Services package.
  
• Create multidimensional analysis solutions with SQL Server Analysis Services.
  
• Debug and implement error handling in an Integration Services package.
  
• Implement Dimensions in an Analysis Services solution.
  
• Implement checkpoints and transactions in an Integration Services package
  
• Implement measures and measure groups in an Analysis Services solution.
  
• Deploy an Integration Services package.
  
• Query a multidimensional Analysis Services solution.
  
• Manage and secure and Integration Services package.
  
• Customize an Analysis Services Cube.
  
• Describe SQL Server Reporting Services and its components.
  
• Deploy and Secure an Analysis Services Database.
  
• Create a Reporting Services report.
  
• Maintain a Multidimensional Analysis Services Solution.
  
• Enhance a Reporting Services report.
  
• Implement a Data Mining solution.
  
• Create and manipulate data sheets.
  
• Describe SQL Server Integration Services and its tools.
  
• Use report models to implement reporting for business users.
  
• Create an Integration Services package.
  
• Configure report publishing and execution settings.
  
• Implement control flow in an Integration Services package.
  
• Implement subscriptions for reports.
  
• Implement data flow in an Integration Services package.
  
• Administer Reports Services
  
• Implement custom Reporting Services applications.

• Introduction to Microsoft® SQL Server 2008 Analysis Services
  
• Overview of Data Analysis Solutions
  
• Overview of SQL Server 2008 Analysis Services
  
• Installing SQL Server 2008 Analysis Services Creating Multidimensional Analysis Solutions
  
• Developing Analysis Services Solutions
  
• Data Sources and Data Source Views
  
• Creating a Cube Working with Dimensions
  
• Configuring Dimensions
  
• Defining Hierarchies
  
• Sorting and Grouping Attributes Working with Measures and Measure Groups
  
• Working with Measures
  
• Working with Measure Groups Querying Multidimensional Analysis Solutions
  
• MDX Fundamentals
  
• Adding Calculations to a Cube Customizing Cube Functionality
  
• Implementing Key Performance Indicators
  
• Implementing Actions
  
• Implementing Perspectives
  
• Implementing Translations Deploying and Securing an Analysis Services Database
  
• Deploying an Analysis Services Database
  
• Securing an Analysis Services Database Maintaining a Multidimensional Solution
  
• Configuring Processing Settings
  
• Logging Monitoring, and Optimizing an Analysis Services Solution
  
• Backing Up and Restoring and Analysis Services Database Introduction to Data Mining
  
• Overview of Data Mining
  
• Creating a Data Mining Solution
  
• Validating Data Mining Models Introduction to SQL Server 2008 Integration Services
  
• Overview of Integration Services Solutions
  
• Integration Services Tools Developing Integration Services Solutions
  
• Creating an Integration Services Solution
  
• Using Variables
  
• Building and Running a Solution Implementing Control Flow
  
• Control Flow Tasks
  
• Control Flow Precedence Constraints
  
• Control Flow Paths Implementing Date Flow
  
• Data Flow Sources and Destinations
  
• Data Flow Transformations
  
• Data Flow Paths Implementing Logging
  
• Overview of Integration Services Logging
  
• Implementing Logging Debugging and Error Handling
  
• Debugging a Package
  
• Implementing Error Handling Implementing Checkpoints and Transactions
  
• Implementing Checkpoints
  
• Implementing Transactions Deploying Packages
  
• Package Configurations
  
• Deploying Packages Managing and Securing Packages
  
• Managing Packages
  
• Securing Packages Introduction to Microsoft® SQL Server Reporting Services
  
• Overview of SQL Server Reporting Services
  
• Installing Reporting Services
  
• Reporting Services Tools Authoring Basic Reports
  
• Creating a Basic Table Report
  
• Formatting Report Pages
  
• Calculating Values Enhancing Basic Reports
  
• Interactive Navigation
  
• Displaying Data Manipulating Data Sets
  
• Defining Report Data
  
• Using Parameters and Filters
• Using Parameter Lists Using Report Models
  
• Creating Report Models
  
• Using Report Builder Publishing and Executing Reports
  
• Publishing Reports
  
• Executing Reports
  
• Creating Cached Instances
  
• Creating Snapshots and Report History Using Subscription to Distribute Reports
  
• Introduction to Report Subscriptions
  
• Creating Report Subscriptions
  
• Managing Report Subscriptions Administering Reporting Services
  
• Server Administration
  
• Performance and Reliability Monitoring
  
• Administering Report Server Databases
  
• Security Administration Programming Reporting Services
  
• Querying for Server Information Using a Web Service
  
• Automating Report Management
  
• Rendering Reports
  
• Creating Custom Code