Overview

The dashboard is designed to make it easy to see overall numbers of properties and corresponding rent and vacancy levels for registered housing providers as reported to the Regulator of Social Housing in the most recent Statistical Data Return. The dashboard is built in Microsoft Power BI and consists of three pages of similar three panel layout, navigable via the buttons at the top.

Panel 1 - On the left are the overall (big) numbers showing the number of properties (or rent or vacancies) based on the current selections on the page.

Below the big numbers is a map (see snapshot) showing the local authorities. In the Rent pages, the more red the bubble, the higher the rent and the bigger the bubble, the more properties. For the vacancies map, the more red the bubble, the higher the vacancy rate whilst the bubble size shows the number of vacant units. In the stock map, the is no colour scale, but the large the bubble, the more the units. The map is not drillable, but can be used to select a particular local authority by clicking on a bubble, which then filters the rest of the page. Click on the map again to de-select.

Panel 2 - In the middle section of each page is a bar chart, which can be drilled from the region to the local authority (use the symbols above the chart - described on the right, which can take a little getting used to).

Below is a simple time line showing how the selected properties change over time. The default year is 2023 and the data in the page can be changed via the year buttons in the banner at the top.

Below the time line is a simple table of counts and rates as appropriate. Note that a line of the table can be used to filter the rest of the page. For example to see the number of Supported Housing properties across regions and providers, just click on that line of the table. Click on it again to de-select.

Next to the simple table is a filter of provider type (Stock and Vacancies pages) and Rent type (Rent page). Note that the Provider Type is synchronised and will affect the selection in the Rent page as well.

To combine filters, hold down the CTRL key when using the consecutive filters (within the same component or across components), for example in the Rent page, select General Needs (in the property type table) and London (in the region bar chart) and Bexley (in the map).

Panel 3 - On the right is a bar chart at the entity level and above that is a selector to find a particular housing group. This selector is synchronised across the three pages. The filters based on a graphical object operate on their own page only (for example clicking on a region in the middle bar chart will filter the whole page to that region) and they do not synchronise to the other pages.

If the mouse is moved over the map or bar charts, a time line of the selected count or value will appear.

Source

All social housing data are taken from the Regulator of Social Housing, https://www.gov.uk/government/collections/statistical-data-return-statistical-releases.

The most recent Excel files were downloaded and, where possible, the equivalent worksheets were accessed in each year. The Local Authority names and codes are taken from Local Authority Districts (April 2019 - April 2021) Names and Codes in the United Kingdom, published by the Office for National Statistics, available at data.gov.uk.

Stock and vacancies information was taken from SDRxx_Stock_Infomation_by_LA (where xx is 18, 19, 20, 21 or 22 depending on the year)

Rent information is taken from SDRxx_GN_Rents_Comb, SDRxx_SHHOP_Rents_Comb, SDRxx_SHHOP_Rents_Comb, SDRxx_ARSHHOP_Rents

Details about the organisations are taken from the following sheets SDRxx_Entity_Level_Information and SDRxx_Group_Structure

More details on definitions can be found on the RSH website, the actual values were cross-checked against the RSH PRP tool, there were some slight deviations in the earlier years for the Affordable Rent values, so these should be treated with extra caution.

Disclaimer

This dashboard is provided as an example of an interactive report built in Microsoft Power BI. All data were taken from published sources but we cannot guarantee that, despite our best efforts, errors were not made in the processing of the data. As a result, we cannot accept any liability for use of this dashboard.  

The dashboard is copyright Musgrave Analytics and has been built by Simon Musgrave and Róbert Lukács, evolving from previous work by Jon Willis and Daniel Fitton.