Skip to Content

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

expand or collapse the menu Accessibility

expand or collapse the menu Web Development

expand or collapse the menu Adobe / Macromedia Web

expand or collapse the menu Programming

expand or collapse the menu Databases

expand or collapse the menu Professional Courses

expand or collapse the menu Adobe

expand or collapse the menu Microsoft SharePoint

expand or collapse the menu Technical

expand or collapse the menu Geographic (GIS)

expand or collapse the menu Microsoft Office

Training Resources

Current Training Schedule

Class Registration Form

Get Adobe Reader

SQL Server 2005 Analysis Services

3 day course

View Detailed Outline in PDF Format
Get Adobe Reader

In this course, you will learn how to use Microsoft SQL Server 2005 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 2005 developer the tools to build data warehousing and decision support system solutions.  This course also provides information on end-user tools including Microsoft Excel 2003/2007 and Microsoft SQL Server 2005 Reporting Services.  Implementing SSAS solutions have shown to boost data retrieval and report generation from SQL Server by up to 1000%.

Course Topics:

(for a full detailed outline, visit our PDF link above)

Microsoft BI

  • Core concept – BI is the cube or UDM
  • SQL Reporting Services with cube as data source

OLAP Modeling

  • Modeling source schemas: stars and snowflakes
  • Understanding dimensional modeling
  • Understanding fact (measures) and cube modeling
  • Other types of modeling (data mining, etc.)

Using SSAS in BIDS

  • Understanding the development environment
  • Creating Data Sources and Data Source Views
  • Creating cubes
  • Refining dimensions and measures in BIDS

Intermediate SSAS

  • KPIs
  • Perspectives
  • Translations: cube metadata & currency localization
  • Actions: regular, drill-through and reporting

Advanced SSAS

  • Using multiple fact tables
  • Modeling intermediate fact tables
  • Modeling dimensions
  • Modeling changing dimensions
  • Using the Add Business Intelligence Wizards

Cube Storage and Aggregation

  • Storage topics: basic aggregations, MOLAP
  • Advanced Storage Design: MOLAP/ROLAP/HOLAP
  • Partitions: relational & Analysis Services partitions
  • Customizing Aggregation Design
  • Rapidly changing dimensions / ROLAP dimensions
  • Proactive Caching
  • Cube processing options

Beginning MDX

  • Basic syntax and common tasks
  • Using the MDX query editor
  • New MDX functions

Intermediate MDX

  • Adding calculated members
  • Adding scripts
  • Adding named sets
  • .NET Assemblies

SSAS Administration

  • Best practices – health monitoring
  • XMLA scripting (SQL Mgmt Studio)
  • Other Documentation methods
  • Security – roles and permissions
  • Disaster Recovery – backup and restore
  • Clustering – high availability

Introduction to Data Mining

  • What and why?
  • Using each of the 9 algorithms
  • Data Mining dimensions
  • Data Mining clients
  • Processing mining models

Introduction to Reporting Clients

  • Excel Pivot Tables
  • SQL RS & Report Builder
  • SPS RS web parts /.NET 2.0 report viewer controls
  • Business Scorecards 2005 & ProClarity

Integration with Office

  • SharePoint and AS
  • Report Center uses KPIs, Reports, Excel Web, Filter
  • Excel Services and AS (Web Services)