Data Warehousing Theory and Concepts

Duration: 1.0 day CEUs: 0.6

AUDIENCE
This course is designed to teach IT Professionals, Managers and Developers the concepts of data warehousing using SAS®. Discussion of data available from OLTP systems, data reorganization and transformation, along with metadata, load strategies and report creation are discussed.

BENEFITS
Students will be able to:
• Understand how SAS Software can be used for datawarehousing
• Understand Rapid Warehouse Methodology

PREREQUISITES
None.

COURSE TOPICS

Introduction To Warehousing
• Designing the data warehouse
• Creating the Model
• Methodology and industry standards
• Star Schema
• Snowflake Schema
• Normalization

On Line Transaction Processes
• Pulling Data From OLTP systems
• Using SAS/ACCESS® Software to read RDBMs
• Reading VSAM Files

Restructuring Data
• Data validation and scrubbing
• Organizing Data into Subject Areas
• Denormalizing data
• Standardizing Dates and Times
• Summarizing data
• Data Marts

Updating and Loading the Warehouse
• Loading the data
• Scheduling issues
• Where to store the data

Working With Metadata
• Defining Metadata
• The data dictionary

Getting The Data Out
• Creating reports
• Creating queries
• Online applications

Software Used: Base SAS and SAS/ACCESS® Software.