Correct fact and dimension starschema?

[sencius]

Currently i have it that the "MedewerkersKLM" table is the fact. But my teacher told me that "Verzuimtransacties" is the fact table. Other people are saying that MedewerkersKLM is the fact table. Does anybody know what the correct fact table is? thanks.

https://liveadminwindesheim-my.sharepoint.com/:u:/r/personal/s1187552_student_windesheim_nl/Document...

[tharunkumarRTK]

@sencius 

From your model, I think it is fair to say that you have two fact tables. 

1. MedewerkersKLM is the fact table for all the tables connected to it expect Verzuimtransacties.

2. Verzuimtransacties is fact table for MedewerkersKLM.

In start schema, Dimension table will be on One side and Fact tables will be on the Many side. I would suggest you to read this document for better understnading https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

[sencius]

would you say that "verzuimtransacties" is the fact table and that its a snowflake dimension?

[tharunkumarRTK · Accepted solution]

@sencius - No, you cannot call this as a snowflakes schema. A typical snowflake schema dimensions are in a normilised form, just for your reference: 

I think you can call your model as a Star schema with nested fact table.

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun