SAS

      NEWS EVENTS SERVICES Careers CONTACT US

HOME PRODUCTS AND SOLUTIONS SUCCESS STORIES PARTNERS COMPANYTRAININGCERTIFICATIONTECHNICAL SUPPORT

SAS.COM

TRAINING / CURRICULUM
 
Training
Find a CourseView all Courses
Experienced with SASSAS Data Integration & ETL
CurriculumRoles Based Courses
Find a CoursePublic Training
Find a CourseOn-Site Training
Find a CourseBusiness Knowledge Series
Find a CourseSAS Solution Lines
Find a CourseAuthorized Training Center
 

using sas data integration studio to build data marts from enterprise data sources

Duration: 3 Days


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

Course Contents 

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

using the Surrogate Key Generator transformation

using the Key Effective Date 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

using the Create Match Code transformation

using the Data Validation transformation

    

Administering SAS Data Integration Studio

setup tasks for SAS Data Integration Studio

setting up change management

security planning and implementation (self-study)

    
Prerequisites
Before attending this course, you should be familiar with
 

the SAS programming language

Structured Query Language (SQL)

data modeling concepts

You can obtain the SAS programming knowledge by completing the SAS Programming I: Essentials course and the SQL knowledge by attending the SQL Processing with SAS course.

Software Addressed
This course addresses the following software product(s):
SAS Data Integration Studio, SAS Management Console, SAS Intelligence Platform.

Course Materials
Each student receives a hardcopy of the course notes and can also choose to take home a copy of the course data.

 

call: 91-22-6749 2222
fax: 91-22-6749 2299

training.india@sas.com

enquire now
register now
Back to Top
 

 

 

   Contact Us     Search     Terms of Use & Legal Information     Privacy Statement   Copyright © 2007 SAS Institute Inc. All Rights Reserved