← All projects
Housing Market Trends Dashboard · Personal project · Solo

Comparing U.S. housing markets across states, metros and price tiers

A Power BI dashboard built on six Zillow datasets, covering U.S. housing trends from 2013 to 2026.

Power BIData modelingStar schemaExcel
6

Zillow datasets combined into one model

2013–2026

Years of housing data covered

4

Filters: state, metro, price tier and date

Image to come
Dashboard screenshot
The dashboard, with KPI cards, a state map and filters.

The goal

Compare housing market trends across states, metro areas and price tiers over time.

Data & tools

Six Zillow datasets: home values, sale prices, inventory, new listings, days pending, and price cuts. I cleaned them in Excel and built the model and dashboard in Power BI.

What I did

  • Cleaned and prepared the 6 datasets in Excel.
  • Built a star-schema data model linking them through shared date and metro dimension tables.
  • Designed an interactive dashboard with KPI cards, a state map, and state, metro, price-tier and date filters.
Image to come
Data model diagram
The star schema linking the six datasets through shared date and metro dimension tables.

Findings

What the dashboard showed: notable trends, regions or price tiers that stood out.

What I learned

One or two sentences on what you took away from building it.

Let's talk

Looking for Summer 2027 internships and Spring 2027 co-ops, and open to relocating anywhere in the U.S. Email is the best way to reach me.