The comparison between the
staging_database and production_database shows persistent small differences (0.1-0.5%) that don't reconcile, suggesting either a calculation mismatch or schema drift. Before we investigate data quality, should we first ensure the two systems are using the same query logic?Yep.
Why is the weekend slice so much smaller? Is something wrong with the day-of-week parsing? (edited to fix a unit)
Nice — the Q3 view helps.
Year definition changeDefinitely.
Not sure what
baseline is measuring.Works for me. (edited to fix a unit)
For background: the UK changed reporting in 1997, which is why Q1 seems odd.
Clear.
Decimals are inconsistent between the US and Brazil.