Training offering
IBM InfoSphere Information Analysis
Description
This course works with Information Server V8.5
This course introduces the concepts and methods used to perform information analysis. IBM InfoSphere Information Analyzer,Business Glossary, and Exception Manager will be used to perform data profiling,data assessment,data exception monitoring, and meta data enrichment tasks.
In this course, students will learn how to use the IBM InfoSphere suite to analyze data and report results.
Objectives
• Analyze data structures to determine agreement with documented metadata
• Discover data anomalies
• Identify invalid and incomplete data
• Determine 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 Exception Manager to analyze data transformation exceptions
Participants
This is a basic course for business data analysts who want to profile and assess data using Information Analyzer and Exception Manager.
Prerequisite(s)
You should have:
• Knowledge of UNIX or Windows NT administration
• Data modeling experience helpful
• Familiarity with Open Database Connectivity (ODBC) and relational database access techniques
Options
• Information Analysis concepts
• Information Server overview
• Information Analyzer overview
• Information Analyzer Setup
• Column analysis
• Primary key analysis
• Foreign key and cross domain analysis
• Baseline analysis
• Reporting and publishing
• Extending the meta data using Business Glossary and Information Analyzer
• Information Analyzer Data Rules and Metrics
• Exception Manager transformation Data Rules and Monitor
• Data quality assessment using QualityStage
