Triggers when modeling for analytics/OLAP — star/snowflake schemas, fact and dimension tables, slowly-changing dimensions, grain definition, and columnar warehouse layout for BI queries.
