O'Reilly logo

Data Quality for Analytics Using SAS by Gerhard Svolba

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required