Open Data

Ahoy there! Did you know that you can track the location of vessels? All you need is the AIS data transmitted by the vessel. AIS data provides a wealth of information including current location, course, and speed all of which can all be used to make waves in the field of data analytics.

At CTC Hackathon in November 2021 the Waste Wizards team gathered to help plot Household Waste Recycling Centres (HWRC) and their facilities on Open Waste Map through updating Open Street Map. 

#worldbookday2022 Discovered last month that some illustrations for The Frog Prince, a fairy tale by the Brothers Grimm, are held by Aberdeen Archives, Museums and Galleries (AAGM). I came across the artwork whilst taking part in a wiki editathon. Couldn’t resist giving The Frog Prince it’s own page (page 3) in this very draft report - https://lnkd.in/eRa97d4S

This example shows how easy it is to insert Wikipedia extracts into a Power BI report using the Wikimedia API.

Over 23,000 ships have been wrecked off the coast of Scotland. I was astounded when I discovered that figure as it’s far higher than I would have guessed. I quickly went from being astonished to being quite sombre thinking about how many lives would have been lost at sea. Why am I telling you this? Well …..

This example shows how easy it is to insert Wikipedia extracts into a Power BI report using the Wikimedia API.

Follow along practical example – In an R script upload a spreadsheet, manipulate the data by pivoting columns, and then producing a line chart with data points.

How are Scottish companies and organisations using open data? What data originating in Scotland has been made open to the world. Those were the questions posed at 2020 Scottish Open Data Unconference

It’s easy to plot items onto a map using Power BI. With a few clicks data can be gathered, a map created, and markers plotted onto the map. Simple!