Data Warehousing Fundamentals for IT Professionals (2nd ed)

Paulraj Ponniah

Published by

Wiley

ISBN

978-0-470-46207-2

RRP

£80.50

Reviewed by

Adrian Rossi

Score

9 out of 10

Data Warehousing Fundamentals for IT Professionals (2nd ed)I went into this book with the expectation of a long and dreary discussion on databases and related topics. I was very wrong.

This is a tour de force of data warehousing and all related technologies, methodologies and techniques. There is depth as it covers the full systems development life cycle (SDLC) from both technical and human aspects.

And it has breadth as it spans topics such as ‘extract, transform load’ (ETL), master data management (MDM) and dimensional modelling, examining how they intersect with data warehousing concepts and technologies.

More than this, however, is the injection of real-world wisdom, experience and insight; clearly the author is a long-time practitioner and expert in this area. And if this were not enough, the language is clear and precise, and the associated content is easily internalised.

So, with so much right, why did I feel something was missing? It is hard to pin down exactly what irritated me about this book; and it could be a personal issue. If I had to guess, two things stand out.

Firstly, while it is great that each chapter ends in exercises, where are the solutions? How does the reader learn from questions alone?

Secondly, the actual implementation of the data warehouse is a relatively small chapter at the very end of the book. I guess I was expecting to see more on this topic, along with more case studies using real products in this space, and demonstrating how to actually carry out the techniques described in such depth within the book.

Notwithstanding this, a great resource.

Further Information: Wiley

August 2010