ETL for SAS Activity-Based Management 6.x
Classroom duration: 2.0 days Live Web duration: 4 half-day sessions CEU: 1.2
This course familiarizes you with methods of data extraction, transformation, and loading (ETL) in preparation for SAS Activity-Based Management 6.x.
Learn how to
- set up the SAS Activity-Based Management system for ETL
- use the data schema for creating staging tables
- import model data from staging tables
- map source tables to data fields and properties in the staging tables
- export model data for analysis and reporting.
Who should attend
Database users who prepare source data for import to or export from SAS Activity-Based Management 6.x modelsPrerequisites
Before attending this course, you should have completed the Querying and Reporting Using SAS Enterprise Guide course. The ABC Modeling Using SAS Activity-Based Management 6.x course would be helpful and preferred but is not required.Course Contents
What Is ETL? Setting up SAS for ETL Importing Model Data Data Schema Mapping Tables Transforming Data in SAS Enterprise Guide Exporting Model Data Exporting for Analysis Challenge LabSoftware Addressed
This course addresses the following software product(s): SAS Activity-Based Management. You also use SAS Enterprise Guide in this course.Classroom Course Materials
Students receive a hardcopy of the course notes and, in some courses, can choose to take home a copy of the course data.Live Web Course Materials
Students attend Live Web classes using a Web browser and a telephone and interact with their instructor and fellow classmates in real time. Each student receives an e-mail with instructions on how to join the class three business days before the class begins. The instructions e-mail includes a link to download the course materials, including the exercise files. Students need to download and print the course materials prior to class.System Requirements
For Live Web, you must- review and meet the general system requirements.
- complete the course exercises through our virtual lab. The virtual lab allows you to access the software used in class over the Internet, so that you do not need this software on your local machine.
- run this
test to connect to a virtual lab session. If firewall problems prevent you from connecting to the virtual lab, then you will need the following software installed and configured in your environment to participate in the course exercises:
- a SAS Activity-Based Management Environment that meets these System Requirements (.pdf)
U.S. Schedule
| 22JAN2009 Cary, NC 18MAY2009 Irvine, CA | 25MAR2009 Chicago, IL | 27APR2009 Live Web, |
Check for additional and updated schedule information online at support.sas.com/courses/abetl.html.