Back to products
AggregateIQ BI
In productionTrading · for aggregator staff
Commission run files in, answers out. The analytics engine is about 5,900 lines of SQL running inside Postgres, which is why a full book recalculates in seconds rather than overnight.
What it does
- Commission run ingestion with reconciliation against your own totals
- Broker, lender, book vintage, trend and referral partner analysis
- A pivot builder with saved views, and exception reconciliation
- A 36 month scenario model verified against the source workbook
How it connects
- With CRMSettled volume is joined to the recruitment record, so you can see what a hiring decision returned.
- With ManageGoals track automatically against live commission figures instead of being updated by hand.
- With PortalA broker sees their own figures from the same run, with no separate export.
Send one month of commission data
We load it, reconcile it against your own totals, and walk you through what it shows.