ETL for SAS Activity-Based Management 6.x

This course is not currently scheduled.

Duration: 2.0 days
Course fee:
EPTO units: .
CEUs: 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 models

Expand/Collapse All Expand All Collapse All Print version

Prerequisites

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 Lab

Software

This course addresses SAS Activity-Based Management. You also use SAS Enterprise Guide in this course.

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.

Share Your Thoughts

Are there additional topics you'd like for this course to address? Would you like for this course to be offered at another training facility? Let us know by adding to our Interest List.

Course fee and EPTO units will differ for on-site training.

This page was created using SAS software.

-	Public
-	On-site training
-	One-to-one Mentoring
-	Courses by Industry Experts
-	Targeted Learning
-	ABM Training
-	TPS Service
-	Find a Course
-	Register now
-	Course list
-	Curriculum paths
-	Locations
-	Special Offers