This course familiarizes you with methods of data extraction, transformation, and loading (ETL) in preparation for SAS Activity-Based Management 7.x.
The self-study e-learning includes:
- Annotatable course notes in PDF format.
- Virtual Lab time to practice.
Learn how to
- set up the SAS Activity-Based Management system for ETL
- import model data
- use the data schema to create staging tables
- map source tables to data fields and properties in the staging tables
- modify, join, and import tables with SAS Data Integration Studio and SAS Enterprise Guide
- export model data for analysis and reporting
- 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 7.x models
There are no formal prerequisites for this course. The ABC Modeling Using SAS Activity-Based Management 7.x and SAS Enterprise Guide 1: Querying and Reporting courses are recommended but not required.
This course addresses SAS Cost and Profitability Management software.