This analysis compares housing affordability in Ealing and Bath, comparing trends in prices, rents, and wages.

Tableau Dashboard #1 Countrywide Dashboard

Tableau Dashboard #2- Bath House Dashboard

My wife and I are deciding whether it is a good price to sell our flat in London and buy elsewhere, which is the inspiration for this project. I have created two dashboards for the housing project, both of which are linked above. For this page I am going to focus on Dashboard #1. My other notion page is available here and I refer to this as Dashboard #2. This second notion page adds details of the database I used for both projects. I have however included one of my SQL queries in the appendix for this dashboard.

1. Project Overview

Objective for Dashboard #1

To analyses comprehensively the cost of houses over time by creating a tool that can asses:

General trends in house prices over time by region including:
- House price to pay ratios to determine if house prices are over-inflated vs average salaries at this point in time.
- House price to rent ratios to determine if it is actually better to rent or buy at this point in time.
Impact of “Tenure”, “Property Type” and being a “New Build” has on house price between two locations in the UK

Problem Statements for Dashboard #1

Is it a good time to buy or rent?
Is it a bad time to sell in Ealing London?
Will Bath be more expensive than Ealing to purchase?

Tools & Methodology

Excel was used for initial data exploration and light preparation of the smaller data files. It was also used to merge indices for rental data.
SQL Server Management System (SSMS) was used to query data in SQL Server**.** This ****was used for data exploration, creating relationships between my data and preparing data for manipulation. It supported ongoing checks to validate results throughout the dashboarding process.
Tableau was used to build comprehensive dashboards with distinct analytical focuses:
- A high level comparative overview of two towns/cites in England
- A high level overview of rent, house price and wage ratios in England

Table Structure for Housing Data

This project analyses the entirety of the Price Paid Data supplied by HM Land Registry. More details of this are in available in Dashboard #2.

All links to data is available within the appendices. Here is a selection of my most used columns from the selected tables.

Column Name	Description/Entry	Table
Year	Year(Int)	DimDate
Price	Price of sale	Fact_PPD [1]
Property Type	Semi Detached, Flat, Detached, Terraced	Fact_PPD [1]
Tenure	Freehold, Leasehold	Fact_PPD [1]
Old/New Build	New Build, Existing	Fact_PPD [1]
Longitude	Longitude ordinate of the postcode	DimGeog [2]
Latitude	Latitude ordinate of the postcode	DimGeog [2]
Town/City	Names of towns and cities mapped to Postcode using SAGA GIS and region polygons [9]	DimGeog [9]
Region	Regions in England	DimRegion [2]
Catagory Type	A (regular house sales)	Fact_PPD [1]
Median Wages	Median wages by year	Fact_Wages [7]
Median Rent	Median rent by year	Fact_Rent [3][4][5]