One big table

Flattening a star into a single wide table so that consumers never join anything. On columnar storage the unused columns cost nothing to read, so the classic objection largely evaporates, and BI tools and self-service users are dramatically less likely to get a wrong answer. What you give up is history and reuse: a change to a dimension attribute means rebuilding the whole table, and every consumer is coupled to one team's idea of which columns matter.