Data Warehouse Design Solutions

by Christopher Adamson and Mike Venerable

Forward by Ralph Kimball
Published by John Wiley & Sons, Inc.
ISBN: 978-0-471-25195-8
 544 pages

Available at


Chris Adamson co-authored Data Warehouse Design Solutions with longtime colleague Mike Venerable. The book takes the reader on a thorough tour of the principles of star schema design.

Reading this book and writing the forward was a real pleasure. Mike and Chris have captured the new direction for data warehousing very effectively, and in a way that should be of practical benefit to the reader. Each chapter is...a practice run for the way we all ought to design our data marts, and hence our data warehouses.
— Ralph Kimball

Basic concepts through advanced techniques are presented through a series of real-world examples drawn on the collective experience of the authors. Each chapter explores a key business process, and illustrates varied analytic possibilities through designs in multiple industries.

Industry examples include telecommunications, banking and financial services, manufacturing, retail, and federal government. With each example, the reader is walked through the process of developing a dimensional design that addresses the business process. Example reports show how the dimensional designs reflect the dynamic analytic requirements of the business.

Chapters include:

  • The Business-Driven Data Warehouse
  • Sales
  • Marketing
  • Fulfillment
  • Production
  • Inventory and Capacity
  • Quality
  • Budgets and Spending
  • Financial Reporting
  • Profitability
  • Knowledge and Intellectual Capital
  • Key Measures and Ratios
  • Presenting Information
  • Building an Enterprise Data Warehouse
  • Interviewing
  • Key Business Terms

More information on Data Warehouse Design Solutions is available at, where you can read user comments and browse a sample chapter.

If you are an educator, you may request an evaluation copy of this book directly from the publisher.