O'Reilly logo

Data Preparation 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

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

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