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 24

Do’s and Don’ts When Building Data Marts

 

24.1 Introduction

24.2 Process Do’s and Don’ts

24.3 Data Mart Handling Do’s and Don’ts

24.4 Coding Do’s and Don’ts

 

24.1  Introduction

In this chapter we will look at what should be done and what should be avoided when building data marts. The approach of this chapter is not to teach but to share experiences from practice.

The do’s and don’ts as they are called in this chapter are divided into three sections:

•  process do’s and don’ts

•  data mart handling do’s and don’ts

•  coding do’s and don’ts

24.2  Process Do’s and Don’ts

24.2.1  Use Check Sums, Cross-Checks, or Peer Review

When writing a program that prepares an analysis data mart, the programmer or analyst is often seduced into ...

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