Schedules:

There are currently no scheduled classes for this course.

 
  ProClarity Administrator Training (Analysis Services 2005)
 

3-Day (BI-PT1202K-301-EN)

Description
Who should attend
Prerequisites
Course Outline

Description

Administrators and developers create an analytic solution for their organization that encompasses both Microsoft and ProClarity applications. This course is for persons who want to correctly design and build AS 2005 cubes from scratch that will perform well being browsed by ProClarity applications. This training also includes the two-day Analyst Training course on the ProClarity Analytics Family.

Who should attend

  • Database Administrators
  • OLAP Administrators

Prerequisites

  • Understanding of relational database concepts (required)
  • Analysis Services 2000 or equivalent experience (recommended)

Course Outline

Day 1

Analysis Services 2005 Overview

  • Reviewing Analysis Services 2005 Architecture
  • Reviewing Data Warehouse Architecture
  • Review Analysis Services 2005 Features and Services
  • Lab/Discussion

Intro to Cube Design

  • Why Good Schema Design is Important
  • Creating a Database
  • Defining the Difference Between Data Source and Data View
  • Creating a Cube
  • Creating a Dimension
  • What a Measure Group Is
  • Creating a Perspective
  • Processing, Building and Deploying the Cube
  • Viewing a Cube with ProClarity
  • Lab/Discussion
Day 2

Advanced Cube Design

  • The Value of Keys
  • Creating Time Dimensions
  • Creating Business Intelligence Enhancements
  • Creating Actions
  • Reviewing Distinct Counts
  • Creating Linked Items
  • Browsing Data with ProClarity
  • Lab/Discussion

Calculations, Sets, and KPI’s

  • Creating Calculated Members
  • Leveraging Sets in your Solution
  • Creating KPIs to Add Visulation to your Data
  • How to use Business Logic Server to Maximize Cube Usefulness
  • Lab/Discussion
Day 3

Visualization with ProClarity

  • Viewing Analysis Services 2005 (w/Briefing Book and Notes)
  • Integrating ProClarity with Reporting Services
  • Analytics Server Administration
  • Lab/Discussion

Processing and Storage

  • Discussing and Creating Processing Options
  • Discussing and Diagramming Aggregations
  • Adjusting Usage-Based Optimization
  • Storage Modes
  • Evaluating Proactive Caching (Real Time)
  • Setting Up Writeback
  • Lab/Discussion

Security

  • Security Architecture
  • Instance-Level Security
  • Server Role (Fixed)
  • OLAP Database Administrator
  • Security Database Objects
  • Dimension Data Security
  • How ProClarity Works with the Analysis Services 2005 Security
  • Lab/Discussion

Cube Maintenance

  • Archiving and Restoring Cube Data
  • Managing Development to Production Environments
  • Using the Profiler to Monitor Query Access
  • Lab/Discussion