Business Question: Is housing still affordable in New Mexico—and for how long?
Tools Used: Excel, Data Cleaning, Time-Series Analysis
Summary: This project tracks median home prices and income over time to evaluate the changing affordability landscape across New Mexico counties. I applied multi-year data cleaning and transformation to create visual dashboards and identify red flags.
Highlights:
- Mapped historical price vs income changes
- Created affordability index using household income vs home cost
- Identified counties at high risk of housing crisis
Note: Inspired by real-world challenges in my home state, this project combines personal insight with analytical depth.