Forum Discussion

WBscooby's avatar
WBscooby
Icon for Helper III rankHelper III
3 years ago

Data Model - More than one fact table?

Hi   I would really appreciate some support with my data model. It is quite complex and I'm getting in a bit of a muddle! I've attached a snapshot but it's a bit scruffy and I've attempted to blank...
Need Help
WBscooby's avatar
WBscooby
Icon for Helper III rankHelper III
3 years ago

Hi

 

Thanks for responding! I think I can make this work. Do you think this would be better practice than creating one main FACTtable that contains both the outcomeoffence and the intervention? 

 

Thank you 

DOLEARY85's avatar
DOLEARY85
Icon for Resident Rockstar rankResident Rockstar
3 years ago

I think when using this data it probably would be better to it with multiple FACT tables. From what i remember not every intervention will have all the offences/outcomes attached so it can make a single FACT table very messy and have a lot of duplicates which you'd have to find a way to filter out when using it in PBI.

 

Hope this helps,

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