Thursday, October 1, 2009

AppDev Microsoft SQL Server 2008 Analysis Services

AppDev Microsoft SQL Server 2008 Analysis Services

AppDev Microsoft SQL Server 2008 Analysis Services SSAS DVD-iNKiSO
ENG | ISO | 980Mb

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, cube storage and aggregation designs 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 based upon measures and dimensions.

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

* Select a Modeling Tool
* 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
# Refine Dimensions and Measures

Intermediate SSAS
# Refine Attribute Relationships
# Learn how to Create Key Performance Indicators (KPIs)
# Discover how to Create Perpectives
# See how to Create Translations for Cubes and Dimensions
# Understand Currency Localization
# 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
# Work with Changing Dimensions
# Learn how to use the Business Intelligence Wizard
# Understand Writeback in Dimensions
# Review Semi-Additive Measures in OLAP Cubes
# Work with Time Intelligence
# Take a Look at Account Intelligence
# Manage Dimension, Hierarchy, Attribute and Cube Properties

Cube Storage and Aggregation
# Understand Basic Storage
# View Aggregation Designs
# Customize Aggregation Designs
# Understand Advanced Storage
# Implement Proactive Caching
# Use Relational and SSAS Partitions
# Customize Cube and Dimension Processing