Skip to content
corpus.blogBeta
All posts

kimballgroup.com

kimballgroup.com

2015

Design Tip #180 The Future Is BrightRead at kimballgroup.com (opens in a new tab)
1 Dec 2015
Design Tip #179 Key Tenets of the Kimball MethodRead at kimballgroup.com (opens in a new tab)
5 Nov 2015
Design Tip #178 Tried and True Concepts for DW-BI SuccessRead at kimballgroup.com (opens in a new tab)
1 Oct 2015
Design Tip #177 Final Word of the Day: CollaborationRead at kimballgroup.com (opens in a new tab)
1 Sept 2015
Design Tip #176 Dimensional Models – Logical or Physical?Read at kimballgroup.com (opens in a new tab)
28 Jul 2015
Design Tip #175 There is No Database MagicRead at kimballgroup.com (opens in a new tab)
8 Jun 2015
Design Tip #174 Does Your Organization Need an Analytic Sandbox?Read at kimballgroup.com (opens in a new tab)
7 May 2015
Design Tip #173 Risky Project Resources are Risky BusinessRead at kimballgroup.com (opens in a new tab)
9 Mar 2015
Design Tip #172 Leverage Your Dimensional Model for Predictive AnalyticsRead at kimballgroup.com (opens in a new tab)
2 Feb 2015
Design Tip #171 Unclogging the Fact Table Surrogate Key PipelineRead at kimballgroup.com (opens in a new tab)
5 Jan 2015

2014

Design Tip #168 What’s in a Name?Read at kimballgroup.com (opens in a new tab)
21 Jul 2014
Design Tip #167 Complementary Fact Table TypesRead at kimballgroup.com (opens in a new tab)
17 Jun 2014
Design Tip #166 Potential Bridge (Table) DetoursRead at kimballgroup.com (opens in a new tab)
14 May 2014
Design Tip #164 Have You Built Your Audit Dimension Yet?Read at kimballgroup.com (opens in a new tab)
4 Mar 2014
Design Tip #162 Leverage Data Visualization Tools, But Avoid AnarchyRead at kimballgroup.com (opens in a new tab)
8 Jan 2014

2013

Design Tip #158 Making Sense of the Semantic LayerRead at kimballgroup.com (opens in a new tab)
5 Aug 2013
Design Tip #156 An Excel Macro for Drilling AcrossRead at kimballgroup.com (opens in a new tab)
2 Jun 2013
Design Tip #155 Going Agile? Start with the Bus MatrixRead at kimballgroup.com (opens in a new tab)
1 May 2013
Design Tip #152 Slowly Changing Dimension Types 0, 4, 5, 6 and 7Read at kimballgroup.com (opens in a new tab)
6 Feb 2013

2012

Design Tip #147 Durable “Super-Natural” KeysRead at kimballgroup.com (opens in a new tab)
10 Jul 2012
Design Tip #145 Timespan Accumulating Snapshot Fact TablesRead at kimballgroup.com (opens in a new tab)
1 May 2012
Design Tip #142 Building BridgesRead at kimballgroup.com (opens in a new tab)
1 Feb 2012

2011

Design Tip #140 Is it a Dimension, a Fact, or Both?Read at kimballgroup.com (opens in a new tab)
1 Nov 2011
Design Tip #137 Creating and Managing Shrunken DimensionsRead at kimballgroup.com (opens in a new tab)
2 Aug 2011
Design Tip #135 Conformed Dimensions as the Foundation for Agile Data WarehousingRead at kimballgroup.com (opens in a new tab)
1 Jun 2011
Design Tip #134 Data Warehouse Testing RecommendationsRead at kimballgroup.com (opens in a new tab)
4 May 2011
Design Tip #133 Factless Fact Tables for SimplificationRead at kimballgroup.com (opens in a new tab)
5 Apr 2011

2010

Design Tip #130 Accumulating Snapshots for Complex WorkflowsRead at kimballgroup.com (opens in a new tab)
1 Dec 2010
Design Tip #128 Selecting Default Values for NullsRead at kimballgroup.com (opens in a new tab)
6 Oct 2010
Industry Standard Data Models Fall ShortRead at kimballgroup.com (opens in a new tab)
13 Sept 2010
Design Tip #127 Creating and Managing Mini-DimensionsRead at kimballgroup.com (opens in a new tab)
1 Sept 2010
Design Tip #120 Design Review Dos and Don’tsRead at kimballgroup.com (opens in a new tab)
2 Feb 2010

2009

Six Key Decisions for ETL ArchitecturesRead at kimballgroup.com (opens in a new tab)
9 Oct 2009
Design Tip #115 Kimball Lifecycle in a NutshellRead at kimballgroup.com (opens in a new tab)
4 Aug 2009
Design Tip #113 Creating, Using, and Maintaining Junk DimensionsRead at kimballgroup.com (opens in a new tab)
3 Jun 2009
The 10 Essential Rules of Dimensional ModelingRead at kimballgroup.com (opens in a new tab)
29 May 2009
Design Tip #110 More Business Requirements Gathering Dos and Don’tsRead at kimballgroup.com (opens in a new tab)
4 Mar 2009

