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

Change Management

  • What is change management?
  • Repository types
  • Using change management

Designing the Course Data Mart

  • Planning a data warehouse
  • Building a Data Mart
  • Defining the source data
  • Defining the target tables
  • Loading the target tables

Creating Reports

  • Report Transformations
  • Using the Transformation Generator Wizard
  • SAS Data Integration Studio and stored -processes Transformations for Slowly Changing Dimensions
  • 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
  • Using the Create Match Code transformation