Course Description
Description
This three-day course provides an overview of SAS Data Integration Studio , formerly known as SAS ETL 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.
Objectives
After completing this course attendees will be able to create architecture and designs for an integrated information architecture, including:
- the Enterprise storage layer of a data warehouse, based on the most common physical models used
- OLAP data marts
- data mining data marts
- processes (ETL - Extract, Transform and Load) used in loading the Enterprise layer and in maintaining data marts
- management and publishing of metadata
- managing the environment, including archival and backup of data
- basic principles of planning the infrastructure (hardware and software)
- considerations for optimal performance in large data warehouses
Prerequisite Skills
Before attending this course, you should complete:
- one of our range of SAS Essentials courses
- SAS Programming
- SQL Processing with the SAS.
Software Used
This course uses SAS Data Integration Studio . This course also addresses 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
Tranformations 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 (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)
|
