Analysis of Source Data for a Data Warehouse - Development and Exploratory Study

A Framework and Associated Software Tool for the

Analysis of Source Data for a Data Warehouse:

Development and Exploratory Study

Table of Contents

Chapter 1- Introduction 1

Data Quality and the Data Warehouse 2

Research Design and Methods 4

Results 7

Overview of Remaining Chapters 8

Chapter 2- Problem Statement 9

Data Quality in the Data Warehouse 9

Quality Dimensions and Use 11

Identification of Data Warehouse Quality Problems 13

The Current Practice in Data Warehousing 15

Data Warehouse as a Decision Support Tool 16

Allocating Resources for Data Quality Enhancement 17

The Benefits of a Formal Methodology 20

Data Quality Frameworks 21

Data Quality and Metadata Tools 23

Use of Novices 25

Research Questions 26

Chapter Summary 27

Chapter 3- Literature Review 29

Introduction 29

Data Warehouse 29

Data Quality and Data Quality Frameworks 31

User Involvement 35

Data Quality in the Data Warehouse 36

Knowledge Management 37

Information Technology and Quality of Data 41

Evaluating Data 41

Database Design 43

Chapter Summary 44

Chapter 4- Research Design and Method 45

Introduction 45

Research Design and Method Overview 45

Data Quality Audit Process (DQAP) 47

Enhanced Data Dictionary (EDD) 48

Interviews with Data Warehouse Experts 48

Data Quality Analysis Framework 52

Enhanced Data Dictionary Testing 52

First Test of EDD 53

Second Test of EDD 54

Data Quality Knowledge Management (DQKM) 55