Saxo Bank Senior Business Analyst Interview Questions and Answers

Excel question
Excel case study

Case study of Rupeek website

Quantitative aptitude, verbal ability, critical reasoning

Q1. SQL: find store with highest AOV
Add your answer
Q2. Generic behavioural questions
Add your answer

I had a very bad interview experience. The interviewer didn't start with any introduction and immediately jumped into asking case study. After giving a case, he would leave for a few minutes, which made it seem like he was not interested in the process.

Questions asked:
Q1: You are an Analyst at UBER. The gross cab cancellation rate daily is 5% whereas on a particular day, it goes up to 10%. What could be the factors affecting the same?
To analyze the same list down the tables required in the database along with all the columns and write the query using the same table name & columns to find the required metrics.

Q2: Assume you work for YouTube Music and the CEO wants you to create a Business Health Dashboard. List down all the metrics the CEO will be interested in looking at.

Q1. A tough sql question
Add your answer

Q1. How would you copy a large dataset
Ans. 
Use a data migration tool to copy the dataset efficiently.
• Utilize a data migration tool like AWS Data Pipeline, Apache Nifi, or Talend to copy the dataset.

• Break down the dataset into smaller chunks to avoid overwhelming the system.

• Ensure proper data validation and error handling during the copying process.

• Consider using parallel processing to speed up the copying process.

• Monitor the progress of the dataset copying to t
Answered by AI
Add your answer
Q2. Do you think data analysis job is overrated?
Ans. 
No, data analysis job is not overrated as it plays a crucial role in decision-making and problem-solving.
• Data analysis helps in identifying trends and patterns in data

• It provides valuable insights for businesses to make informed decisions

• Data analysis is essential for optimizing processes and improving efficiency

• It can uncover hidden opportunities and potential risks

• Many industries rely on data analysis for strategic p
Answered by AI
Add your answer

Data Representation, Logical Reasoning

Q1. Why do you want to join HighRadius?
Add your answer

Q1. Tell me something about yourself
Add your answer

Q1. Why do we hire you?
Add your answer
Q2. Will you be able to takeover the pressure?
Add your answer
Q3. What if you get failed in convincing the banker?
Ans. 
I would analyze the reasons for the failure and try to address them in my next attempt.
• I would ask for feedback from the banker to understand their concerns.

• I would research and gather more information to strengthen my argument.

• I would try to build a relationship with the banker to gain their trust.

• I would explore alternative options and present them to the banker.

• I would seek advice from colleagues or mentors to impro...read more
Answered by AI
Add your answer