Business Intelligence Developer Interview Questions and Answers for Freshers

Tableau filters, dimensions vs measures, mean and variance

• Tableau filters are used to limit the data displayed in a visualization

• Dimensions are categorical data, while measures are numerical data

• Mean is the average of a set of numbers, while variance measures how spread out the data is

• Examples of dimensions include product categories or customer segments, while measures include sales revenue or profit margin

SQL query to find 5th highest salary

• Use the 'SELECT' statement to retrieve the salary column

• Use the 'DISTINCT' keyword to eliminate duplicate salaries

• Order the results in descending order using 'ORDER BY'

• Use 'LIMIT' to retrieve the 5th highest salary