- Beyond simple queries, it becomes more easier to setup a view or two behind Tableau than to do it purely in Tableau. E.g. multiple level of latest times, more complex aggregations etc are more easily done in SQL than via Tableau.
- For some things Tableau doesn't do what we typically expect. Couple of examples:
- If you run a custom query joining two tables with some of the column names being same in both, Tableau cannot deal with it. Setting alias for columns using "as" works fine in SQL so I think it is not unreasonable to expect that to work.
- I recently tried to chart lag in request/response in microseconds. The data is stored as TIMESTAMP in our Vertica database. However, I found that Tableau doesn't show time more granular than seconds. That is kind of odd in today's common low-latency high-performance technology environment
Having said that, I really like the features it offers viz. Calculated fields which don't go away just because I change the data source, drag-and-drop dashboard constructions, very nice visualizations etc.