1.Analyzing Escrow and Market Trends
KPI cards and line charts · 2026
A real estate finance analyst utilized a dashboard to track escrow deposit expansion and housing market trends from January 2015 to January 2026. The analysis features KPI cards showing a Median Sale Price of $403.2K and a Mortgage Rate of 6.11%, alongside a Peak Quarterly Price of $442.6K. A dual-axis chart plots median sale price against mortgage rates, highlighting a higher-rate regime, while an indexed comparison shows a Current 3% Escrow of $12.1K, solving the challenge of aligning mismatched quarterly price and weekly rate data to illustrate a 40%+ expansion in required escrow deposits.
What it shows:
How to visualize macroeconomic trends to inform deposit requirements.




