Forum Discussion
Managing relationships between datasets with date variable
clean up your data and create a data model
Adding injuries to that chart will create cognitive overload. Use separate visuals.
Read about how to handle SCD2 - Slowly Changing Dimension Type 2
Hello,
I have managed to create the data model and happy with results. I have a follow up question for the same dataset and would appreciate your guidance.
If I want to assign specific data (e.g. Start Number, Origin, etc) to each pen as per Dimension Table included in the responses below, how do I go about doing that? I have created a table for each type of data (e.g. Origin) but I am not sure how I should create the relationship with the rest of the data (Injury data in particular). I do not think simply including the Start Number/Origin data in the Injury dataset of the relevant pen solves this, assuming it will generate plenty of null data.
Read about how to handle SCD2 - Slowly Changing Dimension Type 2