Free Hands-On SQL Server Analysis Services 2008 Step-by-Step Training.

Microsoft SQL Server Analysis Services (SSAS) is a multidimensional data server that provides online analytical processing (OLAP) and data mining services.

SSAS - provides fast, intuitive, top-down analysis of large quantities of data built on this unified data model, which can be delivered to users in multiple languages and currencies.
SSAS - lets end users analyze data by using a host of tools such as Microsoft Office Excel, SQL Server 2008

Reporting Services (SSRS), SharePoint 2010, Custom-developed applications, and third-party

tools. This training seminars series focuses on the OLAP functionality of SSAS, we are going to cover the process of developing basic SSAS cubes, measures and dimensions as well as administration and maintenance.


From: February 09, 2010

To: March 16, 2010

Time: from 06:30 PM to 09:00 PM

Where Microsoft New England District

Street: 201 Jones Rd. 6 floor, MPR C,

City: Waltham

State: MA

Country: US

Course Objectives

Implement dimensions in a cube.

Implement measures in a cube.

Implement a data source view.

Configure dimension usage in a cube.

Implement custom logic in a cube by using MDX

Implement storage design in a cube.

Deploy SSAS databases and objects.

Implement processing options.

Configure permissions and roles in SSAS.

Install and maintain an SSAS instance.

Diagnose and resolve performance issues


Day 1 Introduction to MS SQL Server Analysis Services 2008

This session will introduce the major concepts of OLAP and how to build multidimensional data structures (cubes) using SQL Server 2008.

Day 2 SQL Server Analysis Services and Enterprise Data Warehousing.

In this session we will look at the architecture, design principles and common practices for creating scalable Data Warehouses, discuss Business Architecture and Frameworks as foundation of OLAP.

Day 3 Developing SSAS Cubes (Part 1)

This seminar focuses on the OLAP functionality of SSAS, exploring the process of developing basic SSAS cubes and

dimensions.

Step 1: Creating Data Sources and Data Source Views

Step 2: Creating and Modifying SSAS Cubes

Day 4 Developing SSAS Cubes (Part 2)

Step 3: Creating and Modifying Dimensions

Step 4: Creating Measure Groups and Measures

Day 5 Extending SSAS Cubes

This seminar starts by discussing attribute and dimension relationships. You will learn how to extend the Unified Dimensional Model (UDM) with KPIs, actions, translations, and perspectives. And after describing the MDX query fundamentals, the we will explore MDX calculated members and named sets.

Step 1: Defining User Hierarchies and Dimension Relationships

Step 2: Creating KPIs, Actions, Translations, and Perspectives

Step 3: Creating Calculations and Queries by Using MDX

Day 6 Managing SSAS Storage, Processing, and Deployment

This seminar provides comprehensive coverage of SSAS storage options and optimization techniques. It also explores ways to partition measure groups to improve processing and query performance and describes ways to design and optimize cube aggregations.

Step 1: Defining Measure Group Partitions and Aggregations

Step 2: Deploying SSAS Objects

Step 3: Processing SSAS Objects

Day 7 Securing and Administering SSAS

In this seminar, you will learn how to use SSAS security features to protect data in the

cube. In addition, you will learn how to back up and restore databases and monitor the

health and performance of your SSAS installations.

Step 1: Setting Up SSAS Server Security

Step 2: Managing SSAS High Availability, Backups, and

Step 3: Managing SSAS Tuning and Logging

Step 4: Tracing and Monitoring SSAS Instances


For more information please visit http://www.bostonbi.org/  and for events calendar http://bostonbi.org/Events/Calendar.aspx