SAS India | Training

Training

View all Courses

SAS Data Integration & ETL

Roles Based Courses

Public Training

On-Site Training

Business Knowledge Series

SAS Solution Lines

Authorized 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