Impact Analytics Senior Business Analyst Interview Questions and Answers

Q1. Resultant rows for different SQL joins
Ans. 
Resultant rows for different SQL joins
• Inner join - returns rows that have matching values in both tables

• Left join - returns all rows from the left table and the matched rows from the right table

• Right join - returns all rows from the right table and the matched rows from the left table

• Full outer join - returns all rows when there is a match in either left or right table
Answered by AI
Add your answer
Q2. Group by and join SQL questions involving nulls
Add your answer

The test covered questions around stats (mean, median, etc), python, SQL and aptitude questions

Q1. Write a python code for the Fibonacci series.
Q2. Write a SQL code find the mean salary for every department.
Q3. Write a SQL code to find the employee age at the time of joining the company.
Q4. Rewrite the above queries in Python.

Q1. Python questions, write a SQL query to return employee with the number of leaves in each month, Vlookup, Index Match, Rank, Dense Rank
Add your answer
Q2. Loc and iloc in python
Ans. 
loc and iloc are methods in pandas used for selecting rows and columns by label or integer position.
• loc is used for selecting rows and columns by label

• iloc is used for selecting rows and columns by integer position

• Example: df.loc[0:5, 'column_name']

• Example: df.iloc[0:5, 2]
Answered by AI
Add your answer
Q3. Advantage of Vlookup over-index match
Ans. 
Vlookup is simpler and easier to use, while Index Match is more flexible and efficient.
• Vlookup is easier for beginners to understand and use

• Vlookup is quicker to set up and requires less formula writing

• Index Match is more flexible as it can look up values in any column, not just the first one

• Index Match is more efficient for large datasets as it does not require the entire column to be searched
Answered by AI
Add your answer
Q4. Difference between BRD and FRD
Ans. 
BRD focuses on business requirements while FRD focuses on functional requirements.
• BRD (Business Requirements Document) outlines the business problem that needs to be solved.

• FRD (Functional Requirements Document) details how the system will meet the business requirements.

• BRD is more high-level and focuses on the 'what', while FRD is more detailed and focuses on the 'how'.

• BRD is typically created before FRD in the projec...read more
Answered by AI
Add your answer
Q5. Retail experience and analysis
Ans. 
Retail experience and analysis
• I have over 5 years of experience in retail industry analysis

• Proficient in using data analytics tools to track sales trends and customer behavior

• Implemented strategies based on market research to increase sales and customer satisfaction

• Collaborated with cross-functional teams to optimize inventory management and pricing strategies
Answered by AI
Add your answer