IBM Information Analyzer Essentials v 11.5

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.

Nach Abschluss dieses Seminars haben die Teilnehmer Wissen zu folgenden Themen:

• 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

1. Information Analysis concepts
2. Information Server overview
3. Information Analyzer overview
4. Information Analyzer Setup
5. Column analysis
6. Concepts
7. Basic data profiling techniques in practice
8. Data profiling techniques
9. Primary key analysis
10. Concepts
11. Basic data profiling techniques in practice
12. Foreign key and cross domain analysis
13. Concepts
14. Basic data profiling techniques in practice
15. Baseline analysis
16. Reporting and publishing
17. Extending the meta data using Information Governance Catalog and Information Analyzer
18. Data Rules and Metrics