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.

• 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

Formats available	Standard duration
Classroom:	2.0 days
e-Learning:	14 hours/180 day license	System Requirements

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.

• describing staging tables
• describing ETL
• viewing staging tables in SAS Enterprise Guide

• describing how libraries are created using SAS Data Integration Studio or SAS Enterprise Guide
• configuring and assigning a library
• creating a library using SAS Data Integration Studio
• using the New Object Wizard
• using the Source Designer
• viewing a library in SAS Enterprise Guide
• using SAS Management Console

• importing SAS data sets into SAS Activity-Based Management

• identifying staging tables required for import
• defining a dimension signature
• differentiating the two types of keys
• describing staging table dependencies
• identifying staging table import order

• mapping staging tables
• mapping columns

• modifying tables with SAS Data Integration Studio and SAS Enterprise Guide
• navigating SAS Data Integration Studio
• appending data and adding a new account to staging tables using SAS Data Integration Studio
• using SAS Enterprise Guide to join staging tables and Microsoft Excel spreadsheets
• importing staging tables

• exporting model data to SAS data sets
• exporting a model to an XML file
• identifying scenarios appropriate for exporting to data sets versus XML