I have data coming from Google Analytics and 1 excel file (containing google analytics data) that supplies benchmark data. Same excel file will be used by multiple tableau files on the server. The excel file has to be revised every year and the changes should reflect on each report after yearly changes. I have to automate the process to avoid updating each tableau file every year.
Google spreadsheet can be used in place of excel file but how can I schedule it for yearly refresh? And will the auto-refresh on google spreadsheet reflect on all Tableau files connected to it and running on Tableau server?
If I consider manually updating yearly benchmark data, how can I ensure changing the file once and it should reflect on all Tableau files connected to it?