Scribd
Upload
3 views2 pages

BI Engineer SQL Assessment Questions

The document outlines an assessment for BI Engineer interviews, focusing on SQL queries related to employee and department data. It includes specific questions such as fetching the lowest salary in each department, identifying departments with more than two employees, and retrieving alternate records. Additionally, it suggests a section on data visualization and dashboarding, prompting candidates to create a dashboard based on provided datasets and metrics.

Uploaded by

rakeshchappan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3 views2 pages

BI Engineer SQL Assessment Questions

The document outlines an assessment for BI Engineer interviews, focusing on SQL queries related to employee and department data. It includes specific questions such as fetching the lowest salary in each department, identifying departments with more than two employees, and retrieving alternate records. Additionally, it suggests a section on data visualization and dashboarding, prompting candidates to create a dashboard based on provided datasets and metrics.

Uploaded by

rakeshchappan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

BI Engineer Interview Assessment Questions

Section 1: SQL

Look at the employee table data given below and answer the following questions:

‘Employee’ table:

Emp_Id Emp Name Age Gender DOJ Dept City Salary


101 John 34 M 2015-05-30 Tech Chicago 120,000
201 Sara 30 F 2017-06-25 Sales Boston 110,000
301 Amy 27 F 2020-03-10 Marketing New York 125,000
401 Reid 40 M 2014-12-20 Sales San 170,000
Francisco
501 Marcus 41 M 2018-07-18 Product Atlanta 100,000
601 Mary 30 F 2019-09-09 Tech Chicago 90,000
701 James 29 M 2016-04-23 Marketing New York 160,000
801 Russell 28 M 2019-08-20 Sales Atlanta 105,000
901 Angela 29 F 2015-03-20 Product Chicago 135,000

Q1) Write a SQL query to fetch the lowest salary of employees in each department.

Q2) Write a SQL query to display the departments that have more than 2 employees

Q3) Print all alternate records from the employee table

Look at the employee table and department table give below and answer the following questions:

Employee Table

ID Name Salary Dept_ID


1 Andrew 70000 1
2 Samantha 90000 1
3 Jason 80000 2
4 Heather 60000 2
5 Max 90000 1

Department Table

ID Name
1 IT
2 Sales

Q4) Write a SQL Query to fetch the highest salary in each department and its corresponding employee
Section 2: Data Visualization and Dashboarding

Thoughts:

• Provide a dataset and a few questions/metrics and ask candidates to prepare a dashboard.
• Ask visualization related case-study questions either MCQs or Explanation questions

Prepare questions for use cases

You might also like