Project Overview
This project analyzes housing affordability and market trends in the Austin, Texas metro area from 2018 to 2024. It integrates Excel for initial data cleaning, SQL for structured querying, and Power BI for dashboard visualization. The goal is to provide insights into housing prices, rent levels, mortgage burdens, and income growth to better understand affordability shifts in a rapidly evolving market.
Key Visuals & Metrics
- 📈 Median Home Prices vs. Median Rent (2018–2024)
- 📊 Affordability Index by ZIP code
- 📌 Price-to-Income Ratio Trends
- 🗺️ Interactive Map of Median Prices by Region
Tools Used
- Excel: Data cleaning and preprocessing
- SQL: Structuring, aggregating, and joining datasets
- Power BI: Visualizing affordability and price trends
Next Steps
The project is ongoing. Future updates will include: deeper ZIP-level analysis, integration with income tax and property tax datasets, and user-driven dashboard filters to explore affordability scenarios.