JustDial Data Analyst Interview Questions and Answers

Q1. I have finished Btech in Cse AI&ML taken datascience course looking for job
Add your answer

NLP is my favorite subject. Is relatated medical and sign language. I have done reseach with mechien learning and AI TOOLS used for problem solving approach.

A group discussion was conducted on data-based management regarding Mr. Adani's food industry products in the state of Gujarat and their exports to other countries, utilizing data analytics.

Basic Apititude Questions

Q1. Difference between WHERE and HAVING??
Ans. 
WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.
• WHERE is used with SELECT statement to filter rows based on a condition

• HAVING is used with GROUP BY statement to filter groups based on a condition

• WHERE is applied before data is grouped, HAVING is applied after data is grouped

• Example: SELECT * FROM table WHERE column = 'value'

• Example: SELECT column, COUNT(*) FROM table GROUP B
Answered by AI
Add your answer
Q2. Where- Row Level Filters Having-Aggregate Filters
Ans. 
Row level filters are applied before aggregations, while aggregate filters are applied after aggregations.
• Row level filters are used to filter individual rows of data before any aggregations are performed.

• Aggregate filters are used to filter the aggregated results after the data has been grouped and summarized.

• Row level filters are typically applied using WHERE clause in SQL, while aggregate filters are applied using H...read more
Answered by AI
Add your answer

Q1. Why do you wanna join Uber?
Add your answer
Q2. Best Company Ever
Add your answer

Q1. About previous experience situation based questions excel problem solving
Add your answer
Q2. Tell me about yourself difference between data quality and data validity
Add your answer

SQL, Python, like case about window function

Q1. All about past project
Add your answer

Q1. Basic to Advanced level of SQL
Add your answer
Q2. Discussed 1 -2 Business Cases studies
Add your answer

Basic questions based on Sql

Questions based on Amazon role requirements were asked, Behavioural questions were also asked. While format was choice based questions. Personality Assessment was carried out by giving many questions of similar type but having different options. Overall good.