The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Businss Intelligence -- About the Authors -- Contents at a Glance -- Contents -- Introduction -- Intended Audience and Goals -- Preview of Contents -- Navigation Aids -- Terminology Notes -- Chapter 1: The Reader at a Glance -- Setting Up for Success -- Tackling DW/BI Design and Development -- Chapter 2: Before You Dive In -- Historical Perspective -- Dealing with Demanding Realities -- Chapter 3: Project/Program Planning -- Professional Responsibilities -- Justification and Sponsorship -- Kimball Methodology -- Chapter 4: Requirements Definition -- Gathering Requirements -- Organizing around Business Processes -- Wrapping Up the Requirements -- Chapter 5: Data Architecture -- Making the Case for Dimensional Modeling -- Enterprise Data Warehouse Bus Architecture -- Integration Instead of Centralization -- Contrast with the Corporate Information Factory -- Chapter 6: Dimensional Modeling Fundamentals -- Basics of Dimensional Modeling -- Dos and Don'ts -- Myths about Dimensional Modeling -- Chapter 7: Dimensional Modeling Tasks and Responsibilities -- Design Activities -- Design Review Activities -- Chapter 8: Fact Table Core Concepts -- Granularity -- Types of Fact Tables -- Parent-Child Fact Tables -- Fact Table Keys and Degenerates -- Miscellaneous Fact Table Design Patterns -- Chapter 9: Dimension Table Core Concepts -- Dimension Table Keys -- Date and Time Dimension Considerations -- Miscellaneous Dimension Patterns -- Slowly Changing Dimensions -- Chapter 10: More Dimension Patterns and Case Studies -- Snowflakes, Outriggers, and Bridges -- Dealing with Hierarchies -- Customer Issues -- Addresses and International Issues -- Industry Scenarios and Idiosyncrasies -- Chapter 11: Back Room ETL and Data Quality -- Planning the ETL System -- Data Quality Considerations.

Populating Fact and Dimension Tables -- Supporting Real Time -- Chapter 12: Technical Architecture Considerations -- Overall Technical/System Architecture -- Presentation Server Architecture -- Front Room Architecture -- Metadata -- Infrastructure and Security Considerations -- Chapter 13: Front Room Business Intelligence Applications -- Delivering Value with Business Intelligence -- Implementing the Business Intelligence Layer -- Mining Data to Uncover Relationships -- Dealing with SQL -- Chapter 14: Maintenance and Growth Considerations -- Deploying Successfully -- Sustaining for Ongoing Impact -- Article Index -- Index.