Training offering

IBM

Information Analysis

Information

Length: 4 Days
Course code: DX751GB
Price £2,100 before tax

Session dates

Date Location
  • 06/08/2012 Staines
    £2,100 before tax
This training is also available as onsite training.
Please contact us on
0870 251 1000 or email training@arrowecs.co.uk
for more information.

Description

This course introduces the concepts and methods used to perform information analysis. IBM WebSphere Information Analyzer, Business Glossary, and AuditStage will be used to perform data profiling, data assessment, and meta data enrichment tasks. Students will learn how to use IBM Information Analyzer and AuditStage 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.

Objectives

 Analyze data structures to determine agreement with documented meta data
 Discover data anomalies
 Identify invalid and incomplete data
 Determine primary keys to table structures
 Reveal data duplication
 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 methodology supporting data analysis

Participants

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

Prerequisite(s)

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

Options

1. Understanding information through data profiling
2. Leveraging data profiling in an iterative life cycle  Iterations methodology
3. Data Quality Assessment
4. Information Server overview
5. Information Analyzer
6. Getting started
7. Resources, meta data, and creating projects
8. Column analysis
o Concepts
o Basic data profiling techniques in practice
9. Primary key analysis
o Concepts
o Basic data profiling techniques in practice
10. Foreign key and cross domain analysis
o Concepts
o Basic data profiling techniques in practice
11. Baseline analysis
12. Reporting and publishing
13. Extending the meta data Business Glossary
14. Integrating Business Glossary with Information Analyzer
15. Business rule assessment  AuditStage
16. Data quality assessment  QualityStage