All work
Power BI · MySQL
Finance Intelligence Suite
ASC 606-compliant revenue tracking, customer segmentation, and payment insights, simulating data extracted from ERP, stored in MySQL, and transformed via SQL views. Users can explore contract-level trends and milestone obligations for revenue recognition analysis.
- ASC 606
- Subscription vs product revenue
- Contract drilldown
- Billing analysis
What it demonstrates
- ASC 606 revenue recognition
- Milestone and subscription revenue are kept as separate fact streams, so performance obligations can be reviewed independently rather than netted together.
- Segmentation carried to contract level
- Customer and product segments join through to individual contracts, so a segment-level view and a contract-level view reconcile against each other.
- Payment behavior alongside revenue
- Invoicing and payment events are modeled next to revenue, exposing the timing between an obligation being satisfied and cash arriving.
- Contract drilldown
- Contract trends and milestone obligations are explorable from the summary view down to a single line item.
Live
The dashboard
Loading