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 v-csrikanth, I have uploaded sample data in the requested format and will wait for any additional feedback that lbendlin can kindly provide to hopefully resolve the issue. Thank you.
clean up your data and create a data model
Adding injuries to that chart will create cognitive overload. Use separate visuals.
Hello, thank you for the response and solution. That is greatly appreciated. I will work on the solutions that you provided in these days.
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