SQL Server 2008 Analysis Services (SSAS) Training in Cambridge

Enroll in or hire us to teach our SQL Server 2008 Analysis Services (SSAS) class in Cambridge, Massachusetts by calling us @303.377.6176. Like all HSG classes, SQL Server 2008 Analysis Services (SSAS) may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, SQL Server 2008 Analysis Services (SSAS) may be taught at one of our local training facilities.

Answers to Popular Questions:

 
Yes, this class can be tailored to meet your specific training needs.
Yes, we provide consulting services.
Yes, group discounts are provided.

Course Description

 
In this course, you will learn how to use Microsoft SQL Server 2008 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2008 developer the tools to build data cubes and forecasting solutions. This course also provides information on end-user tools including Microsoft Excel 2007, Office Visio 2007 Professional Edition, SQL Server Business Intelligence Development Studio (BIDS) Microsoft SQL Server 2005 Integrated Services and Reporting Services.
Course Length: 4 Days
Course Tuition: $2395 (US)

Prerequisites

This course does not require any prior experience with Analysis Server 2008. It is assumed that students have working experience with SQL Server 2005 or 2008; basic relational database concepts (e.g. tables, queries, and indexing); data transformation services; Excel 2007; and SharePoint Server 2007.

Course Outline

 

What is Microsoft Business Intelligence

  • Define Business Intelligence
  • Understand the Cube Structure
  • Deploy and View a Sample Cube
  • View a Cube by using Excel
  • View a Cube by using SQL Reporting Services

OLAP Modeling

  • Understand Basic OLAP Modeling (star schema)
  • Understand Dimensional Modeling (stars and snowflakes)
  • Understand Measure (fact) and Cube Modeling
  • Model with SQL Server Business Intelligence Development Studio (BIDS)

Using SSAS in BIDS

  • Understand the Development Environment
  • Create Data Sources
  • Create Data Source Views
  • Create Cubes by using the Cube Wizard

Intermediate SSAS

  • Learn how to Create Key Performance Indicators (KPIs)
  • Discover how to Create Perspectives
  • See how to Create Translations for Cubes and Dimensions
  • Review the three SSAS Action Object Types: Regular, Drillthrough, and Reporting

Advanced SSAS

  • Work with Multiple Fact Tables and the Dimension Usage Subtab in BIDS
  • Explore Advanced Dimension Types
  • Learn how to use the Business Intelligence Wizard
  • Understand Writeback in Dimensions
  • Review Semi-Additive Measures in OLAP Cubes

Cube Storage and Aggregation

  • View Aggregation Designs
  • Customize Aggregation Designs
  • Implement Proactive Caching
  • Use Relational and SSAS Partitions
  • Customize Cube and Dimension Processing

Introduction to MDX Queries

  • Understand Basic MDX Syntax
  • Use the MDX Query Editor in SSMS
  • Understand Common MDX Functions and Tasks
  • Review MDX Functions New to SSAS 2008

MDX Expressions

  • Understand the Calculation Subtab
  • Learn how to add Calculated Members
  • Explore how to add MDX Script Commands
  • Discover how to add .NET Assemblies

Introduction to Data Mining

  • Understand Data Mining Concepts
  • Review the Algorithms that SSAS Includes
  • Consider Data Mining Clients
  • Understand Mining Structure Processing

SSAS Administration

  • Implement SSAS Security
  • Implement XMLA Scripts in SSMS
  • Deploy and Synchronize Databases
  • Understand SSAS Database Backup and Restore

Advanced Administration and Optimization

  • Implement SSIS to Manage SSAS Databases
  • Explore Clustering
  • Explore Scalability Options
  • Understand Performance Tuning and Optimization

Introduction to SSAS Clients

  • Design Reports using Reporting Services
  • Design Reports by using Report Builder
  • Implement Excel 2007 Pivot Tables and Charts
  • Use Excel 2007 Pivot Tables and Charts
  • Review Microsoft Office SharePoint Server 2007

Course Directory [training on all levels]

Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.