KG header
consultingkimball universityeventsbooks
articles
design tipsabout uscontact us

Articles and Papers
Members of the Kimball Group members have written over 250 magazine columns for Intelligent Enterprise, its predecessor DBMS, and DM Review (now called Information Management). In addition, our vendor sponsored white papers are listed below. These articles are in their original form and have not been updated to represent current best practices and vocabulary.

Hover cursor on article title below for additional information

Articles and Papers 2010
Jun
IE
Mar
IE

Articles and Papers 2009
Oct IE Six Key Decisions for ETL Architectures
Aug IE Five Alternatives for Better Employee Dimension Modeling
May IE The 10 Essential Rules of Dimensional Modeling
Apr
IE
Eight Guidelines for Low-Risk Enterprise DW
Mar
IE
DW Fitness Program for Lean Times
Feb
DMR
Exploit Your Fact Tables
Jan
IE
Using Regular Expressions for Data Cleansing and Standardization

Articles and Papers 2008
Dec DMR Fact Tables
Nov DMR Judge Your BI Tool through Your Dimensions
Oct DMR Slowly Changing Dimensions, Part 2
Oct IE Maintaining Dimension Hierarchies
Sep DMR Slowly Changing Dimensions
Sep IE Practical Steps for Designing a Dimensional Model
Aug DMR Drill Down to Ask Why, Part 2
Aug IE Eight Recommendations for International Data Quality
Jul DMR Drill Down to Ask Why, Part 1
Jun IE Microsoft SQL Server Comes of Age for Data Warehousing
May DMR Essential Steps for the Integrated Enterprise Data Warehouse, Part 2
May IE Better Business Skills for BI and Data Warehouse Professionals
Apr DMR Essential Steps for the Integrated Enterprise Data Warehouse, Part 1
Apr IE Should You Use An ETL Tool?
Mar DMR Dividing the World
Feb WP Essential Steps for the Integrated EDW
Feb DMR Dimensional Perspectives (Myth Busters)
Feb IE Three Ways to Capture Customer Satisfaction
Jan DMR Data Wrangling
Jan WP Facts and Fables about Dimensional Modeling

Articles and Papers 2007
Dec DMR Set Your Boundaries
Dec IE Handling Arbitrary Restatements of History
Nov DMR Resist the Urge to Start Coding
Oct IE Subystems of ETL Revisited
Oct DMR An Architecture for Data Quality
Oct WP An Architecture for Data Quality
Aug IE Educate Management to Sustain Data Warehouse/BI Success
Jul IE Keep to the Grain in Dimensional Modeling
Jun IE Overcoming Obstacles When Gathering Business Requirements
Apr IE Dimensional Relational vs. OLAP: The Final Deployment Conundrum
Mar IE Think Critically When Applying Best Practices
Feb IE Pick the Right Approach to MDM

Articles and Papers 2006
Dec IE Building a Foundation for Smart Applications
Oct IE Four Fixes Refurbish Legacy Data Warehouses
Aug IE Integration for Real People
Jun IE Data Stewardship 101: First Step to Quality and Consistency
Apr IE Building and Delivering BI Reports
Feb IE Standard Reports: Basics for Business Users

Articles and Papers 2005
Dec IE The Matrix: Revisited
Oct IE Get Started With Data Mining Now
Sep IE Beware the Objection Removers
Jul IE Don't Forget the Owners Manual
May IE Alan Alda's Interviewing Tips for Uncovering Business Requirements
Mar IE Slowly Changing Dimensions Are Not Always as Easy as 1, 2, 3

Articles and Papers 2004
Nov IE Surrounding the ETL Requirements
Oct IE Fables and Facts
Aug IE Boosting Business Acceptance
Jun IE Data Warehouse Check-Ups
May IE Coping With Growing Pains
Mar IE Differences of Opinion
Jan IE Data Warehouse Dining Experience

Articles and Papers 2003
Dec IE Measure Twice, Cut Once
Nov IE Beyond Paving the Cow Paths
Oct IE No Detail Too Small
Oct IE Fistful of Flaws
Sep IE The Bottom-Up Misnomer
Sep IE Habits of Effective Sponsors
Jul IE RFID Tags and Smart Dust
May IE TCO Starts With the End User
Apr IE The Soul of the Data Warehouse, Part Three: Handling Time
Apr IE The Soul of the Data Warehouse, Part Two: Drilling Across
Mar IE The Soul of the Data Warehouse, Part One: Drilling Down
Mar IE Declaring the Grain
Feb IE To Be or Not To Be Centralized
Jan IE Fact Tables and Dimension Tables

Articles and Papers 2002
Dec IE The Promise of Decision Support
Nov IE Designing the Financial Data Warehouse
Oct IE Divide and Conquer
Oct IE Relating to OLAP
Sep IE Two Powerful Ideas
Sep IE Design Constraints and Unavoidable Realities
Jul IE An Engineer's View
May IE Wrangling Behavior Tags
Apr IE Behavior: The Next Marquee Application
Feb IE Doing the Work at Extract Time
Feb IE Realtime Partitions
Jan IE The Anti-Architect

Articles and Papers 2001
Nov IE Catastrophic Failure
Oct IE What Not to Do
Sep IE Managing Your Parents
Aug IE Brace for Incoming
Jul IE Managing Helper Tables
Jun IE A Trio of Interesting Snowflakes
Mar IE Adjust Your Thinking for SANs
Feb IE Smarter Data Warehouses
Jan IE Address Space
Jan IE Spatial Enabling Your Data Warehouse

Articles and Papers 2000
Dec IE Is Your Data Correct?
Nov IE Fact Tables for Text Document Searching
Oct IE The Keyword Dimension
Sep IE Backward in Time
Aug IE There Are No Guarantees
Jul IE Watching the Watchers
Jun IE Welcoming the Packaged App
Jun IE ERP Vendors: Bring Down Those Walls
May IE Is Your Dimensional Data Warehouse Expressive?
Apr IE Rating Your Dimensional Data Warehouse
Apr IE Indicators of Quality
Mar IE Mystery Dimensions
Mar IE Digital Preservation
Feb IE Many Alternate Realities
Jan IE The Special Dimensions of the ClickStream

Articles and Papers 1999
Dec IE The Perfect Handoff
Dec IE The Matrix
Nov IE Working in Web Time
Oct IE Not So Fast
Sep IE Designing the User Interface
Aug IE The Second Revolution of User Interfaces
Aug IE When a Slowly Changing Dimension Speeds Up
Jun IE Stirring Things Up
Jun IE The Budgeting Chain
Apr IE The Market Basket Data Mart
Mar IE Fundamental Grains
Mar IE Warehousing Without Borders
Feb IE What Didn't Happen
Jan IE Clicking With Your Customer

Articles and Papers 1998
Dec IE Think Globally, Act Locally
Nov IE Coping With The Brave New Requirements
Oct IE Brave New Requirements for Data Warehousing
Sep DBMS Help for Hierarchies
Aug DBMS Help for Dimensional Modeling
Jul DBMS Professional Boundaries
Jun DBMS Pipelining Your Surrogates
May DBMS Surrogate Keys
Apr DBMS Is Data Staging Relational?
Mar DBMS Meta Meta Data Data
Feb DBMS Human Resources Data Marts
Jan DBMS The Operational Data Warehouse
Jan DBMS Bringing Up Supermarts

Articles and Papers 1997
Dec DBMS Relocating the ODS
Nov DBMS Preparing for Data Mining
Oct DBMS Digging Into Data Mining
Sep DBMS Turbocharge Your Query Tools
Aug DBMS Data Warehouse Role Models
Aug DBMS A Dimensional Modeling Manifesto
Jul DBMS It's Time for Time
Jun DBMS What Does the Central Team Do?
May DBMS Traveling Through Databases
Feb DBMS Features for Query Tools
Jan DBMS Letting the Users Sleep, Part 2

Articles and Papers 1996
Dec DBMS Letting the Users Sleep, Part 1
Nov DBMS Causal (Not Casual) Dimensions
Sep DBMS Factless Fact Tables
Sep DBMS Dealing with Dirty Data
Aug DBMS Dangerous Preconceptions
Aug DBMS Aggregate Navigation With (Almost) No Metadata
May DBMS Monster Dimensions
Mar DBMS Drilling Down, Up, and Across
Feb DBMS SQL Roadblocks and Pitfalls
Jan DBMS The Problem with Comparisons

Articles and Papers 1995
Dec DBMS Data Warehouse Insurance
Nov DBMS The Aggregate Navigator
Oct DBMS Is ER Modeling Hazardous to DSS?
Sep DBMS The Database Market Splits

Home  |  Kimball University  |  Consulting  |  Events  |  Books  |  Articles  |  Design Tips  |  About Us  |  Contact Us  |  Site Map