| Session 1
Section A: Introduction
· CD Tour
· OLAP Databases
· Attributes & 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 & Cubes
· Database Organization
· PivotTable Service
Section D: Analysis Manager
· 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
· 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
· 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
· 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 & 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 & Cons
· HOLAP
· Aggregations Overview
· Aggregation Design
Section D: Storage Design Wizard
· 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
· Shared Dimensions
· Rebuilding Process
· Rebuilding Example
· Incremental Update
· Private Dimensions
· ROLAP Dimensions
· Changing Dimensions
Section G: Methods of Cube Processing
· 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
· 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
· 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 & 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, & Sets
· 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 & Paste Function
· Function Example
· Archive Database
· Restore Database
Section H: Microsoft Excel & OLAP
· PivotTables Overview
· Connecting to OLAP
· Report Design
· Axis Dimensions
· Local Cube
· Save As Web Page |