Building Your Data Warehouse

The following are data warehousing topics that Michelle A. Poolet will be covering in upcoming Solutions by Design articles, which will be featured in SQL Server Magazine. Michelle has designed this series to address the critical needs of our readers who are building data warehouses in preparation for decision support systems or business intelligence (BI) efforts. A well-designed and implemented data warehouse is key to the success of all projects using the data in a warehouse. Michelle would like to know what you think about these topic areas. Join the data warehousing discussions in the SQL Server Database Design and Development forum at http://www.sqlmag.com/go/dbdesign.

Data warehousing fundamentals, the star schema (Discover the Star Schema)

Fact table (measures) logical design (Data Warehousing: Measuring the Facts)

Dimension table (logical design) (Data Warehousing: Dimension Basics)

Conforming facts and dimensions: the data warehouse bus architecture (The Data Warehouse Bus Architecture)

Data warehouse roles (Data Warehousing: Dimensional Role-Playing)

Slowly Changing Dimensions (Data Warehousing: Slowly Changing Dimensions)

Rapidly Changing Monster Dimensions (Data Warehousing: Rapidly Changing Monster Dimensions)

Horizontally Partitioning the Fact Table (Data Warehousing: Horizontally Partitioning the Fact Table)

Junk Dimensions (Data Warehousing: Junk Dimensions)

Degenerate Dimensions (Data Warehousing: Degenerate Dimensions)

Many-to-Many Relationships in the Data Warehouse (Many-to-Many Relationships in the Data Warehouse)

Indexing the Data Warehouse (Indexing the Data Warehouse)

NULL in the Data Warehouse

What's Your Data Warehouse Style?

Table Design for Fundamental BI Queries

Fine-tuning the Dimension

Building an Audit Trail in the Data Warehouse

Deduplication: Getting Rid of Redundancy in the Data Warehouse