Using the SAS Data Quality Solution to Cleanse Your Data

Duration: 2.0 days CEU: 1.2

This course presents the tools and techniques of using DataFlux dfPower Studio and the SAS Data Quality Solution to cleanse data. This course requires the SAS Intelligence Platform as well as DataFlux dfPower Studio.

Learn how to

use DataFlux dfPower Studio and the SAS Data Quality Solution to cleanse your data
use data profiling techniques
conduct cross-table analysis
create and apply standardization schemes
use parsing and concatenation techniques
match and integrate your data.

Who should attend

Quality analysts, warehouse consultants, and ETL specialists

Prerequisites

Knowledge of data cleansing issues, SAS programming, and SAS Data Integration Studio is helpful but not required.

Course Contents

SAS and Data Quality

what is data quality?
data cleansing methodology
data quality technology offerings

Course Data and Case Study

overview of course data
overview of course case study

Data Profiling

what is data profiling?
data profiling with dfPower Studio
data profiling with SAS Data Integration Studio
data profiling with SAS

Data Cleansing: Standardization

what is data standardization?
standardizing data with dfPower Studio
standardizing data with SAS Data Integration Studio
standardizing data with SAS

Data Cleansing: Additional Functionality

additional data quality/cleansing techniques
data quality/cleansing using dfPower Architect
data quality/cleansing using SAS

Data Integration

matching and integrating data
data integration using dfPower Studio
data integration using SAS Data Integration Studio
data integration using SAS

Data Monitoring

overview

Software Addressed

This course addresses the following software product(s): SAS Data Integration Studio, SAS Data Quality Solution, SAS Intelligence Platform. This course also addresses DataFlux dfPower Studio.

Course Materials

Students receive a hardcopy of the course notes.

U.S. Schedule

09FEB2009 Rockville, MD

04JUN2009 New York, NY

Check for additional and updated schedule information online at support.sas.com/courses/didq.html.

Registration

To register for this course in the US, call 800-333-7660 or visit support.sas.com/training. This course is also available for on-site training, or you can create a custom course by combining material from several courses. For more details, contact SAS Education in Cary, NC at 919-531-7321 or send e-mail to training@sas.com.