Table of 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 -- Before Data Warehousing -- 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 -- Agile Project Considerations -- 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 Degenerate Dimensions -- 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 Considerations -- 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 -- Chapter 15: Final Thoughts -- Key Insights and Reminders -- A Look to the Future -- Article Index -- Index -- End User License Agreement.