2008

Design Tip #107 Using the SQL MERGE Statement for Slowly Changing Dimension ProcessingRead at kimballgroup.com (opens in a new tab)
6 Nov 2008
Fact TablesRead at kimballgroup.com (opens in a new tab)
6 Nov 2008
Slowly Changing Dimensions, Part 2Read at kimballgroup.com (opens in a new tab)
23 Sept 2008
Design Tip #105 Snowflakes, Outriggers, and BridgesRead at kimballgroup.com (opens in a new tab)
3 Sept 2008
Slowly Changing DimensionsRead at kimballgroup.com (opens in a new tab)
21 Aug 2008

2007

Design Tip #97 Modeling Data as Both a Fact and Dimension AttributeRead at kimballgroup.com (opens in a new tab)
11 Dec 2007
Subsystems of ETL RevisitedRead at kimballgroup.com (opens in a new tab)
21 Oct 2007
White Paper: An Architecture for Data QualityRead at kimballgroup.com (opens in a new tab)
20 Oct 2007
Design Tip #95 Patterns to Avoid when Modeling Header/Line Item TransactionsRead at kimballgroup.com (opens in a new tab)
3 Oct 2007
Keep to the Grain in Dimensional ModelingRead at kimballgroup.com (opens in a new tab)
30 Jul 2007

2006

Design Tip #81 Fact Table Surrogate KeyRead at kimballgroup.com (opens in a new tab)
6 Jul 2006
Design Tip #80 Adding a Row Change Reason AttributeRead at kimballgroup.com (opens in a new tab)
1 Jun 2006

2005

The Matrix: RevisitedRead at kimballgroup.com (opens in a new tab)
1 Dec 2005
Slowly Changing Dimensions Are Not Always as Easy as 1, 2, 3Read at kimballgroup.com (opens in a new tab)
10 Mar 2005

2004

Fables and FactsRead at kimballgroup.com (opens in a new tab)
10 Oct 2004
Differences of OpinionRead at kimballgroup.com (opens in a new tab)
4 Mar 2004
Design Tip #51: Latest Thinking On Time Dimension TablesRead at kimballgroup.com (opens in a new tab)
2 Feb 2004
Data Warehouse Dining ExperienceRead at kimballgroup.com (opens in a new tab)
2 Jan 2004

2003

Fistful of FlawsRead at kimballgroup.com (opens in a new tab)
10 Oct 2003
Design Tip #46: Another Look At Degenerate DimensionsRead at kimballgroup.com (opens in a new tab)
4 Jun 2003
The Soul of the Data Warehouse, Part 2: Drilling AcrossRead at kimballgroup.com (opens in a new tab)
5 Apr 2003
The Soul of the Data Warehouse, Part 1: Drilling DownRead at kimballgroup.com (opens in a new tab)
20 Mar 2003
Declaring the GrainRead at kimballgroup.com (opens in a new tab)
1 Mar 2003
Design Tip #43: Dealing With Nulls In The Dimensional ModelRead at kimballgroup.com (opens in a new tab)
7 Feb 2003
Fact Tables and Dimension TablesRead at kimballgroup.com (opens in a new tab)
1 Jan 2003

2002

Design Tip #41: Drill Down into a More Detailed Bus MatrixRead at kimballgroup.com (opens in a new tab)
7 Nov 2002
Two Powerful IdeasRead at kimballgroup.com (opens in a new tab)
17 Sept 2002

1999

The MatrixRead at kimballgroup.com (opens in a new tab)
8 Dec 1999

1998

Think Globally, Act LocallyRead at kimballgroup.com (opens in a new tab)
2 Dec 1998
Surrogate KeysRead at kimballgroup.com (opens in a new tab)
2 May 1998

1997

A Dimensional Modeling ManifestoRead at kimballgroup.com (opens in a new tab)
2 Aug 1997
It's Time for TimeRead at kimballgroup.com (opens in a new tab)
10 Jul 1997

1995

Data Warehouse InsuranceRead at kimballgroup.com (opens in a new tab)
1 Dec 1995

Undated

Dimensional Modeling TechniquesRead at kimballgroup.com (opens in a new tab)
—
The Data Warehouse Toolkit, 3rd EditionRead at kimballgroup.com (opens in a new tab)
—
Grain | Kimball Dimensional Modeling TechniquesRead at kimballgroup.com (opens in a new tab)
—
Role-Playing Dimensions | Kimball Dimensional Modeling TechniquesRead at kimballgroup.com (opens in a new tab)
—

74 posts from kimballgroup.com are held, newest first (corpus.blog, measured 17 October 2026).