- Joined
- May 21, 2019
- Messages
- 4,036
- Likes
- 6,827
The Tableau side we have covered.You don't need to embed the Google Sheet. The Google doc can be the source of truth that feeds both the Tableau dashboard and the charts Amir creates for his reviews. Amir can directly link to the Google sheet using Excel's Get & Transform. Afterwards, all he has to do is press refresh within Excel to pull the most recent data from the Google Sheet. I'm happy to walk both of you through this.
You should be able to connect Tableau directly to the Google sheet and specify how often the data refreshes - I figure you have already done this.
If you don't reconcile the data in Google Sheet to Amir's sheet on a regular basis, it is highly likely you have variances between the 2 databases.
We'll have to live with the two sheets until we come up with the ASR Grand Unifying something or other. Given how fast everything is moving (a year ago this was all text-based) this may not be far off.
I spend a lot of time making sure the sheet is accurate on the data side so if you do find numbers or inputs/outputs or other details that are off in the interactive tables/charts I would appreciate a post in the relevant feedback threads or a PM.