Using the SAS Data Quality Solution to Cleanse Your Data (DIDQ)

Duration

2 days

Description

This course introduces you to the issues relating to data quality and provides hands-on experience using DataFlux dfPower Studio, SAS Data Integration Studio (formerly known as SAS ETL Studio), and the SAS Data Quality Solution. You gain an understanding of the essentials of data quality and gain specific knowledge of data profiling and analysis, standardization and scheme building, duplicate elimination and match code generation, and data augmentation and enhancement.

Prerequisite Skills

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

Course Topics

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

Booking

Please contact the Education Team at SAS for the latest information on all SAS courses or to put your name on our specialised course waiting list.