Part 5/8:
Candidates should be well-versed in Excel, particularly in lookup functions. An alternate to the traditional VLOOKUP is the use of INDEX-MATCH.
Types of Lookups:
VLOOKUP: Vertical lookup for data retrieval by column.
HLOOKUP: Horizontal lookup.
XLOOKUP: Combines functionality of both VLOOKUP and HLOOKUP.
Understanding Relationships, Joins, and Blends in Data Tools
Interviewers often explore familiarity with data visualization tools:
Relationships: Links between tables based on common fields.
Joins: Methods to combine tables based on shared columns, including inner, outer, and left/right joins.
Blending: Combining data from different sources to create a unified dataset.