DecisionWorks ConsultingAugust 2003 - DecisionWorks Consulting
  • Home
  • Training
    • Onsite Course Descriptions
    • Public Course Description
    • Public Class Schedule
    • Public Class Pricing and FAQ
  • Consulting
    • DW/BI Strategy Assessments
    • Business Requirements
    • Dimensional Modeling
    • Design Review
    • DW/BI Project Review
  • Resources
    • Books
    • Articles & Design Tips
    • Kimball Techniques
  • About
  • Contact
  • Learn Dimensional Modeling from Kimball Toolkit Experts!

DecisionWorks Consulting

Learn Dimensional Modeling from expert Margy Ross, Ralph Kimball's Toolkit co-author
  • Home
  • Training
    • Onsite Course Descriptions
    • Public Course Description
    • Public Class Schedule
    • Public Class Pricing and FAQ
  • Consulting
    • DW/BI Strategy Assessments
    • Business Requirements
    • Dimensional Modeling
    • Design Review
    • DW/BI Project Review
  • Resources
    • Books
    • Articles & Design Tips
    • Kimball Techniques
  • About
  • Contact

Monthly Archives: August 2003

  • Home /
  • Design Tip #48: De-Clutter With Junk (Dimensions)/
  • 2003 /
  • August

Design Tip #48: De-Clutter With Junk (Dimensions)

  • Margy Ross
  • August 7, 2003

When developing a dimensional model, we often encounter miscellaneous indicators and flags that don’t logically belong to the core dimension tables. These unattached attributes are usually too valuable to ignore or exclude. Designers sometimes want to treat them as facts (supposed textual facts) or clutter the design with numerous small dimensional tables. A third, less obvious but preferable, solution […]

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
  • Business Intelligence Applications
  • Maintenance and Growth

Archives

  • 2017
    • September
  • 2015
    • October
    • September
    • May
    • March
  • 2014
    • November
    • June
    • May
  • 2013
    • November
    • October
    • June
    • May
    • April
    • February
  • 2012
    • August
    • April
    • March
  • 2011
    • October
    • September
    • June
    • April
  • 2010
    • December
    • October
    • September
    • June
    • May
    • March
    • February
  • 2009
    • November
    • October
    • August
    • May
    • March
  • 2008
    • December
    • September
    • July
    • May
    • January
  • 2007
    • October
    • June
    • March
    • February
  • 2006
    • October
    • September
    • July
    • June
    • April
    • March
  • 2005
    • December
    • November
    • October
    • July
    • May
    • April
    • March
    • February
  • 2004
    • October
    • August
    • June
    • May
    • March
    • January
  • 2003
    • October
    • September
    • August
    • June
    • March
    • February
  • 2002
    • November
    • May
  • 2000
    • October
    • April
    • January

Latest Articles

  • Is Dimensional Modeling Still Relevant?
  • Design Tip #178 Tried and True Concepts for DW-BI Success
  • Design Tip #177 Final Word of the Day: Collaboration
  • Design Tip #174 Does Your Organization Need an Analytic Sandbox?

Education Services

  • Onsite Course Descriptions
  • Public Course Description
  • Public Class Schedule
  • Public Class Pricing and FAQ

Consulting Services

  • DW/BI Strategy
  • DW/BI Requirements
  • Dimensional Modeling
  • Dimensional Model Design Review
  • DW/BI Project Review

Resources

  • Books
  • Articles & Design Tips
  • Kimball Techniques
DecisionWorks Consulting, Inc. All Rights Reserved. Spark Logix Studios
  • About
  • Contact
  • Sitemap
  • Privacy Policy