About this Course

Duration 3 Days

This course introduces data integration architecture concepts including modeling; understanding the different types of data sources; and designing the process of creating and using data warehouse information.


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

Delegates will learn how to

create architecture and designs for an integrated information architecture, including

  • understand the SAS IPI methodology for rapid warehousing
  • differentiate between the various types of data modeling
  • work with various data sources and include data quality
  • work with and exchange metadata between applications
  • design extraction, transformation, and load processes
  • establish security
  • create and use data warehouse information



  • introducing course topics
  • specifying data integration architect concepts

Rapid Warehousing

  • rapid warehousing using the SAS IPI methodology

Defining Modeling

  • defining subject modeling
  • defining dimensional modeling
  • defining entity relationship modeling
  • defining when to use what
  • defining physical data modeling

Working with Data Sources

  • defining different types of data sources
  • defining data quality issues
  • defining unstructured data sources
  • defining integration of data sources

Introducing Metadata

  • defining metadata
  • specifying metadata architecture
  • defining metadata exchange between applications

Defining Process Design

  • defining extraction
  • defining transformation
  • defining loading
  • defining archiving
  • specifying backup and restore techniques
  • working with scheduling

Exploring Security Concepts

  • defining layers of security
  • defining data encryption
  • taking advantage of logging and tracing

Using Data Warehouse Information

  • using data with business intelligence applications
  • using data for business analytics
  • using data for operational intelligence

Software Addressed
This course is independent of the software used to implement a data warehouse

3 Days


This is a QA approved partner course

Delivery Method

Delivery method


Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0113 220 7150 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.