Coding Ninjas Data Analyst Interview Questions and Answers

Q1. It is related to SQL, Python, and Excel
Add your answer
Q2. Not Remember the interview questions exactly
Add your answer
Q3. What is grouped by in SQL
Ans. 
In SQL, data is grouped by a specified column or expression using the GROUP BY clause.
• Data is grouped based on the values in the specified column or expression

• Aggregate functions like SUM, COUNT, AVG can be used with GROUP BY to perform calculations on each group

• GROUP BY is often used in conjunction with the SELECT statement

• Example: SELECT department, AVG(salary) FROM employees GROUP BY department
Answered by AI
Add your answer
Q4. List and dictionary differences
Ans. 
Lists are ordered collections of items, while dictionaries are unordered collections of key-value pairs.
• Lists are accessed by index, dictionaries are accessed by key

• Lists maintain the order of elements, dictionaries do not guarantee order

• Lists use square brackets [], dictionaries use curly braces {}

• Example: list - [1, 2, 3], dictionary - {'a': 1, 'b': 2}
Answered by AI
Add your answer
Q5. Lambda functions in python
Ans. 
Lambda functions are anonymous functions in Python that can have any number of arguments but only one expression.
• Lambda functions are defined using the lambda keyword.

• They are commonly used for small, one-time tasks.

• Lambda functions can take any number of arguments, but can only have one expression.

• Example: add = lambda x, y: x + y
Answered by AI
Add your answer

Q1. The first round of interviews was smooth; I had to visit their office in Andheri and then have a face-to-face conversation with Neeraj sir (Hr). The questions were to introduce yourself, what is big data, ...read more
Add your answer
Q2. After answering, he seemed somehow satisfied, but later he was encouraging me to enroll in their course and enhance my skills. And I'm still getting their emails and promotional messages for the same.
Add your answer

Q1. The second round was on the call, which was rescheduled thrice. Then finally I got a call where Ashish sir (Hr) asked me to introduce myself, what are T&Z testing, overfitting, K neighbour algorithm, can w...read more
Add your answer
Q2. The job position was for a fresher Data analyst, but they were asking questions related to Data scientist position. Basically, they were looking for a candidate who has hands-on experience with real-time d...read more
Add your answer

Q1. Spark related questions
Add your answer
Q2. Previous projects done
Ans. 
Developed a real-time data processing system for a retail company to optimize inventory management.
• Designed and implemented data pipelines to ingest, process, and analyze large volumes of data

• Utilized technologies like Apache Kafka, Spark, and Hadoop for real-time processing

• Built dashboards and reports for stakeholders to monitor inventory levels and make data-driven decisions
Answered by AI
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

Around sql/python and other da tools

Stats and probability with focus on puzzles

Q1. The first round of interviews was smooth; I had to visit their office in Andheri and then have a face-to-face conversation with Neeraj sir (Hr). The questions were to introduce yourself, what is big data, ...read more
Add your answer
Q2. After answering, he seemed somehow satisfied, but later he was encouraging me to enroll in their course and enhance my skills. And I'm still getting their emails and promotional messages for the same.
Add your answer

Q1. The second round was on the call, which was rescheduled thrice. Then finally I got a call where Ashish sir (Hr) asked me to introduce myself, what are T&Z testing, overfitting, K neighbour algorithm, can w...read more
Add your answer
Q2. The job position was for a fresher Data analyst, but they were asking questions related to Data scientist position. Basically, they were looking for a candidate who has hands-on experience with real-time d...read more
Add your answer

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

Q1. Normal questions
Add your answer