文档介绍：Table of Contents
Cover
Title Page
Copyright
About the Authors
Credits
Acknowledgments
Foreword
Introduction
The Data Warehouse and Business Intelligence System
The Kimball Lifecycle
How This Book anized
Additional Information
On the Website
Part 1: Requirements, Realities, and Architecture
Chapter 1: Defining Business Requirements
The Most Important Determinant of Long-Term ess
2
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
3
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
4
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