Amazon Business Intelligence Engineer Online Assessment - 60 minutes through hirepro.in platform.

• Statistics (10q : 10 or 15 mins)
  • Basic Probability and Distributions.
• Dashboarding (5q : 5mins)
  • Tableau only.
  • mostly on kinds of charts available and best charts for category/numerical, etc.
• SQL (4q : 20 or 25 mins)
  • MySQL only, no Window functions such as RANK, DENSE_RANK, etc. allowed.
  • 1-2 table joins.
  • mostly on SUM, COUNT and other aggregate functions.
  • Offcourse, with GROUP BY and HAVING.
• Python/R (2q : 20 mins)
  • Second largest and second smallest number in a given array.
  • Reverse digits in the start and end of a string, leaving the middle letters intact, for example, given input: 123abc456 expected output: 321abc654

Good Luck!