Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
07-26-2023 03:53 AM - last edited 07-27-2023 01:47 AM
Analysing Domestic Housing Energy Perfomance Certificates (EPCs)
Background
Often the reason for making improvements to an existing building is to improve its energy efficiency. To aid with measuring energy efficiency a property is assessed and assigned a rating in an Energy Performance Certificate (EPC). The rating is assigned to a band ranging from A to G, with A being the most energy efficient and G being the least.
The project
For EPCs issued for during the years 2021 and 2022 in Scotland, UK, the data for two geographical areas (being Aberden and Aberdeenshire) are analysed and put into diagrams to aid with answering three questions. These questions are based upon proposed legislative changes in Scotland. The questions consider how many properties within the data set will require improvements to:
- bring them within the proposed minimum energy efficiency bands or
- satisfy the requirement to move away from fossil fuel boilers.
Data
The data used in this project is public sector information licensed by the Scottish Government under an Open Government Licence v3.0. The original property references have been removed and replaced by an index column (named Reference No.) in the report.
Disclaimer
I take no responsibility for the contents of the report or the quality or accuracy of the data contained therein.
Pauline Cairns
For Data Analysis and Visualisation
Data For Knowledge (website)
Microsoft Certified Power BI
eyJrIjoiMWI1YTI3MzEtZTgxMi00OGM5LWIwMmItMGEzZjFhMjAyZjgxIiwidCI6IjBlMTkwZTMwLTM3YWItNDA1My05OTY2LTg3MTAzYTdmZDRkYyJ9