Menu
Base SAS
Enterprise Miner Books
Information
Payment Methods
Shipping
Safe Shopping
Contact Us
Tutorials
SAS Tutorials
Partners
Technology News
SAS & RSS feeds
SAS Resources

 

Business Intelligence Books - The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin

The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin
List Price: $45.00
Our Price: $31.18
Your Save: $ 13.82 ( 31% )
Availability: Usually ships in 24 hours
Manufacturer: Wiley
Average Customer Rating: Average rating of 5.0/5Average rating of 5.0/5Average rating of 5.0/5Average rating of 5.0/5Average rating of 5.0/5

Buy it now at Amazon.com!

Binding: Paperback
Dewey Decimal Number: 005.74
EAN: 9780764567575
ISBN: 0764567578
Label: Wiley
Manufacturer: Wiley
Number Of Items: 1
Number Of Pages: 528
Publication Date: 2004-09-13
Publisher: Wiley
Studio: Wiley

Related Items

Editorial Reviews:

* Cowritten by Ralph Kimball, the world's leading data warehousing authority, whose previous books have sold more than 150,000 copies
* Delivers real-world solutions for the most time- and labor-intensive portion of data warehousing-data staging, or the extract, transform, load (ETL) process
* Delineates best practices for extracting data from scattered sources, removing redundant and inaccurate data, transforming the remaining data into correctly formatted data structures, and then loading the end product into the data warehouse
* Offers proven time-saving ETL techniques, comprehensive guidance on building dimensional structures, and crucial advice on ensuring data quality


Spotlight customer reviews:

Customer Rating: Average rating of 5/5Average rating of 5/5Average rating of 5/5Average rating of 5/5Average rating of 5/5
Summary: Another Kimball Toolkit
Comment: In my estimation The Data Warehouse ETL Toolkit is a good source of information for the topic that covers the majority of your Data Warehouse efforts, the ETL process (or ECCD if you prefer, which you probably will after finishing this volume). I took away some good ideas on items that I probably would not have considered, mostly due to my own ignorance, relating to Meta Data, QA and Error Corrections, Data Lineage and Scoring, etc.

The Authors (Kimball and Caserta) do a good job of pointing out other source books for items that the user will probably want to look at in depth.

There is also a pretty good section explaining how to manage your ETL project, the different roles of people who should be involved and a pretty good project plan / checklist to use as you are getting started.

My only complaint is that I did not read this prior to starting my own project and am instead having to correct items as I try to implement these best practices.

Customer Rating: Average rating of 5/5Average rating of 5/5Average rating of 5/5Average rating of 5/5Average rating of 5/5
Summary: The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning
Comment: The book was mailed well within time mentioned by seller and is a new book.

Customer Rating: Average rating of 5/5Average rating of 5/5Average rating of 5/5Average rating of 5/5Average rating of 5/5
Summary: ETL Toolkit
Comment: A great basic tool book for datawarehousing and ETL. I've purchased for my teams here and in India.

Customer Rating: Average rating of 4/5Average rating of 4/5Average rating of 4/5Average rating of 4/5Average rating of 4/5
Summary: Good for anyone who wants to Learn ETL
Comment: This book gives practical guidelines to follow through the ETL cycle, it does not matter if you are using an Industry Standard ETL tool or writing your own ETL process from scratch, this book will be useful for both. I found it very useful. Definitely worth a read for anyone who is new to ETL.

Customer Rating: Average rating of 5/5Average rating of 5/5Average rating of 5/5Average rating of 5/5Average rating of 5/5
Summary: Another tool in the shed
Comment: This is a very good book from the Data Warehouse toolkit series by Ralph Kimball et al. This one is all about ETL - extract, transform and load, although the authors may put it a little bit different sometime:

[quote]
We expand the traditional ETL steps of extract, transform, and load into the more actionable steps of extract, clean, conform, and deliver, although we resist the temptation to change ETL into ECCD!
[/quote]

Anyhow, ETL or ECCD, it's the same thing - fetching the data from your live operational systems and putting it in your data warehouse.

The book thoroughly covers the entire ETL process. Believe me, I tried to squeeze a digest here. A few times. It goes out of hand. A lot, a huge lot of all sorts of information. Useful, extensive, clear and interesting to read.

Having read the first (?) book in the series - The Complete Guide to Dimensional Modeling -
helps greatly in understanding, because this book uses the same (standard) terminology - dimensions, facts, and so on.

Probably the only thing to whine about is the pictures. They could have definitely been better. Some of them are cryptic and some of them have no real value. Let's put it this way - some of the pictures do not help.

Anyhow, great book.


Buy it now at Amazon.com!

 
Copyright © 2000-2004 Business Intelligence Books. All rights reserved.
powered by My Amazon Store Manager v 2.0, © Stringer Software Solutions