Real-time visibility for advisory leadership, with deadlines flagged before they slip.
The context
Advisors were running 25+ portfolio reviews a week, and leadership needed a real-time view of them. Late reviews put advisory-fee revenue at risk, and a missed required minimum distribution (RMD) brings IRS penalties.
What I did
- Built self-serve Power BI dashboards and KPI frameworks, later adopted org-wide.
- Built an auto-refreshing control dashboard that flags at-risk review deadlines.
- Built an RMD exception monitor that runs automated age-based checks.