IntelligentEnterprise : Kimball University: Keep to the Grain in Dimensional Modeling

IntelligentEnterprise : Kimball University: Keep to the Grain in Dimensional Modeling:

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.