Data Modelling books for the Enterprise Data Warehouse (EDW)

September 1, 2010

In other parts of this series we have had a look at data warehousing books that cover the design and architecture of a business intelligence solution. I have also covered data warehousing books in the world of Oracle and data warehousing and business intelligence books for project management and business analysis. Today we’ll discuss data modeling books for building an Enterprise Data Warehouse

If you are involved in an enterprise data warehouse program (and by that I don’t mean Kimball’s conformed dimension stuff) you need to be familiar with all aspects of data modelling. This includes

– Requirements gathering
– Enterprise data modeling
– Conceptual/subject area modelling
– Logical modelling
– Physical modelling
Dimensional modelling
– Normalization and denormalization
– Subtypes & supertypes
– Universal data modelling patterns
– Generic data modelling
– ER data modelling
– UML data modelling
– The collaboration process (bridging the business – IT divide)
– Selecting a data modeling tool

A well thought out enterprise data model is the foundation for a successful enterprise data warehouse.

I have put together a list of the most important data modelling books. These will teach you the tools and techniques of the best data modelers out there.

Data Modeler’s Workbench

Data Modeling Made Simple

Data Modelling Essentials

The Data Model Resource Book, Vol. 3

Mastering Data Warehouse Design: Relational and Dimensional Techniques