{"product_id":"the-data-warehouse-toolkit","title":"The Data Warehouse Toolkit","description":"\u003cp\u003e\u003cb\u003eThe most authoritative and comprehensive guide to dimensional modeling, from its originators—fully updated\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eRalph Kimball introduced the industry to the techniques of dimensional modeling in the first edition of \u003ci\u003eThe Data Warehouse Toolkit\u003c\/i\u003e (1996). Since then, dimensional modeling has become the most widely accepted approach for presenting information in data warehouse and business intelligence (DW\/BI) systems. \u003ci\u003eThe Data Warehouse Toolkit\u003c\/i\u003e is recognized as the definitive source for dimensional modeling techniques, patterns, and best practices.\u003c\/p\u003e \u003cp\u003eThis third edition of the classic reference delivers the most comprehensive library of dimensional modeling techniques ever assembled. Fully updated with fresh insights and best practices, this book provides clear guidelines for designing dimensional models—and does so in a style that serves the needs of those new to data warehousing as well as experienced professionals.\u003c\/p\u003e \u003cp\u003eAll the techniques in the book are illustrated with real-world case studies based on the authors' actual DW\/BI design experiences. In addition, the Kimball Group's \"official\" list of dimensional modeling techniques is summarized in a single chapter for easy reference, with pointers from each technique to the case studies where the concepts are brought to life.\u003c\/p\u003e \u003cp\u003eThe third edition of \u003ci\u003eThe Data Warehouse Toolkit\u003c\/i\u003e covers:\u003c\/p\u003e \u003cul\u003e \u003cli\u003ePractical design techniques—both basic and advanced—for dimension and fact tables\u003c\/li\u003e \u003cli\u003e14 case studies, including retail sales, electronic commerce, customer relationship management, procurement, inventory, order management, accounting, human resources, financial services, healthcare, insurance, education, telecommunications, and transportation\u003c\/li\u003e \u003cli\u003eSample data warehouse bus matrices for 12 case studies\u003c\/li\u003e \u003cli\u003eDimensional modeling pitfalls and mistakes to avoid\u003c\/li\u003e \u003cli\u003eEnhanced slowly changing dimension techniques type 0 through 7\u003c\/li\u003e \u003cli\u003eBridge tables for ragged variable depth hierarchies and multivalued attributes\u003c\/li\u003e \u003cli\u003eBest practices for Big Data analytics\u003c\/li\u003e \u003cli\u003eGuidelines for collaborative, interactive design sessions with business stakeholders\u003c\/li\u003e \u003cli\u003eAn overview of the Kimball DW\/BI project lifecycle methodology\u003c\/li\u003e \u003cli\u003eComprehensive review of extract, transformation, and load (ETL) systems and design considerations\u003c\/li\u003e \u003cli\u003eThe 34 ETL subsystems and techniques to populate dimension and fact tables\u003c\/li\u003e \u003c\/ul\u003e","brand":"Margy Ross","offers":[{"title":"Default Title","offer_id":42818230059069,"sku":"9781118530801","price":94.46,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0597\/7689\/2989\/files\/9781118530801_3c586c58-ca8e-4a36-bc28-4d5274a1ad0e.jpg?v=1766916966","url":"https:\/\/www.palmleaf.com.au\/products\/the-data-warehouse-toolkit","provider":"Palmleaf","version":"1.0","type":"link"}