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.Using the SAS Data Quality Solution to Cleanse Your Data
|
Duration: 2.0 days Course fee: $1,150 EPTO units: 2.2 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.
This course can help prepare you for the following certification exam(s): SAS Warehouse Technology Exam, SAS Warehouse Architect Concepts Exam.
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 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
- overview of course data
- overview of course case study
- what is data profiling?
- data profiling with dfPower Studio
- data profiling with SAS Data Integration Studio
- data profiling with SAS
- what is data standardization?
- standardizing data with dfPower Studio
- standardizing data with SAS Data Integration Studio
- standardizing data with SAS
- additional data quality/cleansing techniques
- data quality/cleansing using dfPower Architect
- data quality/cleansing using SAS
- matching and integrating data
- data integration using dfPower Studio
- data integration using SAS Data Integration Studio
- data integration using SAS
- 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.
This page was created using SAS software.