SSIS-OBJECTIVES:

1. Plan Data transfer and staging Solutions for and ETL operation.
2. Plan and SSIS Solution
3. Design and implement data flows
4. Incorporate logging, error handling, and reliability into a package.

SSAS-OBJECTIVES:

1. Describe how SQL Server Analysis Services can be used to implement Analytical Solutions.
2. Create multidimensional analysis solutions with SQL Server Analysis Services.
3. Implement dimensions in an Analysis Service Solution.
4. Implement, measure and measure group in an analysis Services Solution.
5. Query a multidimensional Analysis Services Solution.
6. Customize an Analysis Service cube.
7. Deploy and Secure an Analysis Service Database.
8. Maintain a multidimensional Analysis Service Solution.
9. Implement a Data Mining Solution.

SSRS-OBJECTIVES:

1. Describe SQL Server Reporting Services and its Components.
2. Create a Reporting Services report.
3. Enhance a Reporting Service report.
4. Create and manipulate data sets.
5. Use report models to implement reporting for business users.
6. Configure report publishing and execution settings.
7. Implementing subscription for reports.
8. Implement custom reporting Services applications.