Using the SAS Data Quality Solution to Cleanse Your Data

Duration: 2.0 days
Course fee: $1,760
EPTO units: 3
CEUs: 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

Expand/Collapse All Expand All Collapse All Print version

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

This course addresses 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.

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