Customer Reviews


3 Reviews
5 star:
 (3)
4 star:    (0)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
Share your thoughts with other customers
Create your own review
 
 
Most Helpful First | Newest First

6 of 6 people found the following review helpful
5.0 out of 5 stars Brilliantly covers the BI development lifecycle., 15 Jun. 2008
By 
Caryl Wills (Bristol, UK) - See all my reviews
(REAL NAME)   
This review is from: The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset (Computing) (Paperback)
I don't normally enjoy reading technical IT books, but this one was difficult to put down. It covers the whole of the Business Intellegence lifecycle using Microsoft products (namely SQL Server 2005, Inegration Services, Analysis Services and Reporting Services) to build a Kimball Dimensional model data warehouse.

The initial chapters cover the design cycle and reinforce the need to drive the data warehouse design from properly researched client requirements.

It then goes on to implement the design through an ETL process using SQL Server Integration Services. The coverage is complete with particular attention to handling Type 1 and 2 data changes. The Slowly Changing Dimension Task is well described and provokes significant thought about warehouse design.

Designing and building the OLAP database follows with 3 chapters dedicated to Business Intelligence applications, including comprehensive coverage of the role of Reporting Services and Data Mining Modeling. I have found these 3 chapters particularly useful in deciding how to deliver the client side analysis tools.

The final section explains how to setup security, how to deploy your solution, how to manage operations and maintenance and, finally, how to implement Real-Time Business Intelligence in the traditional data warehouse.

A number of tools are available from the books web site, including a well written and fully working (on SQL Server 2005 - needs some small changes for SQL 2008 because the underlying AdventureWorks database is changed in SQL 2008) SSIS package.

This is not a regurgitation of Books On Line, nor is it a step by step 'How To' guide to using Microsoft SQL Server. What it does, and does it brilliantly, is describe in detail the processes that you will need to go through to build a complete working Business Intelligence solution.

It is clear that the authors are proper experts in their field and that many years of experience have been distilled into this book. This is the only one you will need.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


1 of 1 people found the following review helpful
5.0 out of 5 stars Worth every penny!, 25 May 2010
Verified Purchase(What is this?)
This review is from: The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset (Computing) (Paperback)
I've worked in business intelligence and data warehousing for about 7 years now but have only ever had to create/populate a data warehouse using SQL Server 2000 and DTS (Data Transformation Services), so I needed to get up to speed on using SQL Server 2005/2008 and having attended a few webinars (incidentally, one run by Joy Mundy, co-author of this fine book), I decided to grab myself a copy of this title, and it has rarely left my desk since I bought it. I can't give you a full review of absolutely everything that the book covers because there are some areas that we are not using, but the first 6 chapters which bring you up to the point of developing an ETL system are well covered. The books accompanying online material is also extremely useful. I suspect that if you are new to SSIS (SQL Server Integration Services) then you may want to get a copy of a text that covers that aspect alone because whilst the book covers "what you should/could/can do" it doesn't always tell you "how". In particular I was unfamiliar with SSI expression language - but that's where the internet comes in handy (yet again) - although I may be a little unfair as perhaps that sort of stuff is covered in The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data. If you know SSIS (and I guess SSAS), then this book is just about all you will need to build a successfull data warehouse. There are some parts I wish the authors had elaborated on, but in all fairness if you start picking through the books examples (downloadable) then you should be able to figure out how it does things (auditing is a prime example). I can't honestly dock it any stars for my lack of knowledge though. Final bonus ... the price. I've bought books costing more than DOUBLE this (albeit for a different subject area) and they haven't been anywhere near as well written. I wouldn't hesitate in buying any of the books in this series based on my initial reading.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


2 of 3 people found the following review helpful
5.0 out of 5 stars Why the Kimble Group rocks!, 5 April 2009
By 
Robin Everson "Robin Everson" (Redditch, England) - See all my reviews
(REAL NAME)   
Verified Purchase(What is this?)
This review is from: The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset (Computing) (Paperback)
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 builds on the previous Data Warehouse Toolkit, Data Warehouse Lifecycle Toolkit, and Data Warehouse ETL Toolkit books, but it stands on it's own as a self-contained and comprehensive guide. The guide's strength is keeping the explanations in MS SQL2005 context while you learn and harvest the many useful tips provided.

Chain this book to your lap-top as your colleagues will be after it in no time!
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


Most Helpful First | Newest First

This product

Only search this product's reviews