I have been tasked with creating a Dashboard that provides visualizations of the dates and times tables within the a library have been updated. There are over 450 tables in this library and the data is just the table names, what type of table it is (classified by function) and the last date and time the information within the table has been updated. The dashboard is meant to provide insight to management at NAVSUP as to whether or not tables are being updated on time or are delayed. Since the development of the Dashboard, I have stumbled upon several obstacles that make rendering the Dashboard quite time consuming as it requires a significant amount of manual manipulation every time new datasets are imported. For example, every time I update the information in the Dashboard by importing new datasets, I must manually change the column names/labels, reassign roles to each dataset for report objects, reapply any rules and filters to report objects and remap linked report objects. As you can imagine, this takes quite a bit of time and is not particularly efficient for a Dashboard that would be useful on a daily basis. Would you be able to provide any insight or feedback as to how these processes could be automated? Thank you!
... View more