Layout Table~~~~4821~4821~~

5 Sessions - 15 Hours of Interactive Training~
Online Analytical Processing (OLAP) is a tool that allows business managers to retrieve and view stored data for trend analysis, multidimensional comparison and decision making. In the SQL Server 2000 OLAP training course from LearnKey, database developers and OLAP database designers will learn how to use the OLAP features of SQL Server. Expert instructor Leslie Koorhan will show you how to build dimensions, design, store and process cubes and create calculated members. At the conclusion of this training course, you will know how to design OLAP databases and provide useful analysis and information to customers or users.

Prerequisites: Relational database experience recommended. Some familiarity with SQL Server 2000 or 7.0 helpful. Data warehousing knowledge a plus.

Benefits
• Increase your earning potential with technical mastery and proficiency.
• Enhance employment opportunities with in-demand technical knowledge.
• LearnKey courses let you move along at your own pace and gain new skills in a useful, productive manner. .~~~4821~4822~~

Course Outline Table~~~~4821~4823~~

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~~~4821~4824~~

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~~~4821~4825~~

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~~~4821~7308~~

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
· Dimension Hierarchy
· Parent/Ancestor
· Differences/Properties
· Val Function
· Conditional Expressions
· IIF Function
· Combine Conditions
· OR Operator~~~4821~4834~~

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~~~4821~4836~~

Ordering~~~~4821~4827~~

SQL Server 2000 OLAP For Developers Training Course by LearnKey~Per Seat Licencing Available

Call 01223 894 136 for quotes for MULTIPLE USERS and Training Centre/Bootcamp & Education Solutions!~~PER USER%3A CD Course|411598|PER USER%3A ONLINE Course|!79236|LIBRARY LICENCE%3A CD Course|411595|~4821~4828~sql server 2000 olap Analytical Processing~