The following course and knowledge testing topics can be mixed and matched in any practical combination to suit your needs. Try out the Course Designer or Test Designer wizards to give it a go yourself. Save what you put together without obligation and get a quote and book whenever you like.

  • SAS® DI Studio - Data Warehouse design & planning

    • How DI Studio fits with the rest of the SAS software suite
    • Required SAS 9.2 cmponents to support DI Studio
    • Data Warehousing design concepts and techniques
    • Common reasons for Data warehouse project failure to avoid

    Approximately delivery time: 1 hours

  • SAS® DI Studio - Change Management

    There are a number of differences in this area between SAS 9.1 and SAS 9.2.

    • Change management in DI Studio
    • The role of Project repositories 
    • Setting up your metadata login information to enable change management
    • Authorisation requirements in 9.2

    Approximately delivery time: 1 hours

  • SAS® DI Studio - Data sources and Process flows

    • Introduction to creating process flows (jobs) in DI Studio
    • Defining source data within DI Studio.
    • Defining target data within DI Studio.
    • Managing RDBMS and Data Source Metadata with DI Studio

    Approximately delivery time: 3 hours

    Pre-requisite Topics

    SAS® Data Integration Studio
    SAS® DI Studio - Change Management
  • SAS® DI Studio - Transforms to process data

    • Splitter/SQL/Sort/Append/Extract transformations and status handling

    Approximately delivery time: 4 hours

    Pre-requisite Topics

    SAS® Data Integration Studio
    SAS® DI Studio - Change Management
    SAS® DI Studio - Data sources and Process flows
  • SAS® DI Studio - Data lookup and validation

    • Data Look-up/Data Validation/Table loader transformations and RDBMS considerations

    Approximately delivery time: 3 hours

    Pre-requisite Topics

    SAS® Data Integration Studio
    SAS® DI Studio - Transforms to process data
  • SAS® DI Studio - Getting the most from the Expression editor

    • There are many places in SAS DI Studio that allow you to refine or add extra code to create a field or filter in more detail. Without any SAS coding experience, this presents somewhat of a challenge. It is highly recommended you learn some SAS code to be successful with this product, however learning how to get the most out of the expression editor gives you a great start
    • Using the expression builder utility to build expressions, new fields and complex filters using SAS software functions and formats
    • Conditionally populate data values

    Approximately delivery time: 3 hours

  • SAS® DI Studio - Custom written and advanced Transforms

    • Using the Loop Transform
    • Creating your own re-usable Transformations
    • Slowly changing dimensions Type II (optional)

    Approximately delivery time: 4 hours

    Pre-requisite Topics

    SAS® Data Integration Studio
    SAS® DI Studio - Transforms to process data
    SAS® DI Studio - Data lookup and validation
    SAS® DI Studio - Getting the most from the Expression editor
  • SAS® DI Studio - Case Study

    • Customised case study with your data to demonstrate practical application of the topics covered

    Approximately delivery time: 3 hours

YourTeamPlayer onsite SAS® Software Training

Entirely customised SAS® Software education

All courses are at YOUR site
All courses use YOUR DATA
All use YOUR computing environment
Only YOUR staff in attendance
Only dealing with YOUR data issues