Data Analysis & Information Management
With a background in project management and business analysis, moving, interpreting and sharing data is a big part of my life. Consequently, I just love a good spreadsheet.
Mention spreadsheets and invariably, Microsoft Excel springs to mind. Indeed, I'm as enthusiastic about Excel's Power Query as the next person. However, in recent years I've become a power user of
It's a superb tool for collaboration and/or remote working, has a clean UI and for 95% of Excel users, is "good enough." Having used SQL, I find Google Sheets'
to be extremely powerful and use it extensively. I'm also using
Google Apps Script
more and more.
You can get in touch with me here.
Data Analysis: I've probably got a spreadsheet for that
Here you can access live examples of how I can import, transform and visualise data using Google Sheets. Note, I could achieve similar with Microsoft Excel too if need be.
85+ live Google Sheets - This shared Google Drive folder lists practical and creative uses of my function/formula knowledge. Click on an example to open up a sheet and review in your browser
Wales Six Nations Web App - Disappointed by the lack of a decent Welsh-focused app for the 2020 Six Nations rugby tournament, I made my own using the fantastic
Glide platform, powered by Google Sheets. As you'll see, it got a bit out of hand with the data I ended up crunching!
Below are some dashboards and tools I've published to the web from Google Sheets.
COVID-19 UK Daily Cases - An all too topical example of how publicly available data can be imported directly into Google Sheets, parsed with QUERY and used to power a dynamic dashboard
2019 General Election - This re-models and visualises live data imported from a publicly shared Google Sheet
4 years of Todoist - I'm a long-time user of
Todoist and, in recognition of me using my knowledge to help folk get the most out of the platform, I'm now one of a select band of
for it too. Combining data from each of the "your year in review," summaries Todoist has issued since 2016, Google Sheets helped me gain some further insights on my usage of this excellent task management application
Todoist Template Generator - This tool makes it easier to produce project templates and also ensure timelines can be changed dynamically before importing. I also maintain
my own expanded guide to the natural language inputs for due dates and times that can be used with Todoist
Google Maps - A map of Welsh SIMM summit peaks, built from both online data and the what3words API
PDF Data Extraction - An example of how data held within PDFs can be extracted as CSV files for use in spreadsheets using Tabula
Six Nations - Wales Win/Loss analysis - A creative use of Sparklines to visualise Wales' performance over the the 21 years of the Six Nations
Six Nations - England v Wales - Analysis of the 22 halves of rugby played between the 2 teams in the Six Nations at Twickenham
Wales v England - All results from 2000 - References live Wikipedia data and updates its insights automatically whenever Wikipedia gets edited
RWC 2019 pool stage analysis - Again, transforms Wikipedia data to deliver insights on the pool stage of the Rugby World Cup held in Japan
Information Management: Apps & Services
A power user of both macOS and iOS, I automate tasks using a variety of apps and services.
Highlighting my preference for portability, information relating to how I integrate the services I use with each other, is presented in differing formats below.
myMindNode - An interactive, online mind map made with MindNode on macOS and iOS
Web page - Mind map above exported as Markdown and converted inline with this script
PDF presentation - Mind map exported as Markdown and converted to slides using Deckset
Dropbox Paper - Mind map exported as Markdown and rendered as an online outline
Workflowy - Mind map exported as OPML and published as an online outline