Using the SAS Data Quality Solution to Cleanse Your Data

Duration:

2.0 days

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.