intelab
.cn
文章
资源
关于
资源中心
/
Kimball
/
文章
文章
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