Computer Science  |  Format: Flash

Data Warehousing v.2

Course Overview
Access to data is an important requirement for almost every organization. Organized into two major sections, this course describes data support available for data mining, to include data warehousing, data marts, and online analytic processing. All of the relevant tools are covered.

The first part of the course defines and discusses these systems. The capabilities of each system are reviewed in terms of their functional purposes. Subunits and features of the major systems are explored, incorporating their purpose, processes, and benefits. Websites for additional information are provided, along with software products available for the various applications.

The second part of the course demonstrates each of the three systems with a prototypical example. Comparisons are provided, along with exhibits that illustrate the optimal use of each. In the concluding sections, meta data is discussed and data quality concepts are presented.

Learning Objectives
After completing this course, the course participant should be able to:

  • Define the major support systems for data mining.
  • Recognize the key benefits of data warehousing.
  • Identify the key components and processes within a data warehouse.
  • Determine how data marts and OLAP are used.
  • Distinguish data warehouses from data marts and OLAP applications.
  • Identify the need for meta data, along with the content of business and technical meta data.
  • Determine the importance of data quality, along with the techniques to improve data integrity.
    Catalog Number: 991199
    CPE Credits: 2 Registry / 2 QAS
    Author: David L. Olson
    Advanced Preparation:
    Course Level: Basic
    Field of Study: Information Technology
    Content Partner: SmartPros Ltd.
    QAS: QAS Certified based on 50 minute hours.
    Course Type: Self-study
    Minimum Passing Grade: 70%
    Soft/Hardware Reqs.:  Adobe Acrobat® Reader for the .pdf files
     Adobe® Flash® Player 9 or higher
     56k or Greater Internet Connection
     Modern DHTML Compatible Browser
     Ram: 256 MB minimum
     Windows or Mac OS
    Release/Expiration Dates: Jul 14, 2011 / Feb 14, 2022