| | |  | Manager's Guides to Computing | Home » » » Building a Data Warehouse: With Examples in SQL Server (Expert's Voice) | | | | | | | Description: | | The book is intended to contain practical explanations of essential topics in implementing a data warehouse that everybody who wishes to embark on a data warehousing journey will need to understand in order to build their first data warehouse. Not only that, but they get the SQL Server code so that they can go ahead and implement the data warehouse, create reports, utilize business intelligence, CRM, and more. Essentially, it is a field guide for data warehousing implementation. | | | Product Details: | | | Author:
| Vincent Rainardi | | Hardcover:
| 523 pages | | Publisher:
| Apress | | Publication Date:
| December 27, 2007 | | Language:
| English | | ISBN:
| 1590599314 | | Product Width:
| 183.0 centimeters | | Product Height:
| 237.5 centimeters | | Product Weight:
| 2.24 pounds | | Package Length:
| 9.29 inches | | Package Width:
| 7.01 inches | | Package Height:
| 1.34 inches | | Package Weight:
| 2.25 pounds | | Average Customer Rating:
|  based on 6 reviews |
| | | | Customer Reviews: | |
Average Customer Review:
 ( 6 customer reviews )
Write an online review and share your thoughts with other customers.
Most Helpful Customer Reviews
12 of 12 found the following review helpful:
 Heavy on practical tips, light on general principlesOct 07, 2008
By Christoffer Swanstrom
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.
6 of 6 found the following review helpful:
 Definitely a book for the doers, excellent ETL partJun 23, 2008
By Jiang Tang
"Bookworm"
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.
7 of 8 found the following review helpful:
An essential read. Practical & easy to understand.Mar 07, 2008
By SQL DBA/Developer
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.
1 of 1 found the following review helpful:
Excellent roadmap book for building a data warehouseFeb 21, 2010
By David Dumas
"DataWarehouseTrenches"
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.
1 of 1 found the following review helpful:
Everything you need on data warehousingSep 27, 2009
By A. Scarlat
An excellent book on data warehousing: well structured, methodical and didactical.
Assuming little knowledge on behalf of the reader it goes thru all the principles and down to earth examples related to building a state of the art DW: requirements analysis, the differences between transactional and DW systems, differences between the normalized models and the dimensional / multi-dimensional databases, extract-transform-load (ETL) as well as ELT, data quality assurance processes, metadata, architectural considerations, business intelligence applications, cubes slice and dice, analytical requirements, populating and testing a DW as well as maintenance and configuration changes.
The book is using a real life scenario of a large organization having multi-media stores on several continents as well as a web based e-commerce presence and provides numerous examples of MS SQL 2005 (which are supposed to be similar to MS SQL 2008).
The only disadvantage I found is that if one does not intend to follow the SQL as verbatim there are quite a lot of pages which do not contribute much to the reader. It would have been better if the SQL lengthy examples were left on the book web site for download.
Still - a great, easy to read book that will bring you up-to-speed on the subject of data warehousing without much pain of boredom.
See all 6 customer reviews on Amazon.com
| | |
|
