Kimball's Data Warehouse Toolkit Classics, 3 Volume Set

Three books by the bestselling authors on Data Warehousing! The most authoritative guides from the inventor of the technique all for a value price.

The Data Warehouse Toolkit, 3rd Edition (9781118530801) Ralph Kimball invented a data warehousing technique called dimensional modeling and popularised it in his first Wiley book, The Data Warehouse Toolkit. Since this book was first published in 1996, dimensional modeling has become the most widely accepted technique for data warehouse design. Over the past 10 years, Kimball has improved on his earlier techniques and created many new ones. In this 3rd edition, he provides a comprehensive collection of all of these techniques, from basic to advanced.

The Data Warehouse Lifecycle Toolkit, 2^nd Edition (9780470149775) offers complete coverage of best practices from data warehouse project inception through ongoing programme management. It updates industry best practices to be in sync with current recommendations of the Kimball Group and streamlines the lifecycle methodology to be more efficient and user-friendly.

The Data Warehouse ETL Toolkit (9780764567575) shows data warehouse developers how to effectively manage the ETL (Extract, Transform, Load) phase of the data warehouse development lifecycle. The authors demonstrate the best methods for extracting data from scattered sources throughout the enterprise, removing obsolete, redundant, and inaccurate data, transforming the remaining data into correctly formatted data structures, and then physically loading them into the data warehouse.

This book provides complete coverage of proven, time-saving ETL techniques. It begins with a quick overview of ETL fundamentals and the role of the ETL development team. It then quickly moves into an overview of the ETL data structures, both relational and dimensional. The authors show how to build useful dimensional structures, providing practical examples of beginning through advanced techniques.