Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Is this Data-warehousing course useful?


    I'm certified in Oracle8i database administration but am more interested in database development and data-warehousing development.

    I'm looking for a data-warehousing engineer job, will the following course be useful? I realised it's stated "This couse is intended for supervisors and managers", so it wouldn't be useful for engineer?

    Thanks in advance for any replies!

    SQL Server 2000 Analysis Services



    Overview & Objectives
    This course provides students with the knowledge and
    skills needed to use SQL Analysis Services to build
    solutions that take advantage of the powerful dataanalysis
    services. The student will discover these
    services make it easier to analyze huge amounts of data
    quickly and how to develop wide range of dimensionaldata
    applications from enterprise reporting tools to
    advanced decision support systems.

    Who Should Attend
    This course is intended for supervisor and manager who
    want to learn to use the SQL Analysis Services tool to
    analyze huge amount of data.

    Course Material
    Microsoft(r) SQL Server(tm) 2000
    Analysis Services Step by Step
    by OLAP Train and Reed Jacobson

    Course Outline
    1. A Data Analysis Foundation
    1.1. Understanding Data Warehousing
    1.2. The Structure of a Data Warehouse
    1.3. Understanding Analysis Services

    2. Analysis Manager from 500 Feet
    2.1. Previewing Analysis Manager
    2.2. Preparing to Create a Cube
    2.3. Designing a Cube by Using the Cube Wizard
    2.4. Processing and Browsing a Cube

    3. Dimension and Cube Editors
    3.1. Working with a Standard Star Schema
    3.2. Working with a Standard Snowflake
    3.3. Working with Time Dimensions
    3.4. Working with a Cube
    3.5. Working with Measures in a Cube
    3.6. Working with a Parent-Child Dimension

    4. Advanced Dimensions and Cubes
    4.1. Creating a Finance Cube
    4.2. Creating an Internet Tracking Cube
    4.3. Creating a Forecast Cube
    4.4. Creating a Virtual Cubes

    5. Office 2000 Analysis Components
    5.1. Creating an Excel PivotTable Report
    5.2. Creating an Office PivotTable List
    5.3. Creating a Local Cube

    6. MDX Values
    6.1. Creating Simple MDX Expressions
    6.2. Retrieving Values from Cells
    6.3. Calculating Relative Contribution

    7. MDX Sets
    7.1. Preparing to Create MDX Queries
    7.2. Creating Basic MDX Queries
    7.3. Creating Calculations by Using Aggregation

    8. Storage Optimization
    8.1. Specifying Options for Optimizing Storage
    8.2. Managing the Pool of Potential Aggregations

    9. Processing Optimization
    9.1. Understanding OLAP Processing
    9.2. Managing OLAP Processing
    9.3. Working with Partitions
    9.4. Automating the Processing of a Database

    10. Dimension Optimization
    10.1. Optimizing Dimensions in a Cube
    10.2. Creating Virtual Dimensions

    11. Security
    11.1. Creating Security Roles
    11.2. Applying Security to a Dimension
    11.3. Applying Cell-Level Security to a Cube

  2. #2
    Join Date
    May 2004
    No comment?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts