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