Data Analyst Intern Interview Questions

2,103 data analyst intern interview questions shared by candidates

Q: Write SQL query based on ERD diagram and business problem. (1 medium and 1 hard) Q: Technical + Personal Interview round. Questions related to past projects, SQL queries, Questions based on estimations (product management questions)
avatar

Data Analyst Intern

Interviewed at Scaler Academy

3.7
Apr 21, 2023

Q: Write SQL query based on ERD diagram and business problem. (1 medium and 1 hard) Q: Technical + Personal Interview round. Questions related to past projects, SQL queries, Questions based on estimations (product management questions)

SQL 1st Question: Find Total no of male and female for each department. # Table : Employee | Empid | Name | Gender | Department | 1 Alexa Female IT 2 Naman Male Finance 3 Rita Female Finance 4 Priya Female HR 5 Shivangi Female HR 6 Rahul Male IT 7 Tanya Female Finance 8 Arun Male HR 9 Lakshya Male IT 10 Deepika Female HR Expected Output: | Department | TotalMale | TotalFemale | Finance 1 2 HR 1 3 IT 2 1
avatar

Data Analyst Intern

Interviewed at NeenOpal

4.2
Aug 9, 2024

SQL 1st Question: Find Total no of male and female for each department. # Table : Employee | Empid | Name | Gender | Department | 1 Alexa Female IT 2 Naman Male Finance 3 Rita Female Finance 4 Priya Female HR 5 Shivangi Female HR 6 Rahul Male IT 7 Tanya Female Finance 8 Arun Male HR 9 Lakshya Male IT 10 Deepika Female HR Expected Output: | Department | TotalMale | TotalFemale | Finance 1 2 HR 1 3 IT 2 1

Viewing 1001 - 1010 interview questions

Glassdoor has 2,103 interview questions and reports from Data analyst intern interviews. Prepare for your interview. Get hired. Love your job.