D Cube Analytics Business Analyst Interview Questions and Answers

SQL query to find managers of employees with single table of employee designation and empid

• Use self join to join the table with itself on manager id and employee id

• Filter the result to only include employees with managers

• Select the manager name and employee name

Issues faced while visualizing on Tableau

• Data not properly formatted

• Incorrect use of chart types

• Inadequate labeling and formatting

• Poor data quality

• Lack of understanding of Tableau features

• Slow performance with large datasets