SAS 9 Data Integration Fast Track

Duration: 5.0 days
Course fee:
EPTO units: .
CEUs: 3

Available for on-site training or can be scheduled at any SAS training facility if demand warrants.

This intensive training course provides accelerated learning for those who will use SAS Data Integration processes, including data cleansing and enrichment, ETL processing, and data federation. This course is for individuals who are comfortable with learning large amounts of information in a short period of time. The Using SAS Data Integration Studio to Build Data Marts from Enterprise Data Sources, Using SAS Data Integration Studio to Create Efficient ETL Processes, and Using the SAS Data Quality Solution to Cleanse Your Data courses are available to provide the same type of information in a more detailed approach over a longer period of time.

Learn how to

create data mart/data warehouse tables necessary for querying and reporting
deploy jobs for scheduling
maintain jobs that build tables by tracking efficiencies
incorporate data quality standards in ETL flows
perform maintenance of the Quality Knowledge Base
where possible, take advantage of the SAS Scalable Performance Data Server.

Who should attend

Data integration developers who need to learn the SAS Data Integration process in a short period of time

Expand/Collapse All Expand All Collapse All Print version

Prerequisites

Before attending this course you should view the free Self-Paced e-Learning module Overview: SAS Business Intelligence. You should also have some SAS programming experience. SAS programming experience can be obtained by attending the SAS Programming 1: Essentials course or viewing the Self-Paced e-Learning programming courses.

Course Contents

Introduction to SAS Data Integration Studio

defining the SAS Intelligence Platform
navigating in SAS Data Integration Studio

Working Under Change Management

defining change management
identifying repository types
using change management

Building a Data Mart

reviewing the case study defining the source data
defining the target tables
loading the target tables

Building an OLAP Cube

defining OLAP
building an OLAP cube
viewing an OLAP cube

Creating Reports

discussing reporting transformations
building a frequency report
creating a custom transformation
defining a stored process
stating the features of a stored process
specifying tools that can use stored processes

Additional Topics and Transformations

defining features of import and export
defining features of the copy, paste, and paste special options
defining features of impact analysis
specifying attributes of the Loop transformation

Tracking Efficiency in ETL Flows: Basic Tuning

identifying important concepts for SAS Data Integration Studio
tracking and measuring efficiencies
working with intermediate files
views or physical tables for ETL flows
transformation and column optimization

Tracking Efficiency in ETL Flows: Data, Sorts, and Joins

identifying additional techniques to improve performance
working with data, sorts, and joins

SAS and Data Quality

defining data quality
describing the methodology of data quality
reviewing data quality tasks

Data Profiling

defining data profiling
data profiling with dfPower Studio

Data Cleansing: Standardization

defining data standardization
standardizing data with dfPower Studio
standardizing data with SAS Data Integration Studio
standardizing data with SAS

Data Cleansing: Additional Functionality

learning additional data quality/cleansing techniques
describing the functionality of dfPower Architect
sequencing the steps to build a job
describing SAS Data Quality Server functions

Data Integration

matching and integrating data
identifying the parts of dfPower match
using dfPower Match and dfPower Architect to generate match codes
describing the data integration capabilities of SAS Data Integration Studio

Software

This course addresses SAS Data Integration Studio, SAS Intelligence Platform, SAS Data Quality Solution.

Course Materials

Students receive a hardcopy of the course notes.

Share Your Thoughts

Are there additional topics you'd like for this course to address? Would you like for this course to be offered at another training facility? Let us know by adding to our Interest List.

Course fee and EPTO units will differ for on-site training.

This page was created using SAS software.

-	Public
-	On-site training
-	One-to-one Mentoring
-	Courses by Industry Experts
-	Targeted Learning
-	ABM Training
-	TPS Service
-	Find a Course
-	Register now
-	Course list
-	Curriculum paths
-	Locations
-	Special Offers