Ekeeda Data Analyst Interview Questions and Answers

A general apti round

Data analysis assignment

Q1. Sql questions askes
Add your answer

Q1. Product sense round
Add your answer

Q1. Culture fit round
Add your answer

It is good nice and not so tough

Q1. Tell me about yourself inro ?
Ans. 
I am a data-driven individual with a strong analytical mindset and a passion for problem-solving.
• Graduate student majoring in Data Science at XYZ University

• Proficient in programming languages such as Python, R, and SQL

• Experience with data visualization tools like Tableau and Power BI

• Completed projects involving data cleaning, analysis, and interpretation

• Strong communication skills and ability to work in a team environm
Answered by AI
Add your answer

Will be given test based on Job discription

Q1. Technical questions will be asked
Add your answer

Q1. Hr policies and compensation Discussion
Add your answer

Q1. SQL queries , python pandas and numpy , power bi related questions
Add your answer

Q1. Previous experience, skills and expertise
Add your answer

A general apti round

Data analysis assignment

Q1. Sql questions askes
Add your answer

Q1. Product sense round
Add your answer

Q1. Culture fit round
Add your answer

Q1. Sql - List top 3 youngest ages of employees dept wise
Ans. 
List top 3 youngest ages of employees dept wise using SQL.
• Use GROUP BY to group employees by department.

• Use ORDER BY to sort ages in ascending order.

• Use LIMIT to get top 3 youngest ages.

• Use MIN to get the youngest age in each department.
Answered by AI
View 3 more answers
Q2. Sql - List employees whose age is greater than average age of all employees
Ans. 
List employees whose age is greater than average age of all employees using SQL.
• Calculate the average age of all employees using AVG() function.

• Use WHERE clause to filter out employees whose age is greater than the average age.

• Join the employee table with the age table to get the age of each employee.

• Example: SELECT * FROM employees WHERE age > (SELECT AVG(age) FROM employees);
Answered by AI
View 1 more answer
Q3. Python - sum of digits till the result becomes single digit Ex: 479 - 20 - 2
Ans. 
Python program to find the sum of digits till the result becomes a single digit.
• Convert the number to a string and iterate through each digit.

• Add the digits and store the result.

• Repeat the process until the result becomes a single digit.

• Return the single digit result.
Answered by AI
View 7 more answers

Q1. Basic HR questions like why futurense, qualities that get you into futurense
Add your answer

Sql, numpy, pandas, dictionary, pandas group by, merging

Q1. Normal questions
Add your answer