Learn more Download now Shop now Shop now Shop now Shop now Shop now Learn more Shop now Shop now Learn more Learn more Shop Kindle Learn More Shop now Shop now Learn more

on 21 October 2015
A good overview of the Kimball Lifecycle for Data Warehousing / BI and how SQL Server and associated tools meet the requirements of the methodology. Recommended reading alongside othet Kimball Books The Data Warehouse Lifecycle Toolkit and the Data Warehouse Toolkit. Each of these books comes at the subject with a different emphasis but they duplicate and overlap to an extent that the details of the Kimball methodology slowly but surely starts to sink in.

Note that although SQL Server is now at version 2014 the DW/BI toolset has not changed fundamentally so this book is still of value
One person found this helpful
|0Comment|Report abuse
on 22 September 2012
I bought this book as it encompased the Kimball technique and the Microsoft BI Stack detail, and I wasn't disappointed at all! If you buy this book as a technical reference on the Microsoft toolset, then you will be disappointed and should buy something more specific. This book takes you through a data warehouse project, touching on the tools but in a way that gives you 'food for thought' on how you want to do things, but giving enough steer to make sure you don't miss out some fundamentals. A great book and highly recommended!
|0Comment|Report abuse
on 26 November 2014
Very happy with this, some really practical advice and its a great platform to approach this subject from. Especially interesting for me was the methods to use when defining the entities with the business users. It gives excellent advice on how to document and manage these discussions
|0Comment|Report abuse
on 8 November 2015
Great book
|0Comment|Report abuse
on 23 December 2011
I paid for this book myself and have several of the previously published books by Wiley:

The clearly written guide describes the suite of Microsoft data warehousing technologies and tools in the context of the widely respected Ralph Kimball design techniques that are generally realised as being best practice in the field. Expert advice is provided on how to best-use these tools to build your robust B.I. solutions.

This book is an update on the 2005 version but stands on it's own as a self-contained and comprehensive guide. The guide's strength is keeping the explanations in MS SQL2008 R2 context while you learn and harvest the many useful tips provided.

Buy it, read it, use it, read it and the other Kimball guides again.
2 people found this helpful
|0Comment|Report abuse
on 2 February 2012
Let me start by saying that the Kimball Group is widely respected as being the best there is when it comes to dimensional modelling. The book gets off to an excellent start and I found myself smiling in acknowledgement as the authors shared some of their experiences. The Kimball model is widely referenced throughout the book and this makes complete sense. It really does encapsulate what the subject is about.

So why then just two stars? Let me illustrate by defining how to connect a hosepipe! I would suggest:

1. You'll need a supply of water, hose pipe and tap
2. Connect the pipe to the tap
3. Turn on water

The Kimball way:

1. You'll need water (refer to step 2), hosepipe(refer to step 3) and tap (refer to step 4)
2. Refer to diagram 1 to determine if your water pressure is correct. You'll need to also reference this to your geography as the water may be too hard (in which case you will need to add a softener) or too soft (in which case you'll also need one of a variety of available additives). This is discussed in detail in chapter 2.
3. The hosepipe must be of a sturdy material- we recommend (insert list of long technical names here), given the environmental constraints and delimiters (insert as much nonsense jargon here as possible) that you face on your project. You'll also need to consider how wide and how long your hosepipe is- as this can drastically affect pressure/ flow rate. Please refer to Chapter 3 for a detailed discussion.
4......and so on and on and on and on.

As a consequence the book (and I would suggest the whole Kimball approach) becomes an impractical and unneccessary technical bore.

A hugely disappointing book on a subject that I feel passionately about. This book encapsulates why Business Intelligence still has so far to go to win over hearts and minds.
16 people found this helpful
|0Comment|Report abuse
on 21 October 2011
This book was paid for by my employer. I've been working in this arena for about 10 months now and wanted to widen my knowledge and get a better understanding of BI and datawarehouse concepts. This book delivers this and more...
One person found this helpful
|0Comment|Report abuse
on 28 September 2011
A solid book that perfectly marries the Microsoft's BI offering with the Kimball Group datawarehousing world. Includes an excellent, honest, assesment toward the end of the book. Revised, updated, a joy.
|0Comment|Report abuse
on 18 October 2011
Covers all the data warehousing design,ETL,OLAP and BI concepts in a practical manner based on latest SQL Server 2008R2 features.I recommend this book for all levels
|0Comment|Report abuse

Need customer service? Click here