19. What does the grain of a dataset mean, and why establish it before calculating a metric?
EasyAnalysis & visualization
Technical
Show model answer
Grain describes what one row represents, such as an order, an order line or a customer-day. The same customer or transaction can legitimately appear many times at a finer grain.
State the intended counting unit before aggregating or joining. Check candidate keys and a few sample records. A correct-looking SUM or COUNT can still answer the wrong question if the row unit differs from the business unit.
What interviewers listen for
- Define one row
- Check keys
- Match aggregation to the question