Course Details

Previous Page


Implementing SQL Server 2008 Analysis Services Solutions


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
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

Prerequisites
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 (hours)
2.5

Lesson Objectives

Implementing SQL Server 2008 Analysis Services Solutions

  • recognize the features of SQL Server 2008 Analysis Services
  • install Analysis Services
  • recognize how to implement multidimensional data
  • implement a data source
  • recognize how to use data source views
  • recognize how to create an SSAS cube
  • define dimensions, hierarchies, and attributes
  • recognize how to use measures
  • use calculations
  • create a data source and data source view
  • implement a SQL Server Analysis Services cube
  • Course Number:
    md_mqbm_a07_it_enus