TOPICS

What You’ll Learn
Analyze data structures to determine agreement with documented metadata
Discover data anomalies
Identify invalid and incomplete data values
Determine potential primary keys to table structures
Add business meaning to data
Produce deliverables that can be used by Business Users and ETL developers
Configure Information Analyzer
Administer the Information Analyzer environment
Understand security considerations around data analysis
Understand the methodology supporting data analysis
Use Information Analyzer to analyze data content and structure
Use Information Analyzer to construct data rules and utilize IBM-supplied data rule templates
Who Needs to Attend
This is a basic course for business data analysts who want to profile and assess data using Information Analyzer and for data quality analysts who need to measure data quality.

Prerequisites
You must have familiarity with:

Open Database Connectivity (ODBC) and relational database access techniques
Data modeling experience is helpful.

Follow-On Courses
There are no follow-ons for this course.

Course Outline
Information Analysis concepts
Information Server overview
Information Analyzer overview
Information Analyzer Setup
Column analysis
Concepts
Basic data profiling techniques in practice
Primary key analysis
Concepts
Basic data profiling techniques in practice
Foreign key and cross domain analysis
Concepts
Basic data profiling techniques in practice
Baseline analysis
Reporting and publishing
Extending the meta data using Business Glossary and Information Analyzer
Information Analyzer Data Rules and Metrics
Data quality assessment using QualityStage.