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 II of this course is focused exclusively on Analysis Services.

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

• Use Analysis Services management features to create a secure, available environment
• Find and fix the root cause of Analysis Services performance issues
• Create more efficient MDX calculations and queries
• Leverage data mining technologies

efst á síðu

Prerequisites:

Basic experience Analysis Services.

efst á síðu

Length: 2 days

efst á síðu

Course Layout:

Analysis Services Administration

• Understanding Processing Options
• Using Database Synchronization
• Securing Analysis Services

efst á síðu

Analysis Services Performance

• Performance Troubleshooting
• Solving Performance Problems with Better Cube and Dimension Design
• Managing Aggregations
• Managing Partitions

efst á síðu

Analysis Services Calculations and Queries

• Understanding MDX Improvements in Analysis Services 2005
• Working with Time Calculations in MDX
• Improving Your MDX Queries
• Working with MDX Scripts

efst á síðu

Analysis Services Data Mining

• Building Mining Models
• Using Excel Add-Ins for Data Mining
• Integrating Data Mining into Business Intelligence Solutions

efst á síðu