Stay in Touch
Not sure what course to take?
Speak with an expert curriculum consultant at 800-333-7660 or send an e-mail.Submit Your Course Requests
Want this course at another location or on a different date? Let us know your course needs.On-site Pricing
Course fee and EPTO/APTO units differ for on-site training.SAS 9 Data Integration Fast Track
|
Duration: 5.0 days Course fee: $3,000 EPTO units: 6 CEUs: 3 *This course cannot be paid for with a Power of 3 account. | ||
 |
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 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
- defining change management
- identifying repository types
- using change management
- reviewing the case study
defining the source data - defining the target tables
- loading the target tables
- defining OLAP
- building an OLAP cube
- viewing an OLAP cube
- 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
- 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
- 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
- identifying additional techniques to improve performance
- working with data, sorts, and joins
- defining data quality
- describing the methodology of data quality
- reviewing data quality tasks
- defining data profiling
- data profiling with dfPower Studio
- defining data standardization
- standardizing data with dfPower Studio
- standardizing data with SAS Data Integration Studio
- standardizing data with SAS
- 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
- 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.
This page was created using SAS software.