Tables with no relationship

Hi Xaraja 

You raise a great question.  Relationships are important where there is a need for them in the data model.  Reports / Dashboards frequently may present information and insights through many different ways and for many different reasons.  Although it may be the norm to create reports / dashboards that focus on one specific subject, performance area, or matter, there are many instances where one report / dashboard may incorporate information and insights from many sources - taking a "mixed salad" approach.

In my experience - as limited as that may be - when I have had to take over someone else's work, especially where there is no journey documented for identifying how something came to be (similar in your current instance, I assume), you may be able to reverse engineer the reports / dashboards to get an understanding of their purpose, the information / insight they are trying communicate, whether they are in fact communicating that information / insight, and so on... until you determine whether or not relationships, etc., are required in the respective data models.

Generically speaking, however, there is no correct answer to whether relationships need to exist without knowing the purpose and intention of the report / dashboard, and the information / insights they aim to achieve.

All the best with your journey and do not hesitate to touch base if you have any questions! 🙂