Implementing and Maintaining SQL 2005 Analysis Services (SSAS)

Who should attend?

This course is for IT professionals and developers who need to implement analysis solutions by using Microsoft SQL Server 2005.

Delegates will be able to

• Describe how SQL Server Analysis Services can be used to implement analytical solutions
• Create multi-dimensional analysis solutions with SQL Server Analysis Services
• Implement dimensions in an Analysis Services Solution
• Implement measures and groups in an Analysis Services Solution
• Query a multidimensional Analysis Services solution
• Customise an Analysis Services cube

Prerequisites

Before attending this course, delegates must have

• Conceptual understanding of OLAP solutions
• Experience navigating the Microsoft Windows Server environment
• Experience with Windows services- including starting and stopping
• Experience creating service accounts and permissions
• Experience with Microsoft SQL Server including:
  • SQL Server Agent
  • SQL Server query language
  • SQL Server System tables.
  • SQL Server accounts