IntroductionCourse Outline

Objectives

 

  • 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

What you will Learn

 

  • Learning Journeys that reference this course:
  • IBM Information Server - Developer
  • Information Server - Data Steward
  • IBM Information Server - Business Analyst

Audience

This basic course is for business data analysts who want to profile and assess data using Information Analyzer, also data quality analysts who need to measure data quality.

Prerequisites

You should have:

  • Data modeling experience helpful
  • Familiarity with Open Database Connectivity (ODBC) and relational database access techniques

Duration

4 Days

Outline for IBM Information Analyzer Essentials v 11.5 Training

 

  • Information Analysis concepts
  • Information Server overview
  • Information Analyzer overview
  • Information Analyzer Setup
  • Column analysis
  • Concepts
  • Basic data profiling techniques in practice
  • Data profiling techniques
  • 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 Information Governance Catalog and Information Analyzer
  • Data Rules and Metrics