Data Integrity and Security

Data Warehousing v.2

Course Overview
Access to data is an important requirement for almost every organization. Organized into two major units, 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. Web sites 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 and explain the major support systems for data mining.
  • Recognize the key benefits of data warehousing.
  • Identify the key components and processes within a data warehouse.
  • Explain how data marts and OLAP are used.
  • Distinguish data warehouses from data marts and OLAP applications.
  • Articulate the need for meta data, along with the content of business and technical meta data.
  • Understand the importance of data quality, along with the techniques to improve data integrity.

Content Partner:

SmartPros Ltd.

SmartPros Ltd. is a leader in online and offline continuing education for
accounting, finance and engineering professionals. With over 2,000 hours of
content, SmartPros has been providing mandatory continuing education
products since 1981. SmartPros provides services and content to its
professional and corporate clients, in a variety of media including Web, CD
ROM, and video. In the accounting market, SmartPros also has a predominant
news and information portal which receives 200,000+ visits per month and
provides services to over 100,000 subscribers. SmartPros' customers include
50% of the Fortune 500, as well as the major firms and associations in each
of its professional markets.

Prerequisites/Advanced Preparation:


Speaker / Author:

David L. Olson
Dr. David L. Olson worked as an engineer for 12 years before earning an MBA and PhD in business, majoring in management science. He has taught at Texas A&M University since 1981 in management science, operations management, and management information systems. He has authored or co-authored five books related to research and teaching in these fields, and has participated in over 40 refereed research articles in these fields.

Software & Hardware Requirements:

  • 56k or Greater Internet Connection
  • Adobe Acrobat® Reader for the .pdf files
  • Adobe® Flash® Player 8 or higher
  • Modern DHTML Compatible Browser
  • Ram: 256 MB minimum
  • Windows or Mac OS


Price (USD)

Standard Rate: $49.90


Course Code : 991199

Release Date : 07/14/2011
Expire Date : 01/05/2020
Credits :
CPE 2.00
QAS 2.00

Course Level : Basic
Course Type : New Standards
Length : 1hr 40min
Passing Grade : 70%
Theme : Data Integrity and Security

Format Type : eLearning
Field Of Study : Information Technology

Returning Subscribers

- OR -