Chapter 8

The One-Row-per-Subject Data Mart

 

8.1 Introduction

8.2 The One-Row-per-Subject Paradigm

8.3 The Technical Point of View

8.4 The Business Point of View:  Transposing or Aggregating Original Data

8.5 Hierarchies: Aggregating Up and Copying Down

8.6 Conclusion

8.1  Introduction

In this chapter we will concentrate on the one-row-per-subject data mart. This type of data mart is frequently found in classic statistical analysis. The majority of data mining marts are of this structure. In this chapter, we will work out general properties, prerequisites, and tasks of creating a one-row-per-subject data mart. In Chapters 1820 we will show how this type of data mart can be filled from various data sources.

8.2 The One-Row-per-Subject Paradigm ...

Get Data Preparation for Analytics Using SAS now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.