SQL Server 2000 OLAP For Developers (Program Details)
COURSE OUTLINE
Session 1
Section A: Introduction
CD Tour
Overview
OLAP Databases
Attributes and Benefits
Data Marts vs. OLAP
In SQL Server 2000
Data Mining
Storage Design
Section B: OLAP Model
Data Warehouse Design
Star Schema
Fact/Dimension Table
Snowflake Schema
Database Dimensions
Cube Measures
Data Sources
Cube Query
Section C: Analysis Services
Elements
Data Warehouse Solutions
Components/Architecture
Metadata Repository
Migrating Repository
OLAP Storage and Cubes
Database Organization
PivotTable Service
Section D: Analysis Manager
Overview
Menus
Details Pane
Section E: Create a Cube
Cube Wizard
Data Links & Measures
Dimension Wizard
Product Dimension
Employee Dimension
Time Dimension
Examine Data
Browse Data
Section F: Dimension Structure
Overview
Tree Diagram
Levels
Members
Levels vs. Members
Member Terms
Analysis Server Limits
Section G: Dimension Types
Shared Dimension
Private Dimension
Standard Dimension
Create a Dimension
Dimension Editor
Snowflake Dimension
Session 2
Section A: Properties
Basic Properties
Member Key Column
Member Name Column
Sorting Members
Member Uniqueness
Using SQL Expressions
Section B: More Properties
Ragged Dimensions
Building Levels
Hiding Members
Excluding Members
All Level
Default Member
Section C: Parent-Child Dimension
Overview
Leaf Members
Hierarchy Example
Set Up Dimension
Members With Data
Set Up/Edit Cube
Level Naming
Section D: Level Properties
Member Count
Key Data Properties
Client Levels
Section E: Hierarchies & Groupings
Multiple Hierarchies
Create a Hierarchy
Different Hierarchies
Grouping Solutions
Manual Grouping
Automated Grouping
Section F: Time Dimensions
Overview
Using Dimension Wizard
Using Dimension Editor
Using Time Tables
Properties
Fiscal Dates
Section G: Advanced Dimensions
Custom Rollups
Creating Rollups
Set Up Rollup Dimensions
Unary Operators
Member Properties
Create New Dimension
Add Member Property
Virtual Dimension
Section H: Introduction to Cubes
Cube Components
Accessing Cube Editor
Cube Editor Elements
Building a Cube
Private Dimensions
Validate and Process
Shared Dimensions
Section I: Measures
Measure Attributes
Measures Dimension
Add/Remove Measures
View Processing/Data
Basic Properties
Advanced Properties
Aggregate Function
Distinct Count Trick
Session 3
Section A: Derived Measures
Problems Overview
Problem Example
Incorrect Average
Minimum Average
Count Columns
Section B: Cube Properties
Fact Table Size
Visible
Default Measure
Disable a Property
Disabled vs. Visible
Section C: Storage Design
Storage Modes Overview
MOLAP
ROLAP
ROLAP Pros and Cons
HOLAP
Aggregations Overview
Aggregation Design
Section D: Storage Design Wizard
Overview
Aggregation Options
Run Process
Aggregation Structure
Redesign Storage Mode
Section E: Cube Optimization
Optimization Wizard
Query Log
Usage Analysis Query
Adding Aggregations
Aggregation Usage
Section F: Processing Dimensions
Overview
Shared Dimensions
Rebuilding Process
Rebuilding Example
Incremental Update
Private Dimensions
ROLAP Dimensions
Changing Dimensions
Section G: Methods of Cube Processing
Overview
Full Process
Run Full Process
Refresh
Run Refresh
Incremental Update
Run Incremental Update
Session 4
Section A: Optimizing Cube Processing
Processing Options
Implementing Optimization
Optimize Schema
Design Considerations
Optimize Server
Typical Errors
Section B: Creating a Partition
Partition Architecture
Partition Advantage
Partition Requirements
Remote Partitions
Designing Partitions
Current Partition
Add New Partition
Accessing Partitions
Section C: Advanced Partitions
Partition Filters
Other Advanced Settings
Merge Partitions
Merge Example
Section D: Virtual Cubes
Overview
Virtual Cube Design
Design for Combining
Create Virtual Cube
Measure Conflict
Combining Measures
Section E: Calculating Members
MDX Types
Member Names
Qualification
Create Member Names
Validating Names
Problem Member Names
Section F: Calculated Member Builders
Overview
Interface Tour
Value Expressions Box
Data List Box
Default Name
Build Correct Average
Section G: Function List Basics
Expression Elements
Member Information
Constants Expression
Function List Features
CurrentMember Function
Name and Level Functions
Level Function Example
Section H: Function List Basics (cont.)
Dimension Hierarchy
Parent / Ancestor
Differences / Properties
Val Function
Conditional Expressions
IIF Function
Combine Conditions
OR Operator
Session 5
Section A: Members, Tuples, and Sets
Overview
Dimensional Coordinates
Tuple Characteristics
Tuple Examples
Section B: Percent of a Total
Constant Tuple
Percentages
Constant Tuple Examples
Percent of Parent
IsEmpty Function
Section C: Growth Calculation
PrevMember Function
Growth Percent
Step-by-Step Approach
ParallelPeriod Function
Section D: More Calculated Members
MDX Sets/Expressions
PeriodsToDate
Calculated Members
Solve Order
Solve Order Example
Section E: Cube Features
Actions Feature
Create an Action
Using Action Wizard
Drillthrough Feature
Writeback Feature
Section F: Security
OLAP Administrators
User Security
Database Roles
Database Role Manager
Security Dimension
Cube Role Manager
Advanced Cell Security
Section G: Deploying a Database
Copy and Paste Function
Function Example
Archive Database
Restore Database
Section H: Microsoft Excel and OLAP
PivotTables Overview
Connecting to OLAP
Report Design
Axis Dimensions
Local Cube
Save As Web Page
Return To Main Product Page
Price: £349.00
(incl. VAT and Delivery)
for Single User Licence