Star schema

星型結構

Dimension tables 維度表:describe business entities—the things you model.

Fact tables 事實表: contains dimension key columns that relate to dimension tables, and numeric measure columns

The dimension key columns determine the dimensionality of a fact table, while the dimension key values determine the granularity of a fact table

https://learn.microsoft.com/en-us/power-bi/guidance/star-schema