Senior Tableau Developer Interview Questions and Answers

Initial SQL is a feature in Tableau that allows users to write custom SQL queries to connect to data sources.

• Initial SQL is used to execute SQL statements before the main query is executed.

• Custom SQL can be written in Tableau to connect to data sources that do not have a built-in connector.

• CAT in SQL stands for Concatenate and is used to combine two or more strings into a single string.

• Project related questions may vary depending on the specific project and requirements.

Window functions in SQL can be used for partial calculations in Tableau.

• Window functions allow for calculations to be performed on a subset of data within a larger dataset.

• These functions can be used in Tableau to create partial calculations, such as running totals or moving averages.

• Examples of window functions include ROW_NUMBER(), RANK(), and LAG().

• Partial calculations in Tableau can be created using table calculations, which can be based on window functions.

• These calculat...read more

DDL stands for Data Definition Language and is used to define and manage the structure of a database. DML stands for Data Manipulation Language and is used to manipulate the data within a database.

• DDL commands are used to create, alter, and drop database objects such as tables, views, indexes, etc.

• Examples of DDL commands include CREATE TABLE, ALTER TABLE, DROP TABLE, CREATE INDEX, etc.

• DML commands are used to insert, update, delete, and retrieve data from a database.

• Examples...read more

Reduce Tableau access costs by optimizing licenses, utilizing server resources efficiently, and training users on best practices.

• Optimize Tableau licenses by identifying and removing unused licenses or downgrading to a lower tier if possible

• Utilize Tableau Server resources efficiently by scheduling extracts during off-peak hours and optimizing server performance settings

• Train users on best practices to reduce unnecessary usage of Tableau features and improve efficiency