Star-shaped model with 6 facts table ?

[Stemar_Aubert]

Hello,

I have the following data sources:

Market share actual

Market share targets

Cost actual

Cost target

Sales actual

Sales target

Those will be used to measure various metrics, and will be linked with dimensional tables such as personal (eg. Sales rep), geographical (eg. District) and product (eg. Serial number).

Should I put everything together in one big table, or is there a way to handle this following a star-shaped schema ?

Thanks,

[v-yuta-msft · Accepted solution]

@Stemar_Aubert ,

The data model/schema depends on your specific senario. I would suggest you refer to the tutorial below:

https://docs.microsoft.com/en-us/learn/modules/model-data-power-bi/

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mariusz]

Hi @Stemar_Aubert 

You need to make a decision depending on the structure and most importantly on the granularity of this fact tables if the granularity of one or more tables are different, and you want to preserve it for reporting of some numbers on that specific level, then you will need to keep it separate and use dimensions as filters, if however, they all are the same granularity then you can merge, but it will all depend on your model and what you want to achieve.

This video course will give you a good idea of how to create your data model.

https://www.sqlbi.com/training/data-modeling/

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.