Enable Technology

SQL Server Analysis Services 

Microsoft SQL Server 2008 Analysis Services SSAS

Course Overview

In this two day course participants 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.

Duration: 2 day course

Course Content

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 Datbases
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 as a Data Mining Client
Review Microsoft Office SharePoint Server 2007

Email us about this courses

Telephone on 01952 305730