SQL Server 2005/2008 Analysis Services (SSAS)

Level:
Beginner-to-intermediate

Audience:
Data architects, business intelligence/data warehouse specialists, DBAs and SQL Server 2005 administrators.

Prerequisites:
Completion of our course Data Warehousing Fundamentals and a working knowledge of SQL Server or equivalent knowledge.

Summary:
This scenario-based presentation details how to use the Business Intelligence Development Studio (BIDS) to develop and deploy Analysis Services projects and to use the SQL Server Management Studio to manage the databases derived from these projects.

Objectives:
Upon completion of this presentation, the delegate should be competent to:

• Build and deploy Analysis Services projects
• Use Data Sources/Data Source Views
• Design dimensions and measure groups for building, modifying and browsing OLAP cubes
• Enhance query performance via aggregations and user hierarchies
• Develop objects for handling unique financial analysis (e.g., KPIs)
• Tailor cubes using multi-dimensional expressions (MDX) and other design techniques
• Summarise SSAS good practices and performance techniques
• Etc.

Format:
Hands-on (about 70%).