Portfolio
Project listed on Microsoft’s Data Stories Gallery
EPC summary
Background info to EPC slides
Questions to ask the EPC data
Q – how many rental properties below band C?
Q – how many properties to move above band D?
Q – how many properties have mains gas heating?
Analysing Domestic Housing Energy Performance Certificates (EPC)
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.
The report created can be found here.
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.
Project listed on Microsoft’s Data Stories Gallery
Community spirit + Hackathons + Open Data = Aberdeen Harbour Ship Arrivals 1914-1920 data story
By bringing together a community of individuals with different skills, organising hackathons and making the data open, the ship arrival records for Aberdeen Harbour, UK for the period from 1914 to 1920 have been opened up for anyone to explore and use.
The Project: From Aberdeen Harbour’s physical records, the pages were photographed, the words on the images were transcribed into Google Sheets, a website was created to access the data and this data story was borne.
From the data story you can see the types of ships coming into the Harbour, the imports required to sustain the region, the ports from which the ships set sail for Aberdeen, and from comments made in the records by the staff you can feel their pride in ‘firsts’, their joy when celebrating events, and their profound sadness at the devastations of war.
A link to the report can be found here.
Huge thanks to all the transcribers, Code the City Aberdeen, & Aberdeen City and Aberdeenshire Archives for all time, effort and work which has gone into this project.
Further work is ongoing to tidy up the data so this project is not yet complete, but meantime the achievements by a community with a shared interest coming together to make this project happen can be enjoyed.
A video showing how to navigate the tables and bar charts can be found on YouTube.
A video demonstrating how to pull in extracts from Wikipedia, as used on page 4 of this project, can be found here on YouTube.
Project listed on Microsoft’s Data Stories Gallery
Connecting Wikidata to Power BI using R
Description
Provides the ability to run a query written for Wikidata and create a dataset from the output for import into Power BI.
Example
Taking Wikidata relating to the location of where ships were wrecked off the coast of Scotland UK and plotting these locations on a map provided by esri which shows oil & gas licencing blocks on the UK Continental Shelf. This provides an example of how easy it can be to combine two different resources into one map.
YouTube
Videos demonstrating the techniques used in this project can be found at:
Create a Wikidata Query – example using Shipwrecks data
Map Wikidata in an R Shiny App – example
Bring Wikidata into Power BI using a simple R script – example
Data for this project
The open data used in this project was uploaded to Wikidata during a hackathon held in November 2020. More information on the hackathon can be found in the following blog:
Portfolio on Github
Summary of coding skill learnt whilst undertaking a course at Codeclan Edinburgh, Robert Gordon University (RGU) Aberdeen, and as a contributor to hackathons.
Robert Gordon University
The Resourcing and Vessels repositories are an example of a couple of projects created whilst studing for a MSc in IT with Business Intelligence.
Codeclan
In 2018 I completed an intensive full-time 19 week professional software development course at the digital skills and coding academy Codeclan in Edinburgh, UK.
I contributed to 65 projects during the course. Overview of projects can be found here.
Hackathons
I enjoy participating in hackathons mainly those orgainised by Code The City Aberdeen. A few of these hackathons have led to the data stories mentioned above. I’ve participated in more hackathons than those listed on my personal Github account. Details of some of these hackathons can be found on the Blog tab.