Naukri Business Analyst Interview Questions and Answers

SQL queries - 3. Was asked to write on notepad using the table structure given by interviewer

Q1. Tell me about a project you faced difficulties?
Add your answer
Q2. Given a table ..asked some SQL questions
Add your answer

Q1. Shared a table ...asked to write some SQL queries
Add your answer
Q2. Sman queries result how to derive in excel
Ans. 
Use Excel functions like VLOOKUP or INDEX/MATCH to derive results from SQL queries in Excel.
• Use VLOOKUP function to search for a value in a table and return a corresponding value from another column.

• Use INDEX/MATCH function to perform a two-way lookup by matching values in two different ranges.

• Import SQL query results into Excel using data connection or copy-paste method.
Answered by AI
Add your answer

Basis CAT like aptitude with 2 simple python coding question

Q1. What Central limit theorem
Ans. 
The Central Limit Theorem states that the sampling distribution of the sample mean approaches a normal distribution as the sample size increases.
• States that the sampling distribution of the sample mean will be approximately normally distributed regardless of the shape of the population distribution

• Helps in making inferences about the population mean based on the sample mean

• Important concept in statistics and hypothesis...read more
Answered by AI
Add your answer

Q1. SQL QUERY QUESTIONS ON JOINS
Add your answer

Q1. Excel basic formulas like lookup
Add your answer

Q1. About Yourself, resume grilling
Add your answer

Python, SQL, Quant, Statistics, Numpy

Q1. SQL, Python, Puzzle total 9Q
Add your answer
Q2. Table, Query, 2 puzzle, Python 1 code (4 Sub code)
Add your answer

Q1. Yet to declare result for the round 2 i feel +ve for round 2 result lets se
Add your answer

Q1. What is your opinion about business?
Ans. 
Business is the backbone of the economy, driving innovation, growth, and prosperity.
• Business plays a crucial role in creating jobs and generating income for individuals and communities.

• It fosters competition, which leads to improved products and services for consumers.

• Businesses contribute to economic development by investing in infrastructure and technology.

• They provide opportunities for entrepreneurship and innovatio...read more
Answered by AI
View 1 more answer
Q2. Why business is important
Ans. 
Business is important because it drives economic growth, creates jobs, and fosters innovation.
• Business drives economic growth by producing goods and services that meet the needs and wants of consumers.

• Businesses create jobs by hiring employees and providing them with income and opportunities for career growth.

• Businesses foster innovation by investing in research and development, driving technological advancements.

• Busin...read more
Answered by AI
View 1 more answer

Q1. Asking about yourself and asking of other knowledge and consulting knowledge.
Add your answer

Q1. Sumifs Functions
Add your answer
Q2. Vlookup Function
Add your answer