Last year I bought The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling by the Kimball Group. Ralph Kimball is known as the father of dimensional modeling. The guy really knows what he is talking about. If dimensional modeling is NOT something you are familiar with, then this book is for you. If you are familiar with dimensional modeling, you should read it anyway! It shows how to build a good data warehouse by using the best patterns.
Each chapters use a different business area including:
- Retail sales and e-commerce
- Inventory management
- Order management
- Customer relationship management (CRM)
- Human resources management
- Financial services
- Telecommunications and utilities
- Health care and insurance
It covers almost every situation you can face!
The second edition has been released in April 2002, so it’s a bit old. Some examples have clearly been written a long time ago (probably in the first edition) but most of the concepts still apply.
The next book in list is from the same authors: The Data Warehouse Lifecycle Toolkit