Code
KM801RO
Duration
4 days
Price
1300 €*
No opened sessions
Notify me when available
* the price doesn't contain VAT taxes

DescriptionWhat we offer

This course introduces the concepts and methods used to perform information analysis. IBM InfoSphere Information Analyzer, Business Glossary, and QualityStage will be used to perform data profiling,data assessment and meta data enrichment tasks.

Course Description:

You will learn how to use the IBM InfoSphere suite to analyze data and report results to business users. This course will also explore techniques for delivering data analysis results to ETL developers and show 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 hands-on labs.

ObjectivesWhat you learn

  • 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

TopicsThe best for you

  • 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
Need this course inside your company?

PrerequisitesWhat should you know

You should have:

  • Knowledge in UNIX or Windows NT administration
  • Data modeling experience (helpful)
  • Familiarity with Open Database Connectivity (ODBC) and relational database access techniques

AudienceWho should attend

This is a basic course for business data analysts who want to profile and assess data using Information Analyzer.