The Microsoft® Data Warehouse Toolkit, 2nd Edition -- About the Authors -- Credits -- Acknowledgments -- Foreword -- Introduction -- The Data Warehouse and Business Intelligence System -- The Kimball Lifecycle -- How This Book Is Organized -- Additional Information -- On the Website -- Part 1: Requirements, Realities, and Architecture -- Chapter 1: Defining Business Requirements -- The Most Important Determinant of Long-Term Success -- Adventure Works Cycles Introduction -- Uncovering Business Value -- Prioritizing the Business Requirements -- Revisiting the Project Planning -- Gathering Project-Level Requirements -- Summary -- Chapter 2: Designing the Business Process Dimensional Model -- Dimensional Modeling Concepts and Terminology -- Additional Design Concepts and Techniques -- The Dimensional Modeling Process -- Case Study: The Adventure Works Cycles Orders Dimensional Model -- Summary -- Chapter 3: The Toolset -- The Microsoft DW/BI Toolset -- Why Use the Microsoft Toolset? -- Architecture of a Microsoft DW/BI System -- Overview of the Microsoft Tools -- Summary -- Chapter 4: System Setup -- System Sizing Considerations -- System Configuration Considerations -- Software Installation and Configuration -- Summary -- Part 2: Building and Populating the Databases -- Chapter 5: Creating the Relational Data Warehouse -- Getting Started -- Complete the Physical Design -- Define Storage and Create Constraints and Supporting Objects -- Partitioned Tables -- Finishing Up -- Summary -- Chapter 6: Master Data Management -- Managing Master Reference Data -- Introducing SQL Server Master Data Services -- Creating a Simple Application -- Summary -- Chapter 7: Designing and Developing the ETL System -- Round Up the Requirements -- Develop the ETL Plan -- Introducing SQL Server Integration Services -- The Major Subsystems of ETL -- Extracting Data.

Cleaning and Conforming Data -- Delivering Data for Presentation -- Managing the ETL Environment -- Summary -- Chapter 8: The Core Analysis Services OLAP Database -- Overview of Analysis Services OLAP -- Designing the OLAP Structure -- Physical Design Considerations -- Summary -- Chapter 9: Design Requirements for Real-Time BI -- Real-Time Triage -- Scenarios and Solutions -- Summary -- Part 3: Developing the BI Applications -- Chapter 10: Building BI Applications in Reporting Services -- A Brief Overview of BI Applications -- A High-Level Architecture for Reporting -- The Reporting System Design and Development Process -- Building and Delivering Reports -- Ad Hoc Reporting Options -- Summary -- Chapter 11: PowerPivot and Excel -- Using Excel for Analysis and Reporting -- The PowerPivot Architecture: Excel on Steroids -- Creating and Using PowerPivot Databases -- PowerPivot for SharePoint -- PowerPivot's Role in a Managed DW/BI Environment -- Summary -- Chapter 12: The BI Portal and SharePoint -- The BI Portal -- Planning the BI Portal -- Using SharePoint as the BI Portal -- Summary -- Chapter 13: Incorporating Data Mining -- Defining Data Mining -- SQL Server Data Mining Architecture Overview -- Microsoft Data Mining Algorithms -- The Data Mining Process -- Data Mining Examples -- Summary -- Part 4: Deploying and Managing the DW/BI System -- Chapter 14: Designing and Implementing Security -- Identifying the Security Manager -- Securing the Hardware and Operating System -- Securing the Development Environment -- Securing the Data -- Securing the Components of the DW/BI System -- Usage Monitoring -- Summary -- Chapter 15: Metadata Plan -- Metadata Basics -- Metadata Standards -- SQL Server 2008 R2 Metadata -- A Practical Metadata Approach -- Summary -- Chapter 16: Deployment -- Setting Up the Environments -- Testing -- Deploying to Production.

Data Warehouse and BI Documentation -- User Training -- User Support -- Desktop Readiness and Configuration -- Summary -- Chapter 17: Operations and Maintenance -- Providing User Support -- System Management -- Summary -- Chapter 18: Present Imperatives and Future Outlook -- Growing the DW/BI System -- Lifecycle Review with Common Problems -- What We Like in the Microsoft BI Toolset -- Future Directions: Room for Improvement -- Conclusion -- Index.