Font size:

In this course, you will learn how to use the IBM InfoSphere suite to analyze data and report results to business users. Information discovered during analysis will be used to construct data rules. This course will also explore techniques for delivering data analysis results to ETL developers and demonstrate how to develop more meaningful meta data to reflect data discovery results. An information analysis methodology and a case study will be used to guide exercises.



Highlights:
  • 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

Prerequisites:

You should have:

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


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.


CONTENTS:

  • Understanding Information Analysis
  • IBM Information Server Overview
  • Information Analyzer Overview
  • Information Analyzer Setup
  • Column Analysis and Basic Techniques in Practice
  • Table Analysis (primary keys)
  • Cross-Table Analysis (foreign keys and redundant data)
  • Baseline Analysis
  • Reporting and Publishing
  • Extending the Metadata using Business Glossary and IA
  • Data Rules and Metrics
  • Data Quality Assessment using QualityStage
Find a class and register in three easy steps:
  • 1. Select Location:
  • 2. Select Date Range:
    to
  • 3. Select Class Type:
    • All Types
    • C Classroom
    • V Virtual Live
    • Cv In-Class Virtual
    • O Online
Virtual Live3/12/2018 8:30:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>4 days3495.002457978
Virtual Live4/23/2018 11:30:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>4 days3495.002457977
Virtual Live6/4/2018 8:30:00 AM<span class="course-type type-v" style="cursor:default;word-wrap:normal;display:inline-block;" onmouseover="showHoverInfo(this, 'ProductTypeDescription' ,'VILT')" onmouseout="clearHoverInfo()">V</span>4 days3495.002457982
seek-warrow-w
  • 1
arrow-eseek-eitems per page1 - 3 of 3 items