List of Figures

Chapter 1: Basic Components

Figure 1.1: A one-star dimensional schema

Chapter 9: Regular Population Scheduling

Figure 9.1: The first window of the Scheduled Task Wizard

Figure 9.2: Selecting an application to schedule

Figure 9.3: Entering a name and select a schedule

Figure 9.4: Setting the time

Figure 9.5: Entering Windows user name and password to run the task

Figure 9.6: The next window

Figure 9.7: The Advanced Properties window

Figure 9.8: Setting account information

Figure 9.9: Your DW Regular Load task

Chapter 10: Adding Columns

Figure 10.1: New columns in customer_dim and sales_order_fact

Chapter 11: On-Demand Population

Figure 11.1: The new promo_ind column in date_dim

Chapter 13: Dimension Role Playing

Figure 13.1: Adding request_delivery_date to sales_order_fact

Chapter 14: Snapshots

Figure 14.1: The schema for the sales order monthly snapshot

Figure 14.2: The schema for accumulating snapshots

Chapter 15: Dimension Hierarchies

Figure 15.1: Schema Showing Hierarchies

Chapter 16: Multi-Path and Ragged Hierarchies

Figure 16.1: The schema after adding campaign_session

Chapter 17: Degenerate Dimensions

Figure 17.1: The schema with the order dimension degenerated

Chapter 18: Junk Dimensions

Figure 18.1: The schema with the sales_order_attribute_dim junk dimension

Chapter 19: Multi-Star Schemas

Figure 19.1: A three-star dimensional data warehouse schema

Chapter 21: Factless Facts

Figure 21.1: Fact-less fact table

Chapter 23: Dimension Consolidation

Figure 23.1: The schema after zip_code_dim is added

Chapter 24: Accumulated Measures

Figure 24.1: The month_end_balance_fact, product_dim, and month_dim tables create a new star

Chapter 25: Band Dimensions

Figure 25.1: The annual sales order schema with the annual_order_segment_dim band dimension