Business Intelligence Developer Interview Questions and Answers

The number of cars that can pass in an hour at a 4-way signal depends on various factors such as traffic flow, signal timing, and road capacity.

• The capacity of a 4-way signal intersection depends on the traffic flow from each direction

• Signal timing and coordination can affect the number of cars that can pass through the intersection

• Road capacity and lane configuration also play a role in determining the throughput of the intersection

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

Support projects can be managed by setting clear goals, establishing communication channels, providing training, monitoring progress, and addressing issues promptly.

• Set clear goals and expectations for the support project

• Establish effective communication channels for team members and stakeholders

• Provide necessary training and resources to support team members

• Monitor progress regularly and adjust strategies as needed

• Address any issues or challenges promptly to ensure project s...read more

Find the 5th highest salary using SQL.

• Use the ORDER BY clause to sort the salaries in descending order.

• Use the LIMIT clause to limit the result to the 5th highest salary.

• Use a subquery to exclude the top 4 salaries and retrieve the 5th highest salary.

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

Sets in Tableau are custom fields that define a subset of data based on certain conditions.

• Sets can be used to group related data together for analysis

• Sets can be created based on dimensions or measures

• Sets can be used in calculations, filters, and visualizations

• Examples: creating a set of top customers, creating a set of high-value products

Cardinality refers to the uniqueness of values in a column or set of columns in a database table.

• Cardinality is the number of unique values in a column or set of columns.

• High cardinality means a column has many unique values, while low cardinality means few unique values.

• For example, a column like 'employee_id' would have high cardinality, while a column like 'gender' would have low cardinality.