Senior Business Intelligence Specialist Interview Questions and Answers

Lookup is used to search for a specific value in a dataset, join is used to combine two datasets based on a common key, and merge is used to combine datasets based on common columns.

• Lookup is used to find a specific value in a dataset

• Join is used to combine two datasets based on a common key

• Merge is used to combine datasets based on common columns

• Example: Lookup - searching for a customer's email address in a customer dataset

• Example: Join - combining sales data with customer ...read more