【PowerBI】第三节(4): The Star Schema,Duplicate和Reference

1. The Star Schema

1.1

• Snowflake Schema
• Star Schema
• Dim Table (Multiple tables)
• Fact Table (Connect Dim Tables)
  

1.2 应用 The Star Schema

2. 复制Duplicate和引用Reference的区别

2.1 Reference

A reference depends on the initial query

2.2 Duplicate

A complete copy of the existing query.
Steps 也会被复制

3. 应用Duplicate和Reference

Reference population-combined，重命名为DIM-region并放在新建组“Data Model”中

此时应用的步骤只有"源"

若复制population-combined的话，应用的步骤也都被复制