Was a big fan of tableau and we use it in production. It's a wonderfully exploratory tool. But the real pain start when you have 50+ workbooks and the underlying data model MUST introduce breaking change for whatever reason.

There is to my knowledge no way to automate edition of workbooks. You are in for GUI repetitive soul sucking task. Bonus pain if "workaround" are involved. (Just have a look at the support forum... well not the good time they just revamped it... many answer involve 10+ manuals GUI steps)

I still use it, overall still pretty good at what it does best. But I'm actively seeking alternative.