ProClarity Administrator Training (Analysis Services 2005)

Choose your own date

INFORMATION COURSE OUTLINE

3 Days (BI-PT1202K-301-EN)

Description
Who should attend
Prerequisites

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

Who should attend Database AdministratorsOLAP Administrators

Who should attend Database AdministratorsOLAP Administrators

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

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

Who should attend

Database Administrators
OLAP Administrators

Who should attend

Database Administrators
OLAP Administrators

Prerequisites

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

Prerequisites

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