Portfolio

 

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.

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:

Hackathon – Plotting Shipwrecks Off The Coast of Scotland

Portfolio on Github 

My github account

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.

Pin It on Pinterest

Share This