SQL Server 2005 Analysis Services (SSAS)

Course Code: SQSSAS
Duration: 4 days
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 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
  • Develop multidimensional cubes
  • Use Multidimensional Query (MDX) to access cubes
  • Use MDX expressions
  • Use MDX functions
  • Use Data Sources/Data Source Views
  • Design dimensions
  • Design cubes
  • And the like
Format: Lecture and hands-on (about 70%).
View full outline in PDF formatDetailed Outline

print  |  top of page