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

Role

Data warehouse project leaders, ETL designers, systems experts, and/or data modelers who will be involved in the extraction, transformation, and loading of data into a warehouse.

Duration

3 days

Description

This course provides an overview of SAS Data Integration Studio. You learn how to navigate through the Data Integration Studio interface and to extract, transform, and load data using Data Integration Studio. Additional topics include how to use DI Studio plug-ins and data warehouse management such as change management, scheduling, and use of metadata.

Prerequisites

Before attending this course, you should have: Completed one of our range of SAS Essentials courses. Knowledge of SAS Programming. Knowledge of SQL Processing with SAS. Familiarity with Data Modelling concepts.

SAS Modules Used

SAS Data Integration Studio. This course also addresses aspects of SAS Management Console and DataFlux dfPower Studio.

Course Topics

Overview of SAS 9 Business 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

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 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)

Objectives

After attending this course you will be able to use SAS Data Integration Studio interface to extract, transform, and load data making use of data, report and analysis transforms . You will also know how to use the SAS DataQuality Solution with Data Integration Studio and data warehouse management tools such as change management and scheduling.