Analytics Engineer Assessment

Data Analyst Assessment: The Number Was Right. The Table Had Duplicates.

Give an analyst clean tables and a clear question and nearly everyone looks capable. Here are four tasks on a deliberately messy database, duplicated rows, nulls that mean two different things, a timezone that moves a month boundary, and a number that disagrees with finance.