This course provides a broad coverage of the architecture and detailed physical design of a data warehouse - the storage, management and exploitation of data in an integrated information architecture. Anyone attending should already have an understanding of systems analysis and practical knowledge of the relevant SAS system features (see pre-requisites).
The course consists of three parts
- Demonstrations of practical data warehouse techniques
- Exercises based on a case study.
Examples demonstrated during the class include a complete working ETL process for an enterprise-style data warehouse with slowly changing dimension history.
Learn how to
create architecture and designs for an integrated information architecture, including
- the Enterprise storage layer of a data warehouse, based on the most common physical models used
- OLAP data marts
- data mining data marts
- processes (ETL - Extract, Transform and Load) used in loading the Enterprise layer and in maintaining data marts
- management and publishing of metadata
- managing the environment, including archival and backup of data
- basic principles of planning the infrastructure (hardware and software)
- considerations for optimal performance in large data warehouses.
Before attending this course, it is essential that you have
- familiarity with a wide range of SAS software used in data warehousing, SAS data management and data access features, SAS OLAP viewing/reporting tools
- data warehouse or data mart project experience as an implementer (WCO or SAD) or analyst (WAN)
- the ability to read entity-relationship diagrams
- knowledge of the basic principles of designing applications and data.
It is also helpful (but not essential) that you have experience with
- SAS Data Integration Studio
- databases and/or SPDServer
- client/server SAS features
- data mining
- web technology
- data warehouse applications
- projects as warehouse architect (WAC)
- entity-relationship modeling techniques and tools. SAS System Modules Used