The MicrosoftВ Data Warehouse Toolkit: With SQL ServerВ 2005 and the MicrosoftВ Business Intelligence Toolset

Introduction

Table 1: The Core Kimball Data Warehouse Toolkit Titles

Chapter 1: Defining Business Requirements

Table 1.1: Adventure Works Cycles Product Orders by Category

Table 1.2: Adventure Works Cycles Product Orders by Country/Region

Table 1.3: Adventure Works Cycles Product Orders by Sales Channel

Table 1.4: Adventure Works Cycles Customers by Sales Channel Snapshot

Table 1.5: Business Processes Derived from Brian Welkers Interview

Chapter 2: Designing the Business Process Dimensional Model

Table 2.1: Example Customer Dimension Table Row as of Jan 1, 2006

Table 2.2: Example Order Fact Table Rows for Jane Rider as of Feb 22, 2006

Table 2.4: Updated Order Fact Table Rows for Jane Rider as of Feb 22, 2006

Table 2.3: Example Customer Dimension Table Row as of Jan 2, 2006 with a Type 2 Change

Table 2.5: Major Participants in Creating the Dimensional Model

Chapter 9: Building the BI Application in Reporting Services

Table 9.1: User Requirements and Functional Implications

Chapter 10: Incorporating Data Mining

Table 10.1: Examples of Business Tasks and Associated Algorithms

Table 10.2: The Primary Data Mining Datasets

Table 10.3: The City Economic Data Training Set After Data Preparation

Table 10.4: City Economic Data Listed by Cluster

Table 10.5: Additional Transformations Used to Create the Example Case Set

Table 10.6: Recommendations Model Validation Data Points

Chapter 12: Security

Table 12.1: Summary of Approaches for Implementing Data Access Security

Chapter 13: Metadata Plan

Table 13.1: Metadata Sources and Stores in the SQL Server 2005 BI Platform

Chapter 16: Managing Growth

Table 16.1: BI System Stakeholders and Engagement Tools

Chapter 17: Real-Time Business Intelligence

Table 17.1: Methods for Delivering Real-Time Data

Table 17.2: Methods for Receiving Notification of Data Changes