Forum Discussion

WBscooby's avatar
WBscooby
Helper 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
DOLEARY85's avatar
DOLEARY85
Resident Rockstar
3 years ago

Hi,

 

i used to work with youth offending data so this looks fairly similar to the data model in the recording system. I think you might need a link from the intervention table to the person table too and make that active when you are querying that table. 

 

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

WBscooby's avatar
WBscooby
Helper 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
    Resident 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 👍