Data Integration for SAS Activity-Based Management 7.x

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:

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.

Database users who prepare source data for import to or export from SAS Activity-Based Management 7.x models

This course addresses SAS Cost and Profitability Management software.

What Is ETL?

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

Data Schema

Mapping Tables

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

ABTL72

Finland

Links