MCTS SQL Server 2008 Business Intelligence Bootcamp
Course Fee: £2990.00
Course Outline
Implementing an SSIS Solution
- Implement control flow.
- Implement data flow.
- Implement dynamic package behavior by using property expressions.
- Implement package logic by using variables.
- Implement package configurations.
- Implement auditing, logging, and event handling.
- Extend SSIS packages by using .NET code.
Configuring, Deploying, and Maintaining SSIS
- Install and maintain SSIS components.
- Deploy an SSIS solution.
- Manage SSIS package execution.
- Configure SSIS security settings.
- Identify and resolve issues related to SSIS solution deployment.
Implementing an SSAS Solution
- Implement dimensions in a cube.
- Implement measures in a cube.
- Implement a data source view.
- Configure dimension usage in a cube.
- Implement custom logic in a cube by using MDX.
- Implement data mining.
- Implement storage design in a cube.
Configuring, Deploying, and Maintaining SSAS
- Configure permissions and roles in SSAS.
- Deploy SSAS databases and objects.
- Install and maintain an SSAS instance.
- Diagnose and resolve performance issues.
- Implement processing options.
Implementing an SSRS Solution
- Implement report data sources and datasets.
- Implement a report layout.
- Extend an SSRS solution by using code.
- Create an SSRS report by using an SSAS data source.
- Implement report parameters.
- Implement interactivity in a report.
- Implement report items.
- Embed SSRS reports in custom applications.
Configuring, Deploying, and Maintaining SSRS
- Configure report execution and delivery.
- Install and configure SSRS instances.
- Configure authentication and authorization for a reporting solution.
- Deploy an SSRS solution.
- Configure SSRS availability.
|
|
|
