CDN$ 84.44
In Stock.
Ships from and sold by Gift-wrap available.
Building a Data Warehouse... has been added to your Cart
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 3 images

Building a Data Warehouse: With Examples in SQL Server Paperback – Dec 16 2011

See all 5 formats and editions Hide other formats and editions
Amazon Price
New from Used from
"Please retry"
CDN$ 84.44
CDN$ 83.67 CDN$ 77.56

Save An Additional 10% on Textbooks When you Join Amazon Student
click to open popover

Special Offers and Product Promotions

No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.

  • Apple
  • Android
  • Windows Phone
  • Android

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

Product Details

  • Paperback: 540 pages
  • Publisher: Apress; 1st ed. edition (Dec 23 2011)
  • Language: English
  • ISBN-10: 143024299X
  • ISBN-13: 978-1430242994
  • Product Dimensions: 19 x 3.1 x 23.5 cm
  • Shipping Weight: 1.1 Kg
  • Average Customer Review: Be the first to review this item
  • Amazon Bestsellers Rank: #1,418,712 in Books (See Top 100 in Books)
  •  Would you like to update product info, give feedback on images, or tell us about a lower price?

  • See Complete Table of Contents

Product Description

About the Author

A bio is not available for this author.

Customer Reviews

There are no customer reviews yet on
5 star
4 star
3 star
2 star
1 star

Most Helpful Customer Reviews on (beta) 4.6 out of 5 stars 12 reviews
17 of 18 people found the following review helpful
3.0 out of 5 stars Heavy on practical tips, light on general principles Oct. 7 2008
By Christoffer Swanstrom - Published on
Format: Hardcover Verified Purchase
A very hands-on book about implementing a Data Warehouse using Microsoft SQL Serveer 2005. In fact, it is a bit too hands-on in the sense that it guides you through all clicks and keystrokes but is rather thin and vague on general design principles.

The author has set out to write "a book containing all the essential subjects of building a data warehouse" (quote from the introduction). However, given the breadth of the material the author tries to cover (and given the sometimes annoyingly plentiful screenshots and SQL code) there is not enough room to give the necessary background and generalize the examples enough to be more useful than just that, examples.

For a much better attempt to cover both principles and a specific platform, a much better choice is The Microsoft Data Warehouse Toolkit (by Joy Mundy and Warren Thornthwaite), also covering SQL Server 2005.

For someone looking for just the practical part on how to use the Microsoft tools (SQL Server, SSIS, SSAS) to implement a Data Warehouse and already knows the general principles of data warehousing is probably better off buying a book or several books that cover just those specific tools.
9 of 9 people found the following review helpful
5.0 out of 5 stars Definitely a book for the doers, excellent ETL part June 22 2008
By Jiang Tang - Published on
Format: Hardcover
I have read all the major DW books for sql server. All of them fall short in practicality. This book is deceivingly thin (500 some pages), but it covers all the practical side of building a data warehouse using SQL server 2005. The author's experience shows through his handling of many of the practical issues encountered in implementing data warehouse. This book has excellent coverage on ETL process, oftentimes list several alternatives that suited people from different background.
8 of 9 people found the following review helpful
5.0 out of 5 stars An essential read. Practical & easy to understand. March 7 2008
By SQL DBA/Developer - Published on
Format: Hardcover
This book is a must read for anyone embarking on a Data Warehouse project or who wants to learn more about a particular aspect of Data Warehousing. The book guides the reader through the principles underpinning Data Warehousing, with easy to understand definitions. It gives detailed insight into the design, build & testing phases essential to any successful Data Warehousing project. It even covers reporting; including using the Data Warehouse for Business Intelligence and Customer Relationship Management. Throughout the book the author describes potential problems and gives techniques on how to overcome them.
There are tons of practical examples from an author who has a wealth of technical experience in this field.

This book is highly recommended.
2 of 2 people found the following review helpful
5.0 out of 5 stars Excellent roadmap book for building a data warehouse Feb. 21 2010
By dwarch - Published on
Format: Hardcover Verified Purchase
I can tell - this author has built real data warehouses. This book has so many real world application concepts, distilled into less than 500 pages. I.E. it is not not a bible book, that which puts you to sleep, although it is a great reference book. It is Inmon and Kimball agnostic - huge benefit here. While the DW toolkit books are great, they are only great for Kimball warehouses. Being in the Inmon camp, I appreciate the authors' coverage of the concepts of the Operational Data Store, and Normalized Data Store. This book should be the first book you read in building a data warehouse. Although the specific sql code examples show SQL Server code, all concepts can be applied to Oracle, etc. Only a couple complaints. There is a lack of coverage for modeling localization, i.e. modeling for local language requirements of the users. The author should also mention that Data Modeling tools, such as ErWin, PowerDesigner (best IMO), or ER/Studio can really enhance metadata modeling, and documentation, although he covers metadata very well. That aside, I still give this book a 5 star rating, in lieu of all the theory books out there, which lack real world application examples.
2 of 2 people found the following review helpful
5.0 out of 5 stars I love this book Oct. 12 2012
By aussiejim - Published on
Format: Kindle Edition Verified Purchase
This book is the best book I have read thus far on data warehousing that combines simple and practical explanations and "how to" for all the key aspects.
It is just what I had been looking for, simple explanations and all the information needed for someone starting out who wants to know and actually do the process of building a data warehouse from scratch in the MS environment.
I prefer this to the MS Data Warehouse Toolkit which is also a good book but makes far too many assumptions on readers prior knowledge.
I am so glad I found this book.
15 stars if it was possible :-)