Sears Holdings Senior Business Analyst Interview Questions and Answers

Digital Supply Chain based case study.

Q1. Why do you want to work at Alshaya?
Add your answer
Q2. Are you comfortable in moving to Kuwait?
Ans. 
Yes, I am comfortable in moving to Kuwait.
• I have previous experience working in international locations.

• I am open to new experiences and cultures.

• I have researched about living and working in Kuwait and feel prepared for the move.
Answered by AI
Add your answer

Opening of new stores

Sql, data visualisation

Q1. Prepare All theoretical questions related to SQL and excel. Learn everything about your resume so that you will be able to explain each and everything about the resume.
Add your answer
Q2. Difference between Vlookup and Xlookup ?
Ans. 
Vlookup searches for a value in the first column of a range and returns a value in the same row from a specified column. Xlookup is a more powerful and flexible function that can search in any direction and return multiple results.
• Vlookup searches vertically in a table and returns a value from a specified column.

• Xlookup can search in any direction (horizontal, vertical, or both) and return multiple results.

• Vlookup requ...read more
Answered by AI
Add your answer
Q3. Difference between Subquery and CTE. Which is better?
Ans. 
Subquery is a query nested within another query, while CTE is a temporary result set defined within a query. Both have their own use cases.
• Subquery is enclosed in parentheses and can be used in SELECT, INSERT, UPDATE, or DELETE statements.

• CTE is defined using the WITH keyword and can be referenced multiple times in a query.

• CTEs are more readable and easier to maintain compared to subqueries.

• Subqueries are useful when t...read more
Answered by AI
Add your answer
Q4. No of records returned after applying left and inner join on 2 tables.
Add your answer
Q5. Pivot the table in SQL using case when statements.
Ans. 
Pivoting a table in SQL using case when statements
• Use the CASE WHEN statement to create new columns based on specific conditions

• Use the SUM or COUNT function to aggregate data in the pivoted table

• Group by the remaining columns to ensure correct aggregation

• Example: SELECT id, SUM(CASE WHEN category = 'A' THEN value END) AS A_total FROM table_name GROUP BY id;
Answered by AI
Add your answer

Business Case Questions Based on a scenario where the company's Sales is Declining. How we can address the issue using transaction data

Q1. Tell me about your self
Ans. 
Experienced business development executive with a proven track record of driving revenue growth and building strong client relationships.
• Over 5 years of experience in business development

• Successfully increased sales by 30% in previous role

• Skilled in identifying new business opportunities and negotiating deals

• Strong communication and interpersonal skills

• Bachelor's degree in Business Administration
Answered by AI
Add your answer

Q1. SQL and Visualizationbased questions
Add your answer

Case study for business problems

Q1. Behaviour fit round
Add your answer

Q1. SQL situation based questions
Add your answer

Q1. Have good understanding of the projects
Add your answer

Q1. Tell me about yourself
Ans. 
I am a dedicated and detail-oriented Business Analyst with a strong background in data analysis and problem-solving.
• I have a Bachelor's degree in Business Administration

• I have 5 years of experience in analyzing business processes and identifying areas for improvement

• I am proficient in using data analysis tools such as Excel, SQL, and Tableau

• I have a proven track record of successfully implementing process improvements ...read more
Answered by AI
Add your answer
Q2. Few BA related questions
Add your answer

Q1. Salary discussions
Add your answer
Q2. How did you know about the opening
Add your answer