{"product_id":"mastering-data-warehouse-design-isbn-9780471324218","title":"Mastering Data Warehouse Design","description":"\u003cul\u003e \u003cli\u003eA cutting-edge response to Ralph Kimball's challenge to the data warehouse community that answers some tough questions about the effectiveness of the relational approach to data warehousing\u003c\/li\u003e \u003cli\u003eWritten by one of the best-known exponents of the Bill Inmon approach to data warehousing\u003c\/li\u003e \u003cli\u003eAddresses head-on the tough issues raised by Kimball and explains how to choose the best modeling technique for solving common data warehouse design problems\u003c\/li\u003e \u003cli\u003eWeighs the pros and cons of relational vs. dimensional modeling techniques\u003c\/li\u003e \u003cli\u003eFocuses on tough modeling problems, including creating and maintaining keys and modeling calendars, hierarchies, transactions, and data quality\u003c\/li\u003e \u003c\/ul\u003e  Acknowledgments.  \u003cp\u003eAbout the Authors.\u003c\/p\u003e \u003cp\u003ePART ONE: CONCEPTS.\u003c\/p\u003e \u003cp\u003eChapter 1. Introduction.\u003c\/p\u003e \u003cp\u003eChapter 2. Fundamental Relational Concepts.\u003c\/p\u003e \u003cp\u003ePART TWO: MODEL DEVELOPMENT.\u003c\/p\u003e \u003cp\u003eChapter 3. Understanding the Business Model.\u003c\/p\u003e \u003cp\u003eChapter 4. Developing the Model.\u003c\/p\u003e \u003cp\u003eChapter 5. Creating and Maintaining Keys.\u003c\/p\u003e \u003cp\u003eChapter 6. Modeling the Calendar.\u003c\/p\u003e \u003cp\u003eChapter 7. Modeling Hierarchies.\u003c\/p\u003e \u003cp\u003eChapter 8. Modeling Transactions.\u003c\/p\u003e \u003cp\u003eChapter 9. Data Warehouse Optimization.\u003c\/p\u003e \u003cp\u003ePART THREE: OPERATION AND MANAGEMENT.\u003c\/p\u003e \u003cp\u003eChapter 10. Accommodating Business Change.\u003c\/p\u003e \u003cp\u003eChapter 11. Maintaining the Models.\u003c\/p\u003e \u003cp\u003eChapter 12. Deploying the Relational Solution.\u003c\/p\u003e \u003cp\u003eChapter 13. Comparison of Data Warehouse Methodologies.\u003c\/p\u003e \u003cp\u003eGlossary.\u003c\/p\u003e \u003cp\u003eRecommended Reading.\u003c\/p\u003e \u003cp\u003eIndex.\u003c\/p\u003e  \u003cp\u003e\u003cb\u003eCLAUDIA IMHOFF\u003c\/b\u003e (CImhoff@Intelsols.com) is President and Founder of Intelligent Solutions, a leading consultancy on analytic CRM and BI technologies and strategies. She is a popular speaker, an internationally recognized expert, and coauthor of five books.  \u003c\/p\u003e\u003cp\u003e\u003cb\u003eNICHOLAS GALEMMO\u003c\/b\u003e (ngalemmo@yahoo.com) was Information Architect at Nestlé USA. He has twenty-seven years' experience as a practitioner and consultant involved in all aspects of application systems design and development. He is currently an independent consultant.  \u003c\/p\u003e\u003cp\u003e\u003cb\u003eJONATHAN G. GEIGER\u003c\/b\u003e (JGeiger@IntelSols.com) is Executive Vice President at Intelligent Solutions, Inc. In his thirty years as a practitioner and consultant, he has managed or performed work in virtually every aspect of information management.     \t\u003c\/p\u003e\u003cp\u003e\u003cb\u003eAt last, a balanced approach to data warehousing that leverages the techniques pioneered by Ralph Kimball and Bill Inmon\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eSince its groundbreaking inception, the approach to understanding data warehousing has been split into two mindsets: Ralph Kimball, who pioneered the use of dimensional modeling techniques for building the data warehouse, and Bill Inmon, who introduced the Corporate Information Factory and leads those who believe in using relational modeling techniques for the data warehouse. Mastering Data Warehouse Design successfully merges Inmon's data ware- house design philosophies with Kimball's data mart design philosophies to provide you with a compelling and complete overview of exactly what is involved in designing and building a sustainable and extensible data warehouse. \u003c\/p\u003e\u003cp\u003eMost data warehouse managers, designers, and developers are familiar with the open letter written by Ralph Kimball in 2001 to the data warehouse community in which he challenged those in the Inmon camp to answer some tough questions about the effectiveness of the relational approach. Cowritten by one of the best-known experts of the Inmon approach, Claudia Imhoff, this team of authors addresses head-on the challenging questions raised by \u003c\/p\u003e\u003cp\u003eKimball in his letter and offers a how-to guide on the appropriate use of both relational and dimensional modeling in a comprehensive business intelligence environment. In addition, you'll learn the authors' take on issues such as: \u003c\/p\u003e\u003cul\u003e \u003cli\u003eWhich approach has been found most successful in data warehouse environments at companies spanning virtually all major industrial sectors\u003c\/li\u003e \u003cli\u003eThe pros and cons of relational vs. dimensional modeling techniques so developers can decide on the best approach for their projects\u003c\/li\u003e \u003cli\u003eWhy the architecture should include a data warehouse built on relational data modeling concepts\u003c\/li\u003e \u003cli\u003eThe construction and utilization of keys, the historical nature of the data warehouse, hierarchies, and transactional data\u003c\/li\u003e \u003cli\u003eTechnical issues needed to ensure that the data warehouse design meets appropriate performance expectations\u003c\/li\u003e \u003cli\u003eRelational modeling techniques for ensuring optimum data warehouse performance and handling changes to data over time\u003c\/li\u003e \t\u003c\/ul\u003e","brand":"Wiley","offers":[{"title":"Default Title","offer_id":47989580857573,"sku":"NP9780471324218","price":45.0,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1842\/7735\/files\/9780471324218.jpg?v=1761784682","url":"https:\/\/k12savings.com\/es\/products\/mastering-data-warehouse-design-isbn-9780471324218","provider":"K12savings","version":"1.0","type":"link"}