Technician Lead Interview Questions and Answers

The year over year sales difference is the comparison of sales from one year to the next to determine growth or decline.

• Calculate the total sales for the current year and the previous year

• Subtract the total sales of the previous year from the total sales of the current year

• The result will show the year over year sales difference

Context filter in Tableau allows users to filter data across multiple worksheets or dashboards.

• Context filters are applied to a specific worksheet or dashboard and affect all other worksheets or dashboards connected to the same data source.

• Context filters are useful for creating interactive dashboards where users can easily filter data across different views.

• To create a context filter in Tableau, right-click on a filter and select 'Add to Context'.

Order of operation in Tableau determines the sequence in which calculations are performed.

• Tableau follows the standard order of operations: parentheses, exponentiation, multiplication and division (from left to right), addition and subtraction (from left to right)

• Use parentheses to specify the order of operations

• Tableau also allows the use of functions to control the order of operations