Data Quality for Analytics Using SAS

Appendix E: A Short Overview on Data Structures and Analytic Data Preparation

E.2 Wording: Analysis Table and Analytic Data Mart

E.3 Normalization and De-normalization

General

Normalization

De-normalization

Example

E.4 Analysis Subjects

Definition

Representation in the data set

E.5 Multiple Observations

General

Examples

Repeated measurements over time

Multiple observations because of hierarchical relationships

E.6 One-Row-per-Subject Data Mart

E.7 The Multiple-Rows-per-Subject Data Mart

E.8 The Technical Point of View

Transposing

Aggregating

E.1 Introduction

Because some aspects of data preparation and data structures for analytics are also relevant for data quality for analytics and some terms are used throughout this book, this chapter gives ...