Home > SQL Server > SQL Server 2005/2008/2008 R2 Analysis Services (SSAS)

SQL Server 2005/2008/2008 R2 Analysis Services (SSAS)

Course Code:	SQSSAS
Duration:	3 days
Level:	Beginner-to-intermediate
Audience:	Data architects, business intelligence/data warehouse specialists, DBAs and SQL Server 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 Create Key Performance Indicators (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%).
Detailed Outline

Course Schedule