Data Modelling books for the Enterprise Data Warehouse (EDW)

Uli Bethke Data Warehousing Books

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

About the author

Uli Bethke LinkedIn Profile

Uli has 18 years’ hands on experience as a consultant, architect, and manager in the data industry. He frequently speaks at conferences. Uli has architected and delivered data warehouses in Europe, North America, and South East Asia. He is a traveler between the worlds of traditional data warehousing and big data technologies.

Uli is a regular contributor to blogs and books, holds an Oracle ACE award, and chairs the the Hadoop User Group Ireland. He is also a co-founder and VP of the Irish chapter of DAMA, a non for profit global data management organization. He has co-founded the Irish Oracle Big Data User Group.