Using SAS Data Integration Studio to Build Data Marts from Enterprise Data Sources

Duration: 3.0 days CEU: 1.8

This course provides an overview of SAS Data Integration Studio, formerly known as SAS ETL Studio. This course requires the SAS Intelligence Platform.

Learn how to

set up and work in a change management environment
define metadata for sources, targets, jobs, and OLAP cubes
generate reports on target tables using SAS Data Integration Studio transformations
design customized transformations using Transformation Generator and deploy jobs as stored processes
schedule jobs.

Who should attend

ETL designers and data modelers

Prerequisites

Before attending this course, you should be familiar with

the SAS programming language
Structured Query Language (SQL)
data modeling concepts.

You can obtain the SAS programming knowledge by completing the SAS Programming 1: Essentials course and the SQL knowledge by attending the SAS SQL 1: Essentials course.

Course Contents

Overview of SAS 9 Enterprise Intelligence Platform and SAS Data Integration Studio

Business Intelligence overview
Business Intelligence Information Consumers
navigating in SAS Data Integration Studio

Working Under Change Management

what is change management?
repository types
using change management

Designing the Course Data Mart

planning a data warehouse
course data for the Orion Star company
Orion Star data models

Building a Data Mart

review of the case study
defining the source data
defining the target tables
loading the target tables

Building an OLAP Cube

what is an OLAP cube?
building an OLAP cube
viewing an OLAP cube with Microsoft Excel

Creating Reports

report transformations
using the Transformation Generator Wizard
SAS Data Integration Studio and stored processes

Tranformations for Slowly Changing Dimensions (Self-Study)

defining slowly changing dimensions
using the SCD Type 2 Loader transformation
using the Fact Table Lookup transformation

Job Scheduling

scheduling SAS Data Integration Studio jobs

SAS Data Integration Studio and Data Quality

SAS and Data Quality
using the Data Validation transformation
using the Apply Lookup Standardization transformation (self-study)
using the Create Match Code transformation (self-study)

Administering SAS Data Integration Studio

setup tasks for SAS Data Integration Studio
setting up change management
security planning and implementation (self-study)

Software Addressed

This course addresses the following software product(s): SAS Data Integration Studio, SAS Data Quality Solution, SAS Management Console, SAS Intelligence Platform. This course also addresses DataFlux dfPower Studio.

Course Materials

Students receive a hardcopy of the course notes.

U.S. Schedule

21JAN2009 Atlanta, GA
13MAY2009 New York, NY

11FEB2009 Rockville, MD
15JUN2009 Charlotte, NC

23FEB2009 San Francisco, CA

Check for additional and updated schedule information online at support.sas.com/courses/dis.html.

Registration

To register for this course in the US, call 800-333-7660 or visit support.sas.com/training. This course is also available for on-site training, or you can create a custom course by combining material from several courses. For more details, contact SAS Education in Cary, NC at 919-531-7321 or send e-mail to training@sas.com.