Available 24/7
Professional Instruction
Free Training Materials
Course Details
The IBM InfoSphere Information Analyzer Essentials 11.5 course is a 4-day course that is designed to teach students 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. The course explores techniques for delivering data analysis results to ETL developers and demonstrates 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.
Topics covered in the course include:
- Analyzing data structures to determine agreement with documented metadata
- Discovering data anomalies
- Identifying invalid and incomplete data values
- Determining potential primary keys to table structures
- Adding business meaning to data
- Producing deliverables that can be used by business users and ETL developers
- Configuring Information Analyzer
- Administering the Information Analyzer environment
- Understanding security considerations around data analysis
- Understanding the methodology supporting data analysis
- Using Information Analyzer to analyze data content and structure
- Using Information Analyzer to construct data rules and utilize IBM-supplied data rule templates
Target Student:This course is designed for the following students:
Business data analysts who want to profile and assess data using Information Analyzer, or data quality analysts who need to measure data quality.
Prerequisites: Students should possess the following experience before attending the course:
You should have:
- Data modeling experience helpful
- Familiarity with Open Database Connectivity (ODBC) and relational database access techniques
Course Outline
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
You should have:
- Data modeling experience helpful
- Familiarity with Open Database Connectivity (ODBC) and relational database access techniques
Testimonials
This was the class I needed.
The instructor Jeff took his time and made sure we understood each topic before moving to the next. He answered all of our questions, and I don't know about the rest of the students, but was very pleased with this experience.
I finally understand how to use Excel.
-Amanda T (Yale New Haven Hospital).
Great class!
We were able to cover a lot of information in one day without getting overwhelmed.
-Maria R (Microsoft).
Free Repeats
Learn At Your Pace
No Travel
Professional Instruction
Affordable Pricing
Group Discounts
