Marketplace Seller Analytics Path · Mission 12 of 25Hard

GMV-vs-payout drift detection (Q1 2026)

First three-table reconciliation. Practice joining fact_settlements to fact_orders to dim_marketplaces, computing the gap between gross and net per (marketplace, month), and producing the drift-detection report the CFO uses to spot fee-rate anomalies.

The Brief

You'll practice

Multi-system joinDiffThreshold flag