Justin Kelly
This page details the notes for the VALA 2023 TechCamp PowerBI Workshop All files are available on GitHub at: https://github.com/justinkelly/vala_2023_techcamp_powerbi Introduction About me What is PowerBI What the focus is today 80% will be about visualisation and dashboard creation Links Files that will be used in the workshop: bit.ly/vala23-powerbi-files Detailed notes for the workshop:…
Summary For legible pages from World War 1 handwritten diaries held at the State Library of Victoria, AI services are able to correctly transcribe them at an level between 10% to 49% accuracy. For pages with a low level of accuracy, sections transcribed correctly add to the narrative of the diaries and further our understanding of the authors experience. Furthermore, even with a low level of…
Summary 21 of the 25 volumes of the Jenkins diaries have been transcribed at near perfect level of accuracy over an approximate 13 years by State Library of Victoria (SLV) staff and volunteers. 3 volumes where transcribes by the AI based web service Biblio.ai in approximately 5 hours at a level of accuracy of between 40% and 83% (excluding impossible to read, totally damaged or extremely hard to…
One thing I always forget when logging into a new Linux server is is how to set the default shell. The below command sets the default to bash chsh -s /bin/bash From the man page for chsh The chsh command changes the user login shell. This determines the name of the users initial login command. A normal user may only change the login shell for her own account, the superuser may change the login…
This page details the notes for the VALA21 TechCamp PowerBI Workshop All files are available on GitHub at: https://github.com/justinkelly/vala_2021_techcamp_powerbi Introduction About me What is PowerBI https://bit.ly/vala21_powerbi_pres What the focus is today 80% will be about data, data formats and data structure Thinking about what’s in the files, how do we connect them, and if there is no…
Summary For automated transcription of audio recordings to text, with the focusing on accessibility and historical recording - Azure from Microsoft currently is the best performing cloud service. For state and national libraies - automated transcriptions are now accurate enough that they can be used as is (for search results and in the user interface) Introduction As part of my State Library of…
Summary For automatic transcription of most historical handwritten cursive script documents, Microsoft Azure is the most accurate computer vision provider, with the exception for very hard to read documents where Google Cloud leads. Scaled scores: MS Azure: 91 Google Cloud: 89 Amazon AWS: 11 Sample of the MS Azure transcription of the George Swinburne diary Table of contents Introduction…
The Australian Bureau of Statistics (ABS) published their data set of the 2017 Australian Marriage Law vote today in Excel format. So far I’ve only seen the results of this election by State. Personally I find the results by federal electoral region more interesting. Thankfully importing ABS data and Australian Electoral Commision(AEC) map files into Tableau is straight forward so we can easily…
If you are new to the AWS RedShift database and need to create schemas and grant access you can use the below SQL to manage this process Schema creation To create a schema in your existing database run the below SQL and replace my_schema_name with your schema name CREATE SCHEMA my_schema_name; If you need to adjust the ownership of the schema to another user - such as a specific db admin user run…