We need to establish a way to clearly identify both the table and the associated calculation reference. Its highly possible to have a change in table structure which will break the dashboard and its associated calculations. Need a method/ability to see the calc references, so that we can easily delete/change the calcs without the fear of breaking any viz. This helps in data preparation .
Same applies in data set. If a complex data model includes 12 tables, and there is a situation to delete/replace table, currently workbook will fail. we dont have any method to identify the dependency.
Example:
I create a calculation "programs" . Later we change the logic how this is being calculated and another team member create a new calculation Programs#. Now Programs is obsolete. But to identify where and all this is being used, there is no way.