Interactive BA Interview Study Guide

LEFT JOIN: Returns all rows from the left table and matching rows from the right table.
RIGHT JOIN: Returns all rows from the right table and matching rows from the left table.
FULL JOIN: Returns all rows when there is a match in either table.

Your Progress

Check off questions as you master them to see your progress update in real-time.

Select a topic to view the questions. Use the search bar to filter questions by keywords like "VLOOKUP", "JOIN", or "DAX".