Course Summary:

Deeper than traditional introductory courses for SQL Server 2005 business intelligence technologies, this course teaches students how and when to implement advanced techniques, how to troubleshoot solution performance, and how to secure solutions properly. Part I of this course focuses on Integration Services and Reporting Services.

By the end of this course, students will understand how to:

• Create flexible, reusable Integration Services packages
• Improve Integration Services package management by tracking of package activity with auditing and logging of errors and execution details
• Find and correct Integration Services performance bottlenecks
• Secure Integration Services packages in production
• Solve challenging report design problems
• Create better report models to support ad hoc reporting
• Use MDX and DMX queries effectively with Reporting Services
• Troubleshoot performance and security issues with Reporting Services

efst á síðu

Prerequisites:

Basic experience with Integration Services and Reporting Services.

efst á síðu

Length: 3 days

efst á síðu

Course layout:

Advanced Integration Services

• Working with Script Tasks and Script Components
• Data Cleansing
• Using Configurations for Package Flexibility
• Adding Audit Processes to Packages
• Performance Troubleshooting
• Managing Package Security

efst á síðu

Advanced Reporting Services

• Report Design Tips and Tricks
• Reporting with Analysis Services Data
• Building Report Models
• Configuring Security Correctly
• Performance Troubleshooting

efst á síðu