
Desertcart purchases this item on your behalf and handles shipping, customs, and support to Ireland.
๐ Build your data empire with confidence โ donโt get left behind!
Building a Data Warehouse: With Examples in SQL Server is a practical guide for professionals aiming to design, build, and maintain a data warehouse using SQL Server 2005 or later. Covering everything from architecture and data modeling to ETL processes, testing, and administration, this book equips readers with real-world examples and expert troubleshooting tips to ensure successful data warehousing projects.
| Best Sellers Rank | 1,748,838 in Books ( See Top 100 in Books ) 197 in SQL Databases 607 in Database Applications 614 in Database Management Systems (Books) |
| Customer Reviews | 4.3 out of 5 stars 39 Reviews |
H**Y
Simply one of the best books
I found the book very useful, it covers all areas of Data warehouse and SQL server BI Tools
A**R
Great book on Data Warehousing
Excellent book. Very informative about Data Warehousing.Good way to learn or build on exising knowledge. Covers all the concepts on Data Warehousing.
A**X
Five Stars
Great
M**Y
A must read for DWH Professionals
I really like the writing style of the author, the world of data is awash with vague buzzwords that are hard to define let alone understand. The author explains all the topics within the book wit great clarity and is simple terms. I consider this to be a must have book for senior managers through to developers.
A**R
One of the best DWH book in market
I am finding this book extremely useful. One of the best things of this book is very good set of examples, which helps to understand concepts very easily. I am currently working on datawarehousing project and I can relate these examples to my day-to-day project work and they are very helpful. I recommend this book for a beginner and advanced users for clear understanding on datawarehousing concepts.
A**H
A must have book
This is an excellent book, highly recommendable for all levels of users on Data Warehousing projects. The author has written this book taking an extreme care covering all aspects of Data Warehousing with all the concepts and techniques well explained. I found this book to be extremely useful taking my first steps into the Data Warehousing world!
V**H
Excellent DW Book
Essential reading for anyone interested in DW, from DW concepts to real-life examples the book covers it all in great detail. Very good book from a knowledgable author
D**H
Excellent roadmap book for building a data warehouse
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.
C**M
Heavy on practical tips, light on general principles
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.
T**N
Everything you need on data warehousing
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.
R**A
Awesome Book!
This is a fantastic book!! Great case study and author does a great job teaching a complex problem very clearly. Love it!!
Trustpilot
2 weeks ago
1 month ago