Analysis of house prices in Bath, their affordability and market activity from 1995 to 2025

Tableau Dashboard #1 Comparing Two Towns/Cities

Tableau Dashboard #2- Bath House Dashboard

This is the second dashboard of the housing project in which I focus on Dashboard #2 and the houses within Bath. My other notion page is available here, I refer to this as Dashboard #1.

1. Project Overview

Objective for Dashboard #2

Buying a home is one of the largest financial decisions an individual can make with market conditions dictating house affordability. Having made the decision to move to Bath, I have made this project to analyse historic house price data and inflation adjusted averages to explore house prices, income ratios and sales of houses in Bath over time.

This analysis is designed to give evidence for a prospective buyer of a property in Bath.

Problem Statements for Dashboard #2

I aim to answer these questions:

• How have house prices changed over time in Bath using real time and inflation adjusted values?
• How affordable is Bath relative to local incomes?
• How do prices vary by property type, tenure and postcode?
• Do current market conditions favour investment, renting or long-term occupiers?
• Weston and Bear Flat have been suggested as good areas to move to for families. Are either of these possible as someone moving from Ealing on a budget of £425k? (The average flat from Dashboard #1)

Tools & Methodology

• Excel was used for initial data exploration and light preparation of the smaller data files.
• I accessed my database using SQL Server Management System (SSMS). 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:
  • Understanding house prices within Bath
  • Understanding the change over time of house prices in Bath

Table Structure for Housing Data