25 Years of UK Housing 1996 - 2021

Problem statement

“The UK housing market has seen a lot of turbulence since 1996: successive governments have continually attempted to control the market, for better or for worse”

Taking and enriching publicly available data published monthly by the Land Registry, lets analyse the data and see what we can come up with

Directional Steer

The plan is to try to keep this dashboard short, maybe 5-6 charts on each page to help keep the viewer focussed.

The dashboard needs to be as interactive as possible, with simple theming and an easy to understand navigation solution.

Plan to build an entry page, describing the work in hand, and use this to provide some high-level indices, with 3-4 other pages:

Project Title	Unknown
Working Title	A 25 Year Analysis of the UK Property Sales Market
Longevity	Long-term
Type (Report / App)	Multi-page interdependent app
Audience	Any interested party
Publish Location	Publicly Accessible (Tableau Public)
Data Compression Level (Grain)	Unknown / row-level
Purpose	To provide a focussed analysis of the UK real property market to help users make informed decisions based on the current state of play. Looking to add an element of forecasting to the tool as well
Data Source(s)	1. (primary) UK Land Registry Price Paid data 2. (enrichment) Office of National Statistics: National Statistics Postcode Lookup
Data refresh times	Monthly Twice yearly
Data Connection	Embedded
Scaling	None at present, possible future enrichment with the UK Police Data
Interactivity	Fully interactive local filter and global parameter driven
Project Status	Started
Project Start Date	11/03/2022
Project Delivery Date

In Scope:

Section	Tasks

Section	Tasks
Page 1: Summary & Narrative	Introduction and explanations BAN: Year with the highest numbers of sales BAN: Year with the lowest numbers of sales BAN: Average frequency for a home re-sale Statement: how the sales price has changed in the last 10 years Statement: How long did it take for the market to return to pre-crash levels Grouping: Last 12 months of property price rises
High-Level Summary (This page might not go in)	New build vs Existing, has the proportion changed in 25 years? How frequently are new-builds sold on on average compared with existing builds By how much has the average price increased year on year over the last 10 years?
Existing Builds pg(4)	Of the property types, what is the average length of ownership? What has been the property demand for the different property types? How stable is the asking price? HAs this seen large and or unwieldly price gains or losses?
New Builds (pg3) ”Lets look at the new build sector” ”There is an overall concern that there is not enough houses to meet demand, lets take a look at sales over the last 5 years, and identify where construction is taking place, and whether the properties could be deemed affordable”	Where are the greatest numbers of developments? of the property types, what is the average length of ownership? How has the market changed over the years for property type Leasehold vs Freehold for all but Flats: Is this really a growing concern A distribution of sorts eg pareto or histogram # Sales / £ Sales Heatmap
Regional Analysis (pg2)	What types of housing are we seeing in the different regions? Which regions see the highest, and which regions see the lowest number of resales? Which regions have seen the greatest increases in the last 10 years? What is the volume of property sales and what is the median sales value in areas of high deprivation
Market problems (pg5): 2008 Global Financial Crash & 2020 Covid 19 Pandemic	How long did it take for the market to return to pre-crash levels Has Covid-19 substantially stunted growth? How has the market altered compared to 2008? Were there really more sales outside of London compared to inside during 2020-22?
The Future (pg6)
All Pages: Footer