Credit Saison Lead Business Analyst Interview Questions and Answers

Q1. Basic SQL and Excel Questions
Add your answer
Q2. Tell me about yourself
Ans. 
I am a highly motivated and results-driven individual with a strong background in business development and project management.
• Graduated with a degree in Business Administration from XYZ University

• Worked as a business development manager at ABC Company for 5 years

• Successfully led a team to increase sales by 30% in the last quarter

• Proficient in project management tools such as Asana and Trello
Answered by AI
Add your answer

Q1. Guesstimate on how many Burgers a shop will sell in a day
Ans. 
It depends on the location, popularity of the shop, menu offerings, and customer traffic.
• Consider the location of the shop - is it in a busy area or a residential neighborhood?

• Take into account the popularity of the shop - is it a well-known chain or a new establishment?

• Menu offerings can also impact sales - do they offer a variety of burgers or just a few options?

• Customer traffic throughout the day will also play a ro
Answered by AI
Add your answer
Q2. You role at previous company
Ans. 
I was responsible for managing client accounts and developing new business opportunities.
• Managed client accounts to ensure satisfaction and retention

• Identified and pursued new business opportunities to drive revenue growth

• Collaborated with cross-functional teams to deliver solutions tailored to client needs
Answered by AI
Add your answer

Q1. Strengths and Weakness
Add your answer
Q2. Why Swiggy
Ans. 
Swiggy is a leading food delivery platform with a strong presence in the market.
• Swiggy has a wide range of restaurant partners offering diverse cuisines.

• The platform provides quick and efficient delivery services to customers.

• Swiggy offers various discounts and deals to attract and retain customers.

• The user-friendly app interface makes ordering food convenient for customers.
Answered by AI
Add your answer

Q1. SQK Questions joins
Add your answer

Case study on planning

Case study on planning

Q1. General questions
Add your answer

Q1. Sales & Onboarding Related
Add your answer
Q2. Business & E-commerce Business
Add your answer

Q1. Sql round basic to advance questions in star format answer
Add your answer

Q1. Sql python and dashboard then amazon leadership questions
Add your answer

Q1. Tell me about a time when you deep dived into an issue? What were the outcomes?
Add your answer
Q2. Tell me about a time when you came up with a metric. What was the metric? How was it used to determine the business goals?
Ans. 
I developed a customer satisfaction metric to measure the success of a new product launch.
• Identified key factors influencing customer satisfaction

• Designed a survey to collect feedback on these factors

• Created a scoring system to quantify satisfaction levels

• Analyzed survey results to track changes over time

• Used metric to adjust marketing strategies and improve product offerings
Answered by AI
Add your answer

Q1. Joins and their output
Ans. 
Joins are used in SQL 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

• 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 the right table

• RIGHT JOIN re...read more
Answered by AI
Add your answer
Q2. Employees who earn more than their manager
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. What about indiaMART?. Tell me about internship experience? Why you joint indiamart?
Add your answer

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