3-Day (BI-PT1202K-301-EN)
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