Entitlement and billing reconciliation
Recover the revenue your market data has already earned
Unbilled revenue and revenue at risk, found for every subscriber, every month.
Licenses in Salesforce, entitlements and invoices on the platform, usage reports from subscribers: four documents, three systems. This POC checks them against each other on a production-shaped platform, and every figure comes from one governed definition. Try the live app below, or ask Morgan, our analyst, in your own words.
- 1SQL ServerThree source systems, change tracking on
- 2OpenflowChange data capture, in our own AWS network
- 3SnowflakeLanding, reconciled to the source
- 4dbtBronze, silver and gold, tested
- 5Semantic Layer17 metrics, defined once
- 6Hex and MorganThe app and the analyst
The reconciliation, live
One data provider, twelve months of licenses, entitlements, usage reports and invoices. The app asks the Semantic Layer each time you change the month. We use Hex here for convenience: every figure comes from the Semantic Layer, so the same app runs in Tableau, through dbt's connector, or in any BI tool.
- Pick a month
- Hover an indicator for its dollars
- Click it for the figures behind them
How we know the numbers are right
An answer key, computed from the generated cases and never from the platform, is checked at every layer.
Subscriber, product and month rows equal the answer key, every check and dollar.
25,705 rows in SQL Server, 25,705 landed in Snowflake.
Models, seeds, tests and unit tests pass in development and Production.
The app and Morgan read the same 17 metrics, so they cannot disagree.
Go deeper
The business
Market data licensing from the exchange to the subscriber, and where reconciliation fits.
The platform
Openflow in our own AWS network, level by level, from the VPC to the connector.
Ask Morgan
Our analyst answers in plain words and shows the query behind every figure.
Build log
How it was built, step by step with its commands, and how it is proven.
Ask about any month
Which subscribers cost the most in November? Why is subscriber 43 unbilled? Morgan answers from the same governed metrics as the app.
Ask Morgan