SAS Institute. The Power to Know

Learning Center

Stay in Touch

Not sure what course to take?

Speak with an expert curriculum consultant at 800-333-7660 or send an e-mail.

Submit Your Course Requests

Want this course at another location or on a different date? Let us know your course needs.

On-site Pricing

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

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

Duration: 3.0 days
Course fee: $1,725
EPTO units: 3.3
CEUs: 1.8
Register now

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

This course can help prepare you for the following certification exam(s): SAS Warehouse Technology Exam, SAS Warehouse Architect Concepts Exam, SAS Warehouse Development Specialist Exam.

Learn how to

Who should attend

ETL designers and data modelers

Expand/Collapse AllExpand All      Expand/Collapse AllCollapse All      PrintPrint 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.

Register now


created using SAS software This page was created using SAS software.