FX & conversion analytics
— currency mix · fee burden · Q3 + Q4 performance queriesPerformance queries — 3-table joins
Q3 — f_transaction (currency mix) · Q4 — f_conversion → f_transaction → d_company (fee burden)
Q3 shows transaction volume split by currency, revealing platform FX exposure.
Q4 measures total FX fee revenue per company — larger companies generate more fee volume.
Both queries join across multiple fact tables; Q4 uses NULLIF to guard against zero base_amount division.
FX analytics — currency mix & fee revenue
f_transaction · f_conversion · d_company
Currency converter
Live rates · converts any currency to USD
→ USD equivalent
—
Company USD valuations
Total revenue converted at live rates · updates every 5s
| Company | USD Valuation |
|---|---|
| Loading… | |