Chapter 10: Considering the User Needs of SAS Data Warehouses

Maintaining a data warehouse entails so much work that it is important to step back once in a while and remind ourselves that the point of all this work is to serve data warehouse customers or users. This chapter focuses on how to serve the needs for the two main classes of SAS data warehouse users: analysts and developers.

First, we examine the roles of analysts and developers, and consider how their needs differ. Next, we discuss how to serve the needs of analyst users, through providing data access and serving up useful foreign keys and crosswalk variables. After that, we focus on serving the needs of warehouse developers through policies and procedures overseen by a data stewardship ...

Get Mastering SAS Programming for Data Warehousing now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.