Recently I've been experimenting in Tableau with dashboard sizes for the ipad. I prefer to set it up landscape viewing and found the optimal size is 1020 x 610 pixels, this more or less seems the perfect size to fill the full screen and remove the need for scrolling.
On many occasions I have found Tableau data extracts are slow to refresh on the Tableau Server. Especially when pulling from SQL Server – although I’m sure this happens with all data connections. I always used to put this down to the slow execution of the query. If it’s slow to run on the SQL [...]
Recently I have had to reshape text files using custom SQL in the data connection. Being reasonably competent in SQL I didn’t expect a problem. Unfortunately I was wrong. Tableau uses the MS Jet data engine which has slightly different syntax to standard SQL used in SQL server. For example when using the DATEADD function [...]