Kearney Senior Analyst Interview Questions, Process, and Tips

Excel Questions related to Pivot

Q1. Guestimate was asked
Add your answer
Q2. Advanced Excel questions
Add your answer

Q1. Basic questions on recruitment.
Add your answer

Q1. Technical recruitment process question.
Add your answer
Q2. Xray search strings
Add your answer

Market Intelligence on Selected Topic

Q1. Why do you want to Switch?
Ans. 
Seeking new challenges and growth opportunities in a different environment.
• Looking for new challenges and opportunities for growth

• Interested in expanding my skill set and knowledge

• Seeking a change in work environment or company culture
Answered by AI
Add your answer
Q2. Why do you want to Join Us?
Ans. 
I am impressed by your company's innovative approach and strong reputation in the industry.
• I am drawn to the company's commitment to innovation and cutting-edge technology.

• I admire the company's strong reputation in the industry and its track record of success.

• I believe that my skills and experience align well with the company's goals and values.
Answered by AI
Add your answer

Q1. All questions were industry specific
Add your answer

Q1. How do you calculate market size and share?
Ans. 
Market size is calculated by multiplying the total number of potential customers by the average price of the product. Market share is calculated by dividing a company's sales by the total market sales.
• Market size = Total number of potential customers x Average price of the product

• Market share = Company's sales / Total market sales

• Data sources for market size and share include surveys, industry reports, and sales data

• Ma...read more
Answered by AI
Add your answer
Q2. What is supplier scouting?
Ans. 
Supplier scouting is the process of identifying and evaluating potential suppliers for a company's procurement needs.
• It involves researching and analyzing potential suppliers' capabilities, quality, reliability, and pricing.

• Supplier scouting helps companies find the best suppliers to meet their specific needs and requirements.

• It can involve attending trade shows, networking events, and conducting site visits to evaluat...read more
Answered by AI
Add your answer

Q1. Most of the interview was focused around SQL combine with case study assessment.
Add your answer
Q2. Explanation of joins
Ans. 
Joins are used in databases to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column between them

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from th...read more
Answered by AI
Add your answer
Q3. Order of execution concept
Ans. 
Order of execution concept refers to the sequence in which instructions are executed in a program.
• Instructions are executed in the order they appear in the code unless specified otherwise.

• Some programming languages have specific rules for order of execution, such as PEMDAS in mathematics.

• Understanding order of execution is crucial for debugging and optimizing code.

• Example: In Python, arithmetic operators follow the PEM
Answered by AI
Add your answer
Q4. Explanation on nulls
Ans. 
Nulls are placeholders for missing or unknown values in a database.
• Nulls represent the absence of a value in a database field.

• Nulls are different from empty strings or zero values.

• Nulls can cause issues in database queries if not handled properly.

• Nulls can be used to indicate missing data or unknown values.

• Nulls can be replaced with default values or handled using functions like COALESCE.
Answered by AI
Add your answer

Q1. This was taken with Director which focused mainly on behaviour, career plans and other relevant scenario and ethics.
Add your answer

Q1. Describe about yourself
Add your answer

Q1. WHat projects you have done in past and describe that?
Add your answer