Implementing Star Schemas in Power BI Desktop (sqlshack.com)
Star schema refers to the logical description of datasets where data is divided into facts tables and dimension tables.
The facts table contains the actual information and the dimensions table contains the related information. Star schema is very similar to a one-to-many relationship, where a table can have multiple/duplicate foreign keys from a foreign key column.
Niciun comentariu:
Trimiteți un comentariu