Kimball GroupJuly 2007 - Kimball Group
  • Home
  • Resources
    • Kimball Techniques
    • Books
    • Articles & Design Tips
    • Kimball Forum
  • About
  • Contact
  • More about the Kimball Group Reader (Kimball/Ross, 2016)

Kimball Group

More about the Kimball Group Reader (Kimball/Ross, 2016)
  • Home
  • Resources
    • Kimball Techniques
    • Books
    • Articles & Design Tips
    • Kimball Forum
  • About
  • Contact

Monthly Archives: July 2007

  • Home /
  • All Tips/
  • 2007 /
  • July

Keep to the Grain in Dimensional Modeling

  • Ralph Kimball
  • July 30, 2007

When developing fact tables, aggregated data is NOT the place to start. To avoid “mixed granularity” woes including bad and overlapping data, stick to rich, expressive, atomic-level data that’s closely connected to the original source and collection process. The power of a dimensional model comes from a careful adherence to “the grain.” A clear definition […]

Categories

  • Before Diving In
  • Project/Program Planning
  • Requirements Definition
  • Data Architecture
  • Dimensional Modeling Fundamentals
  • Dimensional Modeling Tasks
  • Fact Table Core Concepts
  • Dimension Table Core Concepts
  • Advanced Dimension Patterns & Case Studies
  • ETL and Data Quality
  • Technical Architecture
  • Business Intelligence Applications

Archives

  • 2015
    • December
    • November
    • October
    • September
    • July
    • June
    • May
    • March
    • February
    • January
  • 2014
    • July
    • June
    • May
    • March
    • January
  • 2013
    • August
    • June
    • May
    • February
  • 2012
    • July
    • May
    • February
  • 2011
    • November
    • August
    • June
    • May
    • April
  • 2010
    • December
    • October
    • September
    • February
  • 2009
    • October
    • August
    • June
    • May
    • March
  • 2008
    • November
    • September
    • August
  • 2007
    • December
    • October
    • July
  • 2006
    • July
    • June
  • 2005
    • December
    • March
  • 2004
    • October
    • March
    • February
    • January
  • 2003
    • October
    • June
    • April
    • March
    • February
    • January
  • 2002
    • November
    • September
  • 1999
    • December
  • 1998
    • December
    • May
  • 1997
    • August
    • July
  • 1995
    • December
The Kimball Group. All Rights Reserved. Spark Logix Studios