Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

  1. Monthly

  2. 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

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)

  •  Are we able to make any short to mid term predictions based from this data?
  •  Does outside of London property sales look set to surpass London?
  •  How have outside of London property rates grown in the past 24 months? Is this trend continuing?

All Pages: Footer

  •  Property sales data: Land Registry February 2022
  •  IMD: Office of National Statistics
  •  Developer: Datawonders: Steve Martin

...