Winter Driving Best Books of the Month Men's Leather Watches Learn more nav_sap_SWP_6M_fly_beacon $5 Albums Explore Home Audio All-New Amazon Fire TV Beauty V-Day Valentine's Day Cards Knock snow out cold Amazon Gift Card Offer girls2 girls2 girls2  Amazon Echo All-New Fire Kindle Paperwhite Shop Now Sale
Customer Review

11 of 11 people found the following review helpful
4.0 out of 5 stars Essential Reading for Data Warehousing with SQL Server 2005, July 4, 2007
Verified Purchase(What's this?)
This review is from: The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset (Paperback)
Having spent more time doing data warehousing than reading about it, I didn't realize what a phenomenon the Kimball Method had become. I was interviewing with a company that mentioned Kimball and wanted to use his methods to build a data warehouse on SQL Server 2005, so I turned to Amazon, found this book, used my Amazon Prime to get the tome and got the job. So how was the book? Honestly, it covers the Kimball Method well and most experienced analysts will not find much new other than the jargon. The practical advice from Mundy and Thornthwaite is valuable and will help you make some practical decisions on implementation, if not spell out all the steps. My feeling was that if you are comfortable with implementing data marts or data warehouses, this book will give you the advice you need for setting up a SQL Server 2005 data warehouse and implementing Analysis Services. For a more in depth look at how to implement Analysis Services, I recommend Melomed's book as a follow on.

The only complaint I have with this book is it over sells SQL Server Integration Services (SSIS) as an ETL tool. That is probably Mundy's Microsoft viewpoint speaking rather than actual experience with the tool. After using SSIS, I look at it as Data Transformation Services (DTS) with a nice face on it, but really its just lipstick on the same pig. I have picked up several books on SSIS to try find out how to do all the wonderful things it promises, but they pretty much echo the documentatiion, so I can't really recommend any of them.

Overall, this is book well worth reading. After spending the last year on an Oracle/Teradata project, its refreshing to get back to SQL Server 2005 and Analysis Services. If you are just making the jump to data warehousing on SQL Server 2005, this is a must read. If you are already familiar with Kimball, you will skip a lot but get some good implementation advice and that makes it worth the price. If you want to know more about MDX or SSIS, this isn't what you are looking for.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

[Add comment]
Post a comment
To insert a product link use the format: [[ASIN:ASIN product-title]] (What's this?)
Amazon will display this name with all your submissions, including reviews and discussion posts. (Learn more)
Name:
Badge:
This badge will be assigned to you and will appear along with your name.
There was an error. Please try again.
Please see the full guidelines here.

Official Comment

As a representative of this product you can post one Official Comment on this review. It will appear immediately below the review wherever it is displayed.   Learn more
The following name and badge will be shown with this comment:
 (edit name)
After clicking the Post button you will be asked to create your public name, which will be shown with all your contributions.

Is this your product?

If you are the author, artist, manufacturer or an official representative of this product, you can post an Official Comment on this review. It will appear immediately below the review wherever it is displayed.  Learn more
Otherwise, you can still post a regular comment on this review.

Is this your product?

If you are the author, artist, manufacturer or an official representative of this product, you can post an Official Comment on this review. It will appear immediately below the review wherever it is displayed.   Learn more
 
System timed out

We were unable to verify whether you represent the product. Please try again later, or retry now. Otherwise you can post a regular comment.

Since you previously posted an Official Comment, this comment will appear in the comment section below. You also have the option to edit your Official Comment.   Learn more
The maximum number of Official Comments have been posted. This comment will appear in the comment section below.   Learn more
Prompts for sign-in
 

Comments

Tracked by 1 customer

Sort: Oldest first | Newest first
Showing 1-1 of 1 posts in this discussion
Initial post: May 15, 2010 9:41:13 AM PDT
It is true that there is an unfortunate dearth of useful information on SSIS in the real world, even now in 2010. However, to compare it to DTS or call it lipstick on a pig is so ludicrous as to defy response.
‹ Previous 1 Next ›