Two datasets disagree about active customers. How would you reconcile them?
Interactive Practice Mode
Formulate your thoughts or take notes before revealing the model solution.
Saved automatically
Model Answer & Deep-Dive Explanation
Agree on a precise definition of active customer, including date window, timezone, account status, and treatment of trials or deleted accounts. Compare source lineage, refresh times, identity mappings, and join cardinalities. Reconcile counts through progressively narrower stages and inspect specific records present in only one result. Watch for duplicate customer identifiers and event-based joins that multiply rows. Document the root cause, create a reproducible reconciliation query, and assign an owner for the metric. Choosing whichever count looks more plausible does not resolve the inconsistency.
Related Questions in Data Science & Analytics
What questions should you ask before filling missing values in a dataset?
Easy level • 6 views
Why can an overall conversion rate improve while conversion falls in every major segment?
Medium level • 6 views
How would you design an A/B test for a new signup page?
Medium level • 6 views
How do mean and median behave differently when salaries contain extreme values?
Easy level • 3 views
A dashboard shows revenue rose 20%. What would you check before calling it business growth?
Medium level • 2 views