SAS Data Integration Studio

Title Level Training Formats
SAS Data Integration Studio 1: Essentials
This course introduces SAS Data Integration Studio and includes topics for registering sources and targets; creating and working with jobs; and working with transformations.

3 Intermediate Classroom e-Learning
SAS Data Integration Studio: Additional Topics
This course expands on the knowledge learned in SAS Data Integration Studio 1: Essentials and provides additional information on setting up change management, working with the Loop transformations, working with slowly changing dimensions, using the loader transformations, working with databases, and defining custom transformations. Also covered are impact analysis, conditional execution, metadata promotion, and version control, as well as establishing checkpoints. Lastly, this course covers deploying jobs for scheduling and integrating with DataFlux.

The self-study e-learning includes:

  • Annotatable course notes in PDF format.
  • Virtual Lab time to practice.

4 Expert Classroom e-Learning
SAS Data Integration Studio: Fast Track
This course is in a boot-camp format. It includes the content of both SAS Data Ingegration Studio: Essentials and SAS Data Integration Studio: Additional Topics. It introduces and expands the knowledge of SAS Data Integration Studio and contains topics about registering sources and targets; creating and working with jobs; and working with transformations. This course also provides information about working with slowly changing dimensions, working with the Loop transformations, and defining new transformations.

The self-study version of this course contains structured course notes that provide a detailed overview and exercises that help you develop essential skills. There is also a Virtual Lab that enables you to practice what you learn in the course.

The e-learning version includes the following:

  • digital course notes for self-study
  • Virtual Lab: 50 hours of hands-on software practice

4 Expert Classroom Live Web Classroom e-Learning
SAS Data Integration Studio 3: Workshop on ETL development with star schemes
The purpose of this workshop is to construct star schemes and utilize them for data warehouse development. You will learn the basic principles of data modelling and star schemes as well as how to create and apply such star schemes. The course is a continuation of subjects presented in SAS Data Integration Studio 1: Essentials.

3 Intermediate Classroom
SAS Data Integration Studio Update Workshop – from version 4.2 to 4.9
General update of functionality
  • SQL SET Operators transformation
  • Improved import/export functionality
  • Improved and new functionality for Slowly Changing Dimensions
  • Improved functionality for iterative jobs
  • Improved Code analyzer
  • Parallel processing
  • Job versioning
  • SAS lineage
  • Conditional processes
  • Techniques to push ELT job code down to a database (for example Teradata)
  • Web services

  • Integrating Data quality in DI Studio jobs
  • Overview of data quality in SAS Data Integration Studio
  • Match coding
  • Standardizing data
  • Data Integration server and Dta Management Server


  • Using SAS Visual Process Orchestration
  • Integrating job flows
  • SAS Data Management Console


  • Working with SAS hadoop and SAS LASR server transformations
  • Creating jobs that load data to hadoop
  • Creating jobs that load data from hadoop to LASR (memory for Visual Analytics)
  • Creating jobs that load from any source to LASR
  • 3 Intermediate Classroom
    SAS Data Governance Essentials
    This course teaches you how to create and manage terms using SAS Business Data Network, how to access and view relationship information in SAS Lineage, and how to monitor data in Business Rules Manager and view the monitoring results.

    The self-study version of this course contains structured course notes that provide a detailed overview and exercises and that help you develop essential skills. There is also a Virtual Lab that enables you to practice what you learn in the course.

    The e-learning includes the following:

    • digital course notes for self-study
    • Virtual Lab: 30 hours of hands-on software practice

    3 Intermediate Classroom e-Learning
    SAS Federation Server: Accessing and Virtualizing Enterprise Data
    SAS Federation Server makes it easier for business users to access secure data for reporting and analysis. It provides a virtual layer or view, giving users the appropriate level of control without physically moving data. This frees up IT staff to focus on other tasks by giving them a simple method of sharing data using a centralized, governed security layer

    The self-study e-learning includes:

    • Annotatable course notes in PDF format.
    • Virtual Lab time to practice.

    3 Intermediate Classroom Live Web Classroom e-Learning
    Leveraging the Power of the Quality Knowledge Base (QKB) in SAS Technology Components
    This course assists SAS users with accessing the components of the Quality Knowledge Base (QKB) from within a variety of SAS technology components.

    3 Intermediate Classroom Live Web Classroom e-Learning
    Hadoop Data Management with Hive, Pig, and SAS
    In this course, you use processing methods to prepare structured and unstructured big data for analysis. You learn to organize this data into structured tabular form using Apache Hive and Apache Pig. You also learn SAS software technology and techniques that integrate with Hive and Pig and how to leverage these open source capabilities by programming with Base SAS and SAS/ACCESS Interface to Hadoop, and with SAS Data Integration Studio.

    3 Intermediate Classroom Live Web Classroom e-Learning