Factspan Senior Business Analyst Interview Questions and Answers

Q1. Write a query to obtain the third transaction of every user
Ans. 
Query to retrieve the third transaction of every user
• Use a subquery to rank the transactions for each user

• Filter the results to only include the third transaction for each user
Answered by AI
Add your answer
Q2. Write a query that outputs the name of the credit card and how many cards are issued in it's launch month
Ans. 
Query to output the name of credit card and number of cards issued in launch month
• Use GROUP BY to group by launch month

• Count the number of cards issued in each launch month

• Select the name of the credit card and the count of cards issued
Answered by AI
Add your answer

Q1. 2 Technical rounds questions on SQL and ML
Add your answer

Q1. Python SQL spark AWS and big data
Add your answer
Q2. Python SQL pyspark aws
Add your answer

Prepare well on basics of SQL, Python and Machine learning

Q1. Prior experiences, Future growth, case studies
Add your answer