Data Preparation for Analytics Using SAS

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