Implementing SQL Server 2008 Analysis Services Solutions

This course is included in our On-demand training solution.


SQL Server 2008 Analysis Services gives you the opportunity to take the vast amount of information in your databases and analyze it so that you can use the information to improve your overall business. This course will introduce you to SQL Server 2008 Analysis Services and look at the benefits your business can gain from it. It will also introduce the different types of analysis services solutions that can be implemented and how analysis services is installed on SQL Server 2008. This course will also cover the logical and physical architecture of Multi-dimensional Analysis Services and introduce the tools that can be used to manage and deploy analysis services. In addition, the course will discuss data sources and data source views, including how to create, modify, and delete them. This course will also show how to create a SQL Server 2008 Analysis Services cube. This includes how you would use the Cube Designer, how you would define dimensions, define hierarchies, and define attributes. In addition, it includes a discussion on how to define measures, measure groups, and calculations. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.

Target Audience

IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developer


Familiarity with Microsoft .NET Framework; experience with SQL Server 2005 or SQL Server 2008 business intelligence components; experience performing queries on relational databases and using SQL Server Management Studio and Business Intelligence Development Studio

Expected Duration

150 min.

Course Objectives

Introducing SQL Server 2008 Analysis Services

  • recognize the features of SQL Server 2008 Analysis Services
  • install Analysis Services
  • Implementing Multidimensional Data in SSAS

  • recognize how to implement multidimensional data
  • Implementing Data Sources and Data Source Views

  • implement a data source
  • recognize how to use data source views
  • Creating an SSAS Cube

  • recognize how to create an SSAS cube
  • Defining Dimensions, Hierarchies, and Attributes

  • define dimensions, hierarchies, and attributes
  • Introducing Measures and Calculations

  • recognize how to use measures
  • use calculations
  • Creating Data Sources and Cubes in SSRS