In its Design Tip 179, the Kimball Group outlines why dimensional modeling is an important asset to building a strong DW/BI project. Kimball provides foundational tenets that match our own philosophies and methods about business analytics perfectly. From explaining why dimensional modeling is the best specification for the DW/BI system and using the MDM for de-duping instead of within the ETL flow, there is bedrock stuff here, such as: If you get the model right and populate it with integrity the rest is straightforward. Also provided are system architecture design tips that are good to live by too! Read the full article.
