- Load detailed atomic data into dimensional structures
- Structure dimensional models around business processes
- Ensure that every fact table has an associated date dimension table
- Ensure that all facts in a single fact table are at the same grain or level of detail
- Resolve many-to-many relationships in fact tables
- Resolve many-to-one relationships in dimension tables
- Store report labels and filter domain values in dimension tables
- Make certain that dimension tables use a surrogate key
- Create conformed dimensions to integrate data across the enterprise
- Continuously balance requirements and realities to deliver a DW/BI solution that's accepted by business users and that supports their decision-making
Reference: Kimball University
Article 
No comments:
Post a Comment