analysis-qa

Review Checklist

Work through every section below before presenting findings to stakeholders.

Data Foundation

• Correct sources: Confirmed that the tables and datasets used are the appropriate ones for this question
• Freshness: Data recency is sufficient; the "data as of" date is noted
• Coverage: No unexpected time gaps or missing segments in the dataset
• Null treatment: Null rates in critical columns have been reviewed; nulls are excluded, filled, or explicitly flagged
• Duplicate control: Row counts confirm no double-counting from faulty joins or repeated source records
• Filter accuracy: Every WHERE clause and filter condition has been verified; nothing is accidentally excluded or included

Computation Integrity

• GROUP BY correctness: All non-aggregated columns appear in GROUP BY; the aggregation grain matches the analytical question
• Denominator validity: Rates and percentages use the intended base population; division by zero is prevented
• Temporal alignment: Compared periods span equal durations; partial periods are either excluded or called out
• Join behavior: JOIN types are intentional (INNER vs. LEFT); many-to-many relationships have not silently inflated totals