This course familiarizes you with methods of data extraction, transformation, and loading (ETL) in preparation for SAS Activity-Based Management 7.x. This self-study course includes structured course notes that provide a detailed overview, essential skills, and exercises, along with a software Virtual Lab to practice.

The e-learning includes:

• digital course notes for self-study
• Virtual Lab: 30 hours of hands-on software 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 Formats available Duration
: 14 hours/180 day license

There are no formal prerequisites for this course. The and courses are recommended but not required.

This course addresses SAS Cost and Profitability Management Standard software.

What Is ETL?

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

Setting Up SAS For ETL

• 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 Model Data

• importing SAS data sets into SAS Activity-Based Management

Data Schema

• 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 Tables

• mapping staging tables
• mapping columns

Transforming Data in SAS Enterprise Guide and SAS Data Integration Studio

• 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

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

ABTL72.