1.Automating Multi-Step Financial Data Pipelines
heatmap and summary table · 2026
This dashboard presents a state-level tax burden comparison for Texas, New Mexico, and Mississippi based on IRS Statistics of Income (SOI) microdata. A weighted state summary table shows Texas with $1.23K in real estate tax per return, compared to $519 for NM and $360 for MS, while mortgage interest per return is $1.31K for TX, $1.36K for NM, and $966 for MS. The central heatmap maps the three states against six income tiers, illustrating a higher real estate tax burden in Texas that peaks at $9.70K for the >$200k bracket, compared to $4.40K in NM and $3.99K in MS.
What it shows:
How to automate a multi-step data pipeline to empirically test financial claims.




