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

Duration: 3.0 days
Course fee: $2,040
EPTO units: 3
CEUs: 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

Expand/Collapse All Expand All Collapse All Print version

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

This course addresses 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.

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