Make Over Monday: 1 Hour Visualization Challenge

This week we were challenged to visualise vacancy rate data for the many homes across the U.S. that sit vacant. There are just over 5.6 million vacant housing units across the nation’s 50 largest metropolitan areas.

Below you can find the steps I undertook to plan the visualisation

Notes on the data 

MSA data field merged city/town combination with state. Explored the possibility of splitting this field until further research on characteristics of MSA’s ruled this out

Two types of metrics (estimate and error of margin) for every location. 

Occupied, total and vacant values for every location. After exploring the data it became clear combining occupied and vacant fields did not equal the total housing field 

Plan

User Story no.1

Needs to understand how the distribution of available housing impacts vacant property levels across metropolitan areas. 

By discovering if there is a relationship between total housing units and vacant housing units 

By analysing how many vacant properties vary as % of total available housing units

Sketch

https://public.tableau.com/app/profile/gabriel.louks.kirwan/viz/WorkOutWeds02/Dashboard1?publish=yes

Author:
Gabriel Louks-Kirwan
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab