|
Provided by: 123-CBT Computer Based Training SQL Server 2000 Data Warehousing Set of 5 |
 |
Training
Provided by 123-CBT Computer Based Training
Data Warehousing Level 1
- 1.0 Introduction
- 1.1 Topic Overview
- 1.2 Transactional vs. Analytical Data Systems
- 1.3 Data Warehouse Defined
- 1.4 Data Warehouses vs. Data Marts/OLAP
- 2.0 Dimensional Modeling & Planning
- 2.1 Entity-Relationship Modeling vs. Dimensional Modeling
- 2.2 Elements of the Dimensional Model
- 2.3 The Role of User Requirements
- 2.4 Identifying Source Data
- 2.5 Implementing the Data Warehouse Bus
- 3.0 Planning Facts
- 3.1 What is a fact?
- 3.2 Measures
- 4.0 Planning Dimensions
- 4.1 Planning Dimension Tables
- 4.2 Planning a Hierarchy
- 4.3 Special dimensions
Data Warehousing Level 2
- 1.0 Building a Data Mart
- 1.1 Creating the Database
- 1.2 Creating the Fact Table
- 1.3 Creating Dimension Tables
- 1.4 Creating Constraints and Indexes
- 2.0 Loading the Data Mart
- 2.1 Using Staging Tables
- 2.2 Using Transact SQL for Data Migration
- 2.3 Loading Data using Data Transformation Services
- 2.4 Advanced DTS Issues
- 2.5 Evaluating a Typical Load Scenario
- 3.0 Maintaining the Data Mart
- 3.1 Backup and Restoration Considerations
- 3.2 Handling Changing Facts
- 3.3 Handling Changing Dimensions
- 3.4 Securing the Data Mart
Data Warehousing Level 3
- 1.0 Introduction to OLAP
- 1.1 OLAP Concepts
- 1.2 Analysis Services Architecture
- 2.0 Cube Basics
- 2.1 Cube Basics & Measures
- 2.2 Dimensions & Hierarchies
- 2.3 Aggregations
- 2.4 Using the Analysis Manager
- 3.0 Creating Dimensions
- 3.1 Defining Terms
- 3.2 Creating Dimensions with the Dimension Wizard
- 3.3 Creating Time Dimensions
- 3.4 Using the Dimension Editor
- 3.5 Basic Dimension Properties
- 3.6 Using Member Properties
- 3.7 Virtual Dimensions
- 3.8 Multiple Hierarchies
- 4.0 Creating Cubes
- 4.1 Selecting Facts and Measures
- 4.2 Choosing Dimensions
- 4.3 Creating Calculated Measures
- 4.4 Storage Models
- 4.5 Processing Dimensions
- 4.6 Processing Cubes
- 4.7 Using Cube Properties
Data Warehousing Level 4
- 1.0 Managing Cube Partitions
- 1.1 Partitions Concepts
- 1.2 Creating Cube Partitions
- 1.3 Merging Partitions
- 2.0 Optimizing Cubes
- 2.1 Optimizing Aggregations with Storage Models
- 2.2 Usage-Based Optimizations
- 2.3 Tuning the Analysis Server
- 3.0 Special Features
- 3.1 Using Drillthrough
- 3.2 Creating and Using Actions (Demo: Custom actions)
- 4.0 Connecting Clients Using OLE DB
- 4.1 Analysis Application Architecture
- 4.2 Using Excel as an Analysis Server Client
- 4.3 Overview of Client Interfaces
- 5.0 Introduction to Data Mining
- 5.1 Data Mining Basics
- 5.2 Creating Data Mining Models
Data Warehousing Level 5
- 1.0 MDX Concepts Overview
- 1.1 What is MDX?
- 1.2 Role of MDX in Application Architecture
- 1.3 Creating Calculated Members Within Cubes
- 1.4 Using MDX in Client
- 1.5 MDX Examples
- 2.0 Creating Simple MDX Expressions
- 2.1 Understanding the Hierarchy
- 2.2 Using Brackets
- 2.3 Identifying Members
- 2.4 Qualifying Sets of Members
- 2.5 Creating Calculated Members (Demo: Creating a Calculated Member)
- 3.0 Interacting with Cubes
- 3.1 Anatomy of an MDX Query
- 3.2 Basic MDX Queries
- 3.3 Tuple Expressions (Demo: _____)
- 4.0 Performing Aggregations
- 4.1 Calculating data in an MDX Query
- 4.2 Using Aggregate Functions
- 4.3 Using Time Set Functions
- 5.0 Using MDX with ADOMD
- 5.1 Connecting to an Analysis Server
- 5.2 Executing an MDX Query
- 5.3 Manipulating Results
|
|
||||||||
SQL Server 2000 Data Warehousing Set of 5
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
