Mike Roberts

Results 9 comments of Mike Roberts

This will probably be handled with v10 but it's always been nice to have a way to standardize fonts,etc across the sheets in a workbooks. What's more, it's nice to...

This is great for when one has sql that changes frequently. So, for example, if you have a custom sql source on Github then the sql from the tableau data...

Here's an example: https://github.com/DataRoberts/Tableau/blob/master/AnalyticsEngineering/UpdateCustomSQL.ps1

Pretty much the same need as custom sql: updating similar workbooks across sites and also to save some time (and potential error) as one has to download, open, update and...

Here's an example: https://github.com/DataRoberts/Tableau/blob/master/TableauDesktop/TsChangeFormula.ps1

Nothing's worse than republishing a workbook that was originally secured with a data source filter and NOT having it there. This just automates it. Here's an example: https://github.com/DataRoberts/Tableau/blob/master/TableauDesktop/TsDataSourceFilters.ps1

It's possible to replace the image within the workbook too. Same as custom sql/calc fields where you'd just need to update the image. And, if you have a lot, this...

Great for securing workbooks and keeping history. Here's the metadata example: https://github.com/DataRoberts/Tableau/blob/master/TableauDesktop/TsTwbInternals.ps1

This is a 'nice to have' but not totally needed by everyone. It's great for automating template workbooks for new hires, etc. For example, if you have a date column,...