Strategic Data Warehousing Principles Using SAS Software

Book Cover

by Peter R. Welbrock

What is the key to a successful Data Warehouse? Strategy, design, and implementation! This book skillfully provides a conceptual and working model of a successful Data Warehouse process that is developed by using SAS software. Written for both the business and technical sides of the house, Welbrock supplies real-life experience with Data Warehousing, not a theoretical approach. This book delivers the following three-phase strategy for building a Data Warehouse: 1) Build a Conceptual Data Warehouse that contains metadata about the business elements required to fulfill enterprise needs. 2) Transition the business elements that are documented in the Conceptual Warehouse into a technological lexicon. 3) Implement the physical Data Warehouse. Topics discussed that support the Data Warehousing process are data modeling, data transformation, multi-dimensional databases, data extraction and storage, warehouse loading, client/server, and the SAS/Warehouse Administrator. The strategy for designing your effective Data Warehouse is found in these pages!

380 pages.

Also Recommended: SAS/Warehouse Administrator Metadata API Reference, Release 1.3, First Edition; SAS/Warehouse Administrator User's Guide, Release 1.3, First Edition; Getting Started with the SQL Procedure, First Edition; SAS Guide to the SQL Procedure: Usage and Reference, Version 6, First Edition; SAS Language: Reference, Version 6, First Edition; SAS Procedures Guide, Version 6, Third Edition; SAS/ACCESS Software for Relational Databases: Reference, First Edition (ODBC Chapter); SAS/CONNECT Software: Usage and Reference, Version 6, Second Edition; SAS/SHARE Software: Usage and Reference, Version 6, First Edition;

CMS, Mac, MVS, OS/390, OS/2, UNIX, OpenVMS Alpha, OpenVMS VAX, Windows

ISBN: 1-58025-151-X

Order #CW56278

How To Order

US Customers

To order SAS Institute Publications, call SAS Institute book sales at 1-800-727-3228. (Note: This toll-free number is for ordering books in the U.S. only.) You may also contact book sales by E-mail at

International Customers

To order SAS Institute Publications, contact your local SAS office. International orders sent to the U.S. office will be faxed to the appropriate SAS Subsidiary or Distributor office. Pricing, delivery, and terms for all international documentation orders are determined by each local office.

Copyright © 1999 SAS Institute Inc.