Building the Enterprise Data Warehouse

Ernest Chan & Sara Charen, BeyeNETWORK

This article originally appeared on the

    Requires Free Membership to View


Hi Bill,

One of the things I have been thinking about is how we can balance the long-term strategic need to properly architect an enterprise data warehouse (EDW), with the ability to respond quickly to the short-term expectations of the business users, and I wanted to share with you – and get your thoughts on – what I have come up with. 
As you have taught me, the successful data warehouse is built iteratively and in small, fast increments. 

The approach is to start with a "thin slice" of the enterprise logical data model (LDM) and introduce that into the EDW. This thin slice can either be "vertical" comprising the major entities from one subject area, or "horizontal" across different subject areas that when brought together and integrated, multiply the business value beyond that of its constituents. 


As each slice is introduced into the EDW, the data marts that represent the most effective and actionable subset of data, can be built off that slice, thus demonstrating business value to the end-user community fairly quickly, without waiting for the full-blown EDW to be built. 



There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: