Tableau – Using SQL queries to get data

Tableau allows to connect to a wide variety of database systems and most of the operations like joins, filtering and ordering can be done without writing a single line of SQL. But what can be done  if the data required is not readily available in the database tables? There are...