Credit Saison Lead Business Analyst Interview Questions and Answers

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. 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

The interview asked in SQL coding he was not in the intention of recruiting me he was Mr.kishlay shukla who was senior analytics manager in Myntra .He was in a hurry while starting itself .He was continuously moving and went way and coming back and saying enough do coding for next question.He was distracting me.Continously talking with some other colleagues.

If he don't want to interview me he could have informed the HR .And I was continuously calling HR caren rodrigues to tell her this and to know about the interview result but she didn't pickup my call

Seriously very worst experience with Myntra .

Q1. SQL question about joins on table having null values
Add your answer
Q2. SQL question on lead/lag/cummulative sum application
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. Basic SQL Questions
Add your answer
Q2. Basic Case study
Add your answer

Q1. SQL Joins and all
Add your answer
Q2. Case study on dominos
Add your answer

MCQ Mostly - Aptitude and Time Distance

RCA - Drop in Metrics

Q1. SQL & Pythonassad
Add your answer

Q1. HR went through the resume and asked me do the do the same? General questions about: 1. where have you studied from - 10th, 12th, Grad, Post Grad? 2. 10th, 12th, Undergrad and Postgrad marks (they require ...read more
Add your answer

Q1. HR head : who went through my resume and did same what HR did - but this time in writing and discussing in detail.
Add your answer

Q1. National Sales Manager/Head: Went through CV again and asked few questions related to work and technicalities of work.
Add your answer

Q1. VP - Sales : Did same thing. And asked few questions related to interest , passion, work and team handling.
Add your answer