文章

70 篇官方文章，按年份归档。最早可追溯至 1995 年 12 月。

2015

12/01 Design Tip #180 The Future Is Bright 11/05 Design Tip #179 Key Tenets of the Kimball Method 10/01 Design Tip #178 Tried and True Concepts for DW-BI Success 09/01 Design Tip #177 Final Word of the Day: Collaboration 07/28 Design Tip #176 Dimensional Models – Logical or Physical? 06/08 Design Tip #175 There is No Database Magic 05/06 Design Tip #174 Does Your Organization Need an Analytic Sandbox? 03/09 Design Tip #173 Risky Project Resources are Risky Business 02/02 Design Tip #172 Leverage Your Dimensional Model for Predictive Analytics 01/05 Design Tip #171 Unclogging the Fact Table Surrogate Key Pipeline

2014

07/21 Design Tip #168 What’s in a Name? 06/17 Design Tip #167 Complementary Fact Table Types 05/14 Design Tip #166 Potential Bridge (Table) Detours 03/03 Design Tip #164 Have You Built Your Audit Dimension Yet? 01/07 Design Tip #162 Leverage Data Visualization Tools, But Avoid Anarchy

2013

08/05 Design Tip #158 Making Sense of the Semantic Layer 06/02 Design Tip #156 An Excel Macro for Drilling Across 05/01 Design Tip #155 Going Agile? Start with the Bus Matrix 02/05 Design Tip #152 Slowly Changing Dimension Types 0, 4, 5, 6 and 7

2012

07/10 Design Tip #147 Durable “Super-Natural” Keys 05/01 Design Tip #145 Timespan Accumulating Snapshot Fact Tables 02/01 Design Tip #142 Building Bridges

2011

11/01 Design Tip #140 Is it a Dimension, a Fact, or Both? 08/02 Design Tip #137 Creating and Managing Shrunken Dimensions 06/01 Design Tip #135 Conformed Dimensions as the Foundation for Agile Data Warehousing 05/04 Design Tip #134 Data Warehouse Testing Recommendations 04/05 Design Tip #133 Factless Fact Tables for Simplification

2010

12/01 Design Tip #130 Accumulating Snapshots for Complex Workflows 10/06 Design Tip #128 Selecting Default Values for Nulls 09/13 Industry Standard Data Models Fall Short 09/01 Design Tip #127 Creating and Managing Mini-Dimensions 02/02 Design Tip #120 Design Review Dos and Don’ts

2009

10/09 Six Key Decisions for ETL Architectures 08/04 Design Tip #115 Kimball Lifecycle in a Nutshell 06/03 Design Tip #113 Creating, Using, and Maintaining Junk Dimensions 05/29 The 10 Essential Rules of Dimensional Modeling 03/04 Design Tip #110 More Business Requirements Gathering Dos and Don’ts

2008

11/06 Design Tip #107 Using the SQL MERGE Statement for Slowly Changing Dimension Processing 11/05 Fact Tables 09/22 Slowly Changing Dimensions, Part 2 09/03 Design Tip #105 Snowflakes, Outriggers, and Bridges 08/21 Slowly Changing Dimensions

2007

12/11 Design Tip #97 Modeling Data as Both a Fact and Dimension Attribute 10/21 Subsystems of ETL Revisited 10/20 White Paper: An Architecture for Data Quality 10/02 Design Tip #95 Patterns to Avoid when Modeling Header/Line Item Transactions 07/30 Keep to the Grain in Dimensional Modeling

2006

07/06 Design Tip #81 Fact Table Surrogate Key 06/01 Design Tip #80 Adding a Row Change Reason Attribute

2005

12/01 The Matrix: Revisited 03/10 Slowly Changing Dimensions Are Not Always as Easy as 1, 2, 3

2004

10/10 Fables and Facts 03/03 Differences of Opinion 02/01 Design Tip #51: Latest Thinking On Time Dimension Tables 01/01 Data Warehouse Dining Experience

2003

10/10 Fistful of Flaws 06/03 Design Tip #46: Another Look At Degenerate Dimensions 04/05 The Soul of the Data Warehouse, Part 2: Drilling Across 03/20 The Soul of the Data Warehouse, Part 1: Drilling Down 03/01 Declaring the Grain 02/06 Design Tip #43: Dealing With Nulls In The Dimensional Model 01/01 Fact Tables and Dimension Tables

2002

11/06 Design Tip #41: Drill Down into a More Detailed Bus Matrix 09/17 Two Powerful Ideas

1999

12/07 The Matrix

1998

12/02 Think Globally, Act Locally 05/02 Surrogate Keys

1997

08/02 A Dimensional Modeling Manifesto 双语 07/10 It's Time for Time

1995

12/01 Data Warehouse Insurance