Before:

After:

Ensure conformed dimensions are created to integrate data across the enterprise.

Conformed dimensions are dimensions built with the organization perspective instead of a project prospective to support the ability to drill across and integrate data from multiple business processes. On the previous model, if Calendar is a conformed dimension, then this dimension can be used by multiple analytical applications.

Physical Data Model Adherence

All physical data models should follow the expectations in this section, plus the additional ...

Get Data Model Scorecard: Applying the Industry Standard on Data Model Quality now with O’Reilly online learning.

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