Principles and Practices

Why this Course?

The success or failure of today’s information initiatives such as data warehousing, Customer Relationship Management, and the Internet lies ultimately in the quality of the data captured and maintained by the business processes and the quality of information presented to the knowledge workers. This seminar details the essential ingredients of an information quality environment for the survival and effectiveness of the organization.

Mr. English describes how to assess and control information quality in the warehouse, customer databases, and at the data sources, both within the brick and mortar walls and through e-business. You learn how to conduct a data assessment. You learn management techniques for improving information quality and preventing defects. Mr. English defines a process for data reengineering and cleansing of data from source to data warehouses or customer databases. He also addresses how to analyze causes of non-quality data and how to improve the processes that cause the defects. You learn both the technical and management requirements for a continuous information quality environment for success.

Learning objectives:

  • What is information quality and who determines it?
  • What is data definition quality
  • What are the kinds of information quality management tools
  • How to assess information quality
  • How to audit and control a data cleansing and data reengineering process for data movement
  • How to improve processes to eliminate the causes of defective data
  • How to assure customer information quality
  • How to assure internet web content quality and e-commerce data quality
  • Implementing an information quality environment


Data Warehouse Managers and staff, Data Quality Managers and staff, Data Administrators, Data Analysts, Database Administrators, IT Management, Systems Analysts and Business Analysts, Quality Assurance Personnel, Data Stewards and Internal and EDP Auditors, Quality Program staff and business management interested in improving the quality of their data.

Format: Lecture with discussion to reinforce the concepts

Duration: 2 Day

Pre-requisites: Basic data management concepts

Course Outline:

1. Information Quality

  • The high costs of low quality data: why you must care—and do something—about it
  • Defining information quality
  • Quality principles and information quality
  • Information products, customers and suppliers
  • Categories of IQ tools in the TQdM® process
  • Total Quality data Management (TQdM®) processes

2. Measuring Data Definition Quality

  • Data standards quality characteristics
  • Data definition quality characteristics
  • Data architecture quality characteristics

3. Assessing Information Quality

  • Characteristics (metrics) of information quality
  • Automated assessment for business rule conformance
  • Physical assessment for data accuracy
  • Data quality interpretation and reporting techniques

4. Reengineering and Cleansing Data for Data Movement

  • Where to “cleanse” (correct) data
  • Identifying data sources
  • Analyzing data and discovering business rules in legacy data
  • Mapping and reengineering legacy data to data warehouse architecture
  • Auditing and controlling the movement of data

5. Improving Information Process Quality: Data Defect Prevention

  • The Plan-Do-Check-Act cycle for data quality improvement
  • Planning and implementing process improvements for data quality
  • Principles of data quality

6. Applied Information Quality: Customer Relationship Management (CRM)

  • Customer-centric information quality
  • What you must know about your customers for sustaining customer satisfaction
  • Best practices for customer information quality

7. Applied Information Quality: Internet and e-Business

  • Providing information quality on the Internet
  • Assuring information quality gathered from Web “customers”
  • The e-Business value chain and customer care

8. Implementing an Information Quality Environment

  • Affecting and culture change
  • Changing the performance measures
  • Organizing for information quality
  • Where and how to start an information quality movement


Jun 14 - 15 2001


8:30 am - 4:30 pm


The Ontario Club, 5th Floor, Commerce Court South 30 Wellington Street West (Bay and Wellington)

Leave a Reply

Your email address will not be published. Required fields are marked *