Enter your mobile number below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Kindle Price: £20.30

Save £13.69 (40%)

includes VAT*
* Unlike print books, digital books are subject to VAT.

These promotions will be applied to this item:

Some promotions may be combined; others are not eligible to be combined with other offers. For details, please see the Terms & Conditions associated with these promotions.

Deliver to your Kindle or other device

Deliver to your Kindle or other device

The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset by [Mundy, Joy, Thornthwaite, Warren]
Kindle App Ad

The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset Kindle Edition

4.3 out of 5 stars 9 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"
£20.30

Length: 699 pages

Kindle Books from 99p
Load up your Kindle library before your next holiday -- browse over 500 Kindle Books on sale from 99p until 31 August, 2016. Shop now

Product Description

From the Back Cover

Learn to use SQL Server 2008 R2 to build a successful data warehouse

As the most influential thought leaders in the data warehousing and business intelligence industry, the Kimball Group has developed pioneering techniques that serve as industry standards for DW/BI system design, development, and management. With this new edition of their bestseller, veteran experts from the Kimball Group get you up to speed with using the new Business Intelligence release of SQL Server: SQL Server 2008 R2. Covering the complete suite of data warehousing and BI tools that are part of SQL Server 2008 R2, the authors follow the full project lifecycle, including design, development, deployment, and maintenance.

In addition to a substantial update to the content of the previous edition as well as a look at the new features and functionality of SQL Server 2008 R2 such as PowerPivot and Master Data Services, this new version includes detailed examples that illustrate how to best apply the techniques described in the book. The authors share their own trial–and–error experiences of building a DW/BI system with the Microsoft tools so that you can benefit from their challenges and successes. You′ll also discover how using the Kimball Lifecycle to build your DW/BI system encourages you to zero in on four primary principles: focus on the business, build an information infrastructure, deliver in meaningfulincrements, and deliver the entire solution. With these principles in hand, you′ll be well on your way to building a successful DW/BI system that supports business intelligence requirements common to most organizations.

No matter your role in the process of working on a DW/BI project, The Microsoft Data Warehouse Toolkit, Second Edition shows you how to:

  • Focus your efforts on the best opportunities

  • Select, install, and configure the appropriate components of SQL Server 2008 R2 and other Microsoft products

  • Design the dimensional model and create the database structures for the relational and Analysis Services databases

  • Build an ETL System in Integration Services to populate the DW/BI databases

  • Build the BI applications and data mining models to deliver value to your organization

  • Manage, secure, and grow the DW/BI system for long–term success

With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset

About the Author

Joy Mundy is a member of the Kimball Group and has been focusing on data warehousing and business intelligence since the early 1990s.

Warren Thornthwaite has been building decision support and data warehousing systems since 1980 and is a member of the Kimball Group.

Ralph Kimball, PhD, is known worldwide as an innovator, writer, educator, speaker, and consultant in the field of data warehousing. He is the founder of the Kimball Group (www.kimballgroup.com), which provides data warehouse consulting and education.


Product details

  • Format: Kindle Edition
  • File Size: 8790 KB
  • Print Length: 699 pages
  • Page Numbers Source ISBN: 0470640383
  • Publisher: Wiley; 2 edition (25 Feb. 2011)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B004S82RKG
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Enhanced Typesetting: Not Enabled
  • Average Customer Review: 4.3 out of 5 stars 9 customer reviews
  • Amazon Bestsellers Rank: #444,284 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images or tell us about a lower price?


Customer Reviews

4.3 out of 5 stars
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback
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.
Comment 16 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
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
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
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!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
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
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
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.
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
click to open popover