1) I would suggest creating a a series of Data Models for different levels of Data.
2) Start with a Generic Data Model for your Enterprise.
Limit it to not more than 15 Entities. Here's an example I have found useful :-
http://www.databaseanswers.org/data_...odel/index.htm
This page lists a whole range of Models that might help you, depending on the nature of your business.
3) Then define levels of Core Data :-
3.1 The foundation would be Reference Data - Countries, Currencies, Time Zones, Payment Methods and so on.
3.2Then would come the Core Entities - aka 'Things of Interest', such as Products or Services, Customers or Users, and so on.
3.3 Somewhere higher would come Business Intelligence/Management Information. These requirements are likely to change over time, so you need a Data Model that reflects this.
HTH
B.Dimple
DBA