Amazon Business Intelligence Analyst Interview Questions and Answers

Q1. Write SQL to print the user with the highest restaurant order. There are couple of joins to be used.
Ans. 
Use SQL with joins to find user with highest restaurant order
• Use JOIN to connect user table with order table

• Group by user and sum the order amounts

• Order by sum in descending order and limit to 1 result
Answered by AI
Add your answer

Statistical Analysis related questions

Q1. Coding and data structure
Add your answer

Q1. ML Breadth and depth
Add your answer

Q1. Explain past projects
Add your answer

Q1. Explain resume points
Ans. 
Resume points are concise descriptions of your work experience, skills, and achievements listed on your resume.
• Resume points should be clear, specific, and quantifiable.

• Use action verbs to start each point, such as 'developed', 'implemented', 'analyzed'.

• Include relevant metrics or results to demonstrate impact, such as 'increased sales by 20%' or 'reduced processing time by 30%'.
Answered by AI
Add your answer

SQL - shared question on the screen and asked to code in SQL

Q1. Nth highes salary
Add your answer

Q1. Maximum sum subarray
Add your answer
Q2. Machine Learning Concepts
Add your answer

SQL test on hackerrank

SQL and Math are judged in this round

Analytical and Presentation skills are judged in this round

Q1. Stakeholder management, situational questions, STAR methodology
Add your answer